Sign upLog in

Senior Data Engineer

Macpower Digital Assets Edge Private Limited

Washington, DC

Apply
JOB DETAILS
SALARY
$157,000–$169,000 Per Year
SKILLS
Artificial Intelligence (AI), Cataloguing, Cisco Unity, Claims Processing, Cloud Computing, Consulting, Content Management Systems (CMS), Continuous Deployment/Delivery, Continuous Integration, Data Quality, Data Structures, DevOps, Electronic Data Interchange (EDI), English Language, Git, Government, HIPAA (Health Insurance Portability and Accountability Act), ITIL (IT Infrastructure Library), Identify Issues, Leadership, Medicaid, Medicare, Microsoft Product Family, Microsoft SQL Server, Microsoft Transact-SQL (T-SQL), Microsoft Windows Azure, Multilingual, Python Programming/Scripting Language, Query Optimization, SQL (Structured Query Language), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Source Code/Configuration Management (SCM), System Lifecycle, Systems Engineering, Team Foundation Server (TFS), U.S. National Institute of Standards and Technology (NIST)
LOCATION
Washington, DC
POSTED
2 days ago
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).

About the Company

M

Macpower Digital Assets Edge Private Limited

Resume Resources

Free Resume TemplatesFree Resume Builder