Role overview
This position supports a federal healthcare data program that distributes information to researchers studying ways to improve care for chronically ill Medicare and Medicaid beneficiaries. The Database Developer works on a chronic conditions data warehouse, ingesting new sources, building views that integrate datasets, and keeping production operations reliable. The work is performed in a government contractor context and supports CMS-aligned research and policy innovation.
Responsibilities
- Ingest new data sources into the chronic conditions data warehouse, expanding access to healthcare data for research use.
- Build, optimise, and maintain data views that integrate new and existing datasets with a focus on accuracy, clarity, and usability for analysts and researchers.
- Design and support ETL workflows in a cloud data warehouse such as Snowflake, ensuring reliability and scalability of data loading operations.
- Support production operations, including rotation-based responsibilities for ETL loads that may run off-hours or on weekends.
- Document processes and business logic to create reliable technical references for audits, troubleshooting, and onboarding.
- Collaborate with data analysts, technical leads, and program partners to align data structures with end-user needs and proactively resolve database or performance issues.
Requirements
- Bachelor's degree in data science, computer science, information systems, or a related field.
- 2+ years of experience as a Database Developer, ideally in a government or healthcare setting.
- Hands-on experience with SQL, Python, ETL development, and Snowflake data warehouse concepts.
- Understanding of data management best practices including permissions, recovery, security, and monitoring.
- Familiarity with front-end requirements and the ability to translate business needs into backend solutions.
- Knowledge of development tools such as the .NET Framework, JavaScript, HTML, and Oracle, plus strong communication and a proactive problem-solving attitude.
Nice to have
- Prior experience supporting CMS or similar federal health data programs.
- Experience with Snowflake or other modern cloud-based data warehouses.
- Exposure to AI or machine learning techniques for data quality and anomaly detection.
Benefits and work setup
- Salary range of $80,000 to $95,000 per year, with compensation described as competitive and transparent.
- Medical, dental, and vision insurance; HSA and FSA; life and disability coverage.
- 15 days of paid leave, 7 days of sick leave, 2 days of bereavement leave, and 11 paid federal holidays, plus up to 40 hours for jury duty.
- Up to 4 weeks of paid paternity and maternity leave, a 401(k) with a 4% employer contribution and no vesting period, and a $5,000 annual professional development budget.
- Company-provided laptop, $600 per year for technical supplies, a $2,000 referral bonus, and voluntary legal and ID shield benefits.
- Flexible working hours and remote opportunities, with employment contingent on acceptable background investigation results and the ability to obtain and maintain a Public Trust security clearance.