Data Warehouse Engineer
About The Position
Tri Pointe Homes is looking for an experienced, enthusiastic individual to join our talented group as a Data Warehouse Engineer. This role involves designing, building, and maintaining database structures and data warehouse models, transformations, and integrations, efficiently managing the nuances of a cloud database platform. The engineer will develop, test, enhance, and maintain complex data solutions, including dimensional data marts, and ensure reliable data integration and retrieval. Employing agile development with modern data warehousing techniques and technologies, the position aims to deliver lean, flexible, and functional solutions. Responsibilities include conducting technical analysis, developing solution options, documenting key technical metadata and test scripts, and partnering closely with analysts and contractors to set and enforce high-quality standards. The role also involves serving as a technical SME for key technologies and data sources across multiple business domains, standardizing key metrics and dimensions within data structures and BI solutions, and simplifying complex analysis. Collaboration on multiple projects to produce quality solutions and demonstrating initiative in problem-solving are key aspects of this position.
Requirements
- Bachelor’s Degree in Computer Science, Math, Computer Engineering plus 3 years of work experience in Data Warehouse Engineer, Business Intelligence (BI) Data Analyst, Data Analyst, or related occupation OR Master’s Degree in Computer Science, Math, Computer Engineering, plus 1 year of work experience in Data Warehouse Engineer, Business Intelligence (BI) Data Analyst, Data Analyst, or related occupation
- Creating and maintaining code around data warehouse development, data integrations, and data modelling
- Advanced SQL knowledge
- Demonstrated data integration and ETL (Extract, Transform, Load) skills
- Advanced skills in SSIS (Sequel Server Integration Services) platform
- Proficiency in Python coding language for data transformations, data libraries, and data science
- Demonstrated knowledge/abilities in SQL Server DB
Responsibilities
- Design, build and maintain database structure/data warehouse models, transformations, and integrations
- Efficiently manage the nuances of a cloud database platform
- Develop, test, enhance and maintain complex data solutions of lasting value, including dimensional data marts
- Maintain/support reliable data integration and retrieval
- Employ agile development with modern data warehousing techniques and technologies to deliver lean yet highly flexible and functional solutions
- Conduct technical analysis and develop solution options
- Document key technical metadata and test scripts
- Partner closely with analysts and contractors while helping set and enforce high quality standards
- Serve as technical SME (Subject Matter Expert) of key technologies and data sources across multiple business domains
- Standardize key metrics and dimensions within data structures and business intelligence solutions
- Simplify complex analysis
- Collaborate concurrently on multiple projects to produce quality solutions
- Demonstrate initiative and effectiveness in problem solving
Benefits
- Great Place to Work Certified Company
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
