Data Systems and Analytics Engineer

This is a fully remote position, open to applicants in Colorado, +5 more states.

📋 Description

• Design, construct, and sustain automated, scheduled, and monitored ETL/ELT pipelines.

• Ingest data from databases, files, APIs, and web platforms into cloud databases and data warehouses.

• Clean, validate, and transform raw data into analysis-ready datasets, complete with data dictionaries, codebooks, and documented derivation logic.

• Ensure data accuracy through automated validation checks, independent quality control, and thorough reproducibility documentation.

• Maintain code in Git, conducting code reviews and documenting systems, pipelines, and dashboards.

• Safeguard sensitive health data by employing de-identification, data minimization, access controls, encryption, and audit logging.

• Develop record linkage and entity resolution processes across various data sources.

• Standardize data to common formats and manage metadata for search and discovery.

• Create relational data models, views, and stored procedures for analysis and reporting purposes.

• Provide support to analysts and biostatisticians with derived variables, matched comparison datasets, and reproducible analysis files.

• Present metrics and outcomes in publication-ready tables, figures, dashboards, and reports.

• Design, build, and maintain interactive dashboards and visualizations using Tableau, Power BI, or custom frameworks.

• Ensure that dashboards and reports comply with Section 508 and WCAG accessibility standards.

• Gather user requirements, prototype layouts, and refine outputs based on feedback.

• Collaborate with project managers, biostatisticians, data managers, and external partners.

• Articulate technical approaches to both technical and non-technical audiences.

• Utilize AI tools, such as Claude Code, for pipeline solutions and as a component of overall solutions.

• Act as the technical lead and system architect for comprehensive data platforms.

• Develop and uphold data governance practices and standard operating procedures.

• Execute data operations in accordance with SOPs, document compliance and corrective actions, and provide staff training.

• Lead technical planning, estimation, architecture planning, and risk mitigation efforts.

• Offer technical guidance, conduct code reviews, and provide mentorship.

• Assess emerging technologies and recommend enhancements for infrastructure, automation, and performance.

⛳️ Requirements

• Bachelor's degree in computer science, data science, statistics, informatics, or a related field.

• Five (5) years of increasingly responsible experience in data engineering, programming, or reporting development.

• Advanced SQL proficiency, including data modeling, views, stored procedures, and query optimization within relational databases.

• Proficient in Python or R for data processing and automation, with a working knowledge of SAS.

• Proven experience in developing reports and dashboards using Tableau, Power BI, or a custom framework.

• Experience in building and maintaining ETL pipelines, encompassing data validation and error handling.

• Familiarity with Git in a collaborative workflow environment.

• Ability to convert user requirements into data models, pipelines, and report designs.

• Strong focus on data accuracy and thorough documentation.

• Excellent organizational and communication abilities.

• Demonstrated technical leadership, including the design of data system architecture and processes, establishing technical standards, and mentoring technical personnel.

🏝️ Benefits

• Remote work arrangement.

• Minimal overnight travel, capped at 5%.

• 40 hours per week.