Job Description
Job Overview:
- On-site in Washington, DC (locals preferred).
- Expected projected duration: 12+ Months
- 40 hours/week.
- Requires Bachelor's degree and 7+ years of experience.
- Medicaid/Medicare data structures (MMIS, EDI 837/835, claims processing; 3+ years) will be given priority.
Key Responsibilities:
- Maintain, troubleshoot, and modify complex SSIS packages for high-volume Medicaid claims, provider, and member data.
- Manage code deployments and branching strategies in Team Foundation Server (TFS) for continuous integration of legacy SQL assets.
- Support and optimize SSRS report queries and SSAS tabular/multidimensional models for federal and state compliance reporting.
- Implement Medallion Architecture (Bronze/Silver/Gold) using Azure Databricks (PySpark/SQL).
- Lead transition of legacy SSIS logic into Azure Data Factory (ADF) and Databricks notebooks.
- Facilitate migration of source control and CI/CD pipelines from TFS to Azure DevOps (Git).
- Build and tune Dedicated and Serverless SQL Pools in Azure Synapse for advanced analytics and AI-readiness.
- Implement Row-Level Security (RLS) and automated data masking for PHI/PII per HIPAA, CMS MARS-E, and NIST standards.
- Develop automated data validation frameworks to ensure data parity between legacy SQL systems and Cloud Lakehouse.
Required Technical Skills (7+ years each):
- SQL Server including SSIS, SSAS, SSRS while deploying Azure cloud solutions.
- Expert SSIS and T-SQL.
- Advanced Azure Databricks (Unity Catalog, Delta Lake) and Azure Synapse.
- TFS with migration to Git/Azure DevOps.
- SQL and Python (PySpark).
Required Functional/Behavioral Skills (7-10 years):
- Leading advanced technology or service projects.
- Full system engineering lifecycle.
- ITIL practices.
- End-to-end project delivery and consulting leadership.
- English (native or bilingual).
Preferred Skills:
- Microsoft Purview for data cataloging (3+ years).
- Medicaid/Medicare data structures (MMIS, EDI 837/835, claims processing; 3+ years).
- Microsoft Certified: Azure Data Engineer Associate or Databricks Certified Professional Data Engineer.
- Government or highly regulated environment experience (7+ years).
Numbers & Facts
| Location | Washington, DC |
| Salary | $157,000–$169,000 Per Year |
Skills
Artificial Intelligence (AI)unmatched
Cataloguingunmatched
Cisco Unityunmatched
Claims Processingunmatched
Cloud Computingunmatched
Consultingunmatched
Content Management Systems (CMS)unmatched
Continuous Deployment/Deliveryunmatched
Continuous Integrationunmatched
Data Qualityunmatched
Data Structuresunmatched
DevOpsunmatched
Electronic Data Interchange (EDI)unmatched
English Languageunmatched
Gitunmatched
Governmentunmatched
HIPAA (Health Insurance Portability and Accountability Act)unmatched
ITIL (IT Infrastructure Library)unmatched
Identify Issuesunmatched
Leadershipunmatched
Medicaidunmatched
Medicareunmatched
Microsoft Product Familyunmatched
Microsoft SQL Serverunmatched
Microsoft Transact-SQL (T-SQL)unmatched
Microsoft Windows Azureunmatched
Multilingualunmatched
Python Programming/Scripting Languageunmatched
Query Optimizationunmatched
SQL (Structured Query Language)unmatched
SQL Server Analysis Services (SSAS)unmatched
SQL Server Integration Services (SSIS)unmatched
SQL Server Reporting Services (SSRS)unmatched
Source Code/Configuration Management (SCM)unmatched
System Lifecycleunmatched
Systems Engineeringunmatched
Team Foundation Server (TFS)unmatched
U.S. National Institute of Standards and Technology (NIST)unmatched
Level up your application
Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.
Free resume templatesImprove your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.
Free resume builder