Sr. Data Engineer
Hybrid in Washington, DC, US • Posted 16 hours ago • Updated 16 hours ago

Source Code Technologies LLC
Dice Job Match Score™
🤯 Applying directly to the forehead...
Job Details
Skills
- Data Engineer
- SSIS
- Team Foundation Server
- TFS
- ETL
Summary
Title: Sr. Data Engineer
Location: Washington, DC 20024
(Candidates local to DC, MD, and VA Only)
Duration: 12 Months
Brief Description:
We are looking for a senior data engineer for its data modernization efforts associated with its Medicaid data ecosystem.
JOB DESCRIPTION:
Position Purpose:
The Senior Data Engineer serves as the primary technical engine for the agency's Medicaid data ecosystem. This role is unique: it requires a high-level mastery of our current legacy environment—characterized by SSIS ETL processes managed via Team Foundation Server (TFS)—while actively spearheading the execution of our cloud modernization roadmap. Under the direction of the Lead Data Warehouse Solution Architect, you will ensure the stability of current Medicaid reporting while building the future-state Azure Synapse and Databricks Lakehouse.
Key Responsibilities:
A. Legacy Maintenance & Operational Excellence (Current State)
• 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.
B. Modernization & Migration Execution (Future State)
• 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.
C. Data Governance & Security
• 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.
3. Competencies for Success:
• Technical Agility: The ability to pivot between a 10-year-old SSIS package and a modern Databricks Spark job in the same day.
• Collaboration: Ability to take high-level architectural blueprints from the Lead Architect and translate them into high-performance, production-ready code.
• Attention to Detail: Absolute precision in Medicaid data handling, where an error in logic can impact member benefits or federal funding.
Responsibilities:
1. Leads the adoption or implementation of an advanced technology or platform.
2. Expert on the functionality or usage of a particular system, platform, or technology product.
3. Serves as a consultant to clients, guiding the efficient use or adoption of a particular IT product or platform.
4. Creates implementation, testing, and/or integration plans.
5. Demonstrates expertise in a particular IT platform or service, allowing for maximum IT investment.
Minimum Education/ Certification Requirements:
Bachelor’s degree in Information Technology or related field or equivalent experience
Training or certification in a particular product or IT platform/service, as required
- Dice Id: 91139032
- Position Id: 8874642
- Posted 16 hours ago
Company Info
As your business grows, evolves, and improves every day, an intentional and well-executed IT strategy is an essential component in maintaining a sustained competitive advantage. It’s difficult to keep up with the latest technology trends, but with insightful advice and focused professional guidance from Source Code Technologies LLC, you can seamlessly navigate every stage of growth, from start-up to IPO. Get in touch with us today to learn more about how we can help your organization maximize your IT strategy.
Your success is our top priority, and our team works with honesty, integrity, and sincerity to ensure our solutions are a perfect match for your organizational IT needs. We’ll help you move past legacy technology that may be a barrier to productivity, replacing it with advanced solutions that are tailored to provide exactly what your organization needs to excel.
With innovative strategies that encourage rapid decision-making, teamwork, and proactive problem resolution, Source Code Technologies LLC will help position your organization to achieve greater success than you’ve ever imagined.
As a premier IT services company, we believe in maintaining a positive mindset and creating partnerships with purpose. We strive to deliver significant outcomes with measurable results that consistently drive the success and growth of our clients.


Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs