Data Engineer - Data Analytics / BI

Ampcus - Santa Monica, CA

Full-time

Santa Monica, CA

Professional, Scientific, and Technical Services

About the position

The Data Engineer plays a crucial role in enhancing health informatics and analytics within the health sciences sector. This position focuses on the design, development, and support of a terabyte-scale enterprise data warehouse, ensuring high usability and performance. The Data Engineer is responsible for developing data extraction, transformation, and load (ETL) processes, collaborating with various stakeholders, and supporting junior developers. The role requires writing efficient code and understanding both clinical and operational data issues to drive improvements in healthcare outcomes.

Responsibilities

• Contribute to ongoing development of technical best practices for data movement, data quality, data cleansing, and other ETL-related activities.
• Create automated processes to validate and translate data for landing in the enterprise data warehouse.
• Review requirements and participate in the design of data models.
• Design and Build Master Data Models for Reference datasets like Providers and Payors.
• Develop and consume REST APIs to ingest data from third party sources.
• Design and develop new data processing systems using various ETL tools and languages like Python/SSIS and open source technologies.
• Design and develop data pipelines and processes that effectively populate the enterprise data warehouse and downstream data marts.
• Participate in meetings with technical peers regarding solution design.
• Communicate with business analysts, data modelers, and solutions architects regarding specific development activities and ETL.
• Understand and implement best practices for tuning and optimization.
• Develop and maintain both source code and related documents.
• Translate advanced business analytics problems into technical approaches that yield actionable recommendations, communicate results, and educate others through design and build of insightful visualizations, reports, and presentations.
• Maintain technical proficiency in data warehousing technologies beyond classic Microsoft Stack such as Big Data and cloud technologies.
• Work with organizational stakeholders to identify business requirements and expected outcomes.
• Create clear documentation of workflows, process flows, methodologies used, and complex logic for various levels of technical expertise.
• Collaborate with other UCLA Health IT teams (OHIA, ISS, and DGIT).

Requirements

• Five plus years of strong work experience in the design, development, and support of terabyte scale data warehouses.
• Strong SQL programming skills, particularly Microsoft SQL Server and Oracle.
• Strong understanding of relational and dimensional modeling, data mining, and ETL design processes.
• Experience in Master Data Management and Data Quality initiatives is highly preferred.
• Programming expertise in languages like C# or Python.
• Strong experience in Business Intelligence tools like SSIS, SSRS, and SSAS.
• Expertise in database architecture, storage, and Query Optimizer.
• Good architectural understanding of reporting tools like Tableau and PowerBI.
• Experience working in an agile software development environment is a plus.
• Work experience with healthcare data is preferred.

Nice-to-haves

• Experience in Master Data Management and Data Quality initiatives.
• Programming expertise in languages like C# or Python.
• Experience working in an agile software development environment.