Information Technology - Enterprise Data Architecture

Think Cosmopolitan: we’re all about the home. Owned by Romain and Kim Dubus, we’re a small family business expending at a fast pace, the goal of the team is inspiring folks from all walks of life to take ownership of their spaces & create value where they’re planted.


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.


  • 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


  • 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


  • 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

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 at (323) 747-8207.


Please send all applications to with the subject "Employment Application"