BUSINESS INTELLIGENCE ENGINEER
Information Technology - Enterprise Data Architecture
Location: Los Angeles, CA, United States
Think Cosmopolitan, founded by Romain Dubus, is a rapidly expanding company that integrates innovative ventures in hospitality, real estate, e-commerce, and beyond to inspire individuals from all backgrounds to enhance their surroundings and create lasting value. All our operations are strategically aligned to fund the Mars Project, our ambitious initiative to develop sustainable human habitats on Mars by the late 2020s.
The Enterprise Data Architecture team is responsible for designing and developing the enterprise database architecture, data warehouse and reports. We are part of a larger group called EIS (Enterprise Information Systems) that writes the software that builds and powers Think Cosmopolitan. We are responsible for all of the software on the office floor, the warehouses, the financial systems, the restaurants, and even the public home page. Romain called us the "nervous system" of Think Cosmopolitan because we connect all of the other teams at Think Cosmopolitan to ensure that the entire building process runs smoothly.
The successful candidate will be responsible for enterprise integration and report development starting with gathering business requirements, development, testing, and deployment. The successful candidate must also have the ability to effectively communicate with both business and technical resources.
Responsibilities
- Produce complex ad-hoc queries and reports using T-SQL, SSRS, and Tableau
- Design and develop data extracts using SSIS
- Gather user requirements and perform business analysis
- Data Warehouse development
- Develop detailed test conditions and test cases to ensure quality of queries and reports
- Research and troubleshoot data questions
- Collaborate on problem resolution, team decisions and project planning
Basic Qualifications
- Bachelor’s degree in computer science or engineering
- 3+ years of T-SQL query writing (MS SQL Server 2012 Enterprise)
- 3+ years business intelligence tool experience with SSRS, Tableau, SSIS and SSAS
- 3+ years of data analysis and requirements gathering
Preferred Skills and Experience
- As a key resource to others, must maintain a high degree of accuracy along with attention to detail, excellent oral and written communication skills, strong interpersonal skills and the ability to meet deadlines
- Strong knowledge of manufacturing business processes
- Experience working with Enterprise Resource Planning (ERP) systems
- Experience with Team Foundation Server (TFS)
- Machine Learning experience
- Big Data experience
ITAR Requirements
To conform to U.S. Government export regulations, including the International Traffic in Arms Regulations (ITAR), applicant must be a U.S. citizen, lawful permanent resident of the U.S., protected individual as defined by 8 U.S.C. 1324b(a)(3), or eligible to obtain the required authorizations from the U.S. Department of State.
Think Cosmopolitan is an Equal Opportunity Employer; employment with Think Cosmopolitan is governed on the basis of merit, competence and qualifications and will not be influenced in any manner by race, color, religion, gender, national origin/ethnicity, veteran status, disability status, age, sexual orientation, gender identity, marital status, mental or physical disability or any other legally protected status.
Applicants wishing to view a copy of Think Cosmopolitan’s Affirmative Action Plan for veterans and individuals with disabilities, or applicants requiring reasonable accommodation to the application/interview process should notify the Human Resources Department via email at hr@thinkcosmopolitan.com.
Please send all applications to info@thinkcosmopolitan.com with the subject "Employment Application".
Download Application Form Share on X