Role Overview
The Data Systems and Analytics Engineer turns raw research and program data into trusted datasets, analyses, and live reporting for federal health research programs. The role spans the full data lifecycle: ingesting and preparing data, modeling it for analysis, and presenting results through dashboards and automated reports.
What You Will Do
Design, build, and maintain automated ETL/ELT pipelines, clean and validate raw data, build record linkage and entity resolution processes, harmonize data from multiple sources, design relational data models, and present complex metrics and outcomes clearly.
Why It Might Be a Fit
The ideal candidate combines strong data engineering skills with the design sense to present information clearly in dashboards, live reports, and publication-ready outputs. The role also provides technical leadership, serving as architect for data systems and processes.
Requirements
- Bachelor’s degree in computer science, data science, statistics, informatics, or a related field
- Five years of progressively more responsible experience in data engineering, programming, or reporting development
- Advanced SQL skills, including data modeling, views, stored procedures, and query optimization in relational databases
- Proficiency in Python or R for data processing and automation; working knowledge of SAS
- Demonstrated experience in report and dashboard development, including production dashboards or live reports in Tableau, Power BI, or a custom framework
- Experience building and maintaining ETL pipelines, including data validation and error handling
- Experience with version control (Git) in a collaborative workflow
- Demonstrated ability to translate user requirements into data models, pipelines, and report designs
- Strong attention to data accuracy and documentation
- Excellent organizational and communication skills
- Demonstrated experience providing technical leadership, including designing data system architecture and processes, setting technical standards, and mentoring technical staff
Benefits
- Dental insurance
- Vision insurance
- Health insurance
- 401(k) or other retirement plan
- Paid time off
- Paid holidays
- Life insurance
- Disability insurance
To apply for this job please visit recruiting.ultipro.com.
Follow us on social media