ShiftCode Analytics, Inc. · 1 day ago
Senior Data Engineer - DHCF
Washington, DC
Full-time
Hybrid
Senior Level
7+ years expShiftCode Analytics, Inc. is looking for a Senior Data Engineer to support the DHCF's data modernization efforts associated with its Medicaid data ecosystem. The role involves maintaining the current legacy environment and leading the execution of the cloud modernization roadmap.
AnalyticsConsultingInformation Technology
No H1B
U.S. Citizen Only
Responsibilities
ETL Management: Maintain, troubleshoot, and modify complex SSIS packages handling high-volume Medicaid claims, provider, and member data
Version Control: Manage code deployments and branching strategies within TFS, ensuring continuous integration of legacy SQL assets
Legacy Reporting Support: Support and optimize SSRS report queries and SSAS tabular/multidimensional models to ensure federal and state compliance reporting remains uninterrupted
Cloud Development: Implement "Medallion Architecture " (Bronze/Silver/Gold) using Azure Databricks (PySpark/SQL) as designed by the Lead Architect
Pipeline Refactoring: Lead the transition of legacy SSIS logic into Azure Data Factory (ADF) and Databricks notebooks
DevOps Transformation: Facilitate the migration of source control and CI/CD pipelines from TFS to Azure DevOps (Git)
Synapse Integration: Build and tune Dedicated and Serverless SQL Pools within Azure Synapse to facilitate advanced analytics and AI-readiness
Medicaid Compliance: Implement Row-Level Security (RLS) and automated data masking for PHI/PII in accordance with HIPAA, CMS MARS-E, and NIST standards
Data Quality: Develop automated data validation frameworks to ensure data parity between legacy SQL systems and the new Cloud Lakehouse
Qualification
Required
Maintaining SQL Server (SSIS/SSAS/SSRS) while concurrently deploying Azure cloud solutions
Expert-level proficiency in SSIS and T-SQL. Advanced proficiency in Azure Databricks (Unity Catalog, Delta Lake) and Azure Synapse
Deep experience with TFS (Team Foundation Server) and a strong desire to migrate workflows to Git/Azure DevOps
Mastery of SQL and Python (PySpark)
6-10 yrs. leading advanced technology projects or service projects
6-10 yrs. full system engineering lifecycle
Bachelor's degree
Accepts In-Person interview if requested
Accepts HYBRID work requirement
Preferred
Experience with Microsoft Purview for data cataloging
Extensive experience with Medicaid/Medicare data structures (e.g., MMIS, EDI 837/835, claims processing)
Microsoft Certified: Azure Data Engineer Associate or Databricks Certified Professional Data Engineer
Experience in a government or highly regulated environment
Company
ShiftCode Analytics, Inc.
ShiftCode Analytics Inc is a Tampa, FL based firm formed with one sole purpose of delivering best and quick services to its clients nationwide.
51-200 employees
Funding
Current Stage
Growth StageCompany data provided by crunchbase