Senior Data Engineer

4h4 hours ago

eSimplicity

Columbia, US · Full-time · $132,400 – $151,800

About this role

eSimplicity is a modern digital services company that partners with government agencies to improve lives and protect well-being. This Senior Data Engineer position is contingent upon contract award and focuses on Medicaid program data systems.

You will design, develop, and maintain scalable data pipelines that ingest, reconcile, and validate Medicaid data from MESH and connected CMS systems. Your work will power the Master Detailed Budget Table modernization, including parsing legacy formats and validating calculations.

You will build data processing workflows on AWS services like S3, Glue, EMR, Athena, and Redshift, as well as Databricks and Spark. You will create data products feeding Power BI dashboards and Salesforce reports with consistent definitions and data-quality indicators.

You will implement automated data quality and validation jobs, support AI/ML pipelines for the MESH platform, and write unit and integration tests. You will also perform code reviews, mentor less experienced engineers, and maintain data security controls consistent with CMS ARS 5.1 and FedRAMP Moderate baselines.

Requirements

All candidates must pass public trust clearance through the U.S. Federal Government, requiring U.S. citizenship or appropriate VISA/work permit documentation
10+ years of hands-on software development experience with 4+ years of data pipeline experience using Python, Java, and cloud technologies
Strong understanding of AWS data services including S3, RDS, Redshift, Glue, EMR, and Athena
Experience building and deploying data processing workflows with CI/CD tools like GitHub Actions and Terraform
Experience with data quality, validation, and reconciliation processes in a healthcare or government data environment
Proficiency in SQL and data modeling for analytical and operational data stores
Familiarity with data security and privacy controls including encryption and least-privilege access

Responsibilities

Design, develop, and maintain scalable data pipelines that ingest, reconcile, and validate Medicaid program data from MESH and connected CMS systems
Build and operate data ingestion workflows supporting mixed-modality content including spreadsheets, documents, API feeds, and enterprise data services
Implement the data layer for Master Detailed Budget Table modernization, parsing legacy and modern formats and validating state and federal share calculations
Develop API services for bidirectional data integration between MESH (Salesforce) and external systems such as T-MSIS
Build big-data processing workflows on AWS (S3, Glue, EMR, Athena, RDS/Redshift) and optionally Databricks, Spark, and Hive
Create data products that feed Power BI dashboards and Salesforce reports with consistent refresh schedules and data-quality indicators
Implement automated data quality, validation, and reconciliation jobs to flag anomalies like funding decreases or mismatched FFP rates
Support AI/ML pipelines for the MESH platform by providing curated, governed training and inference data