reputed company reputed company Consultant
We are looking for S enior Data Engineer ( Min 7+ years of reputed company ) HYBRID (Either Webcam or In Person Interviews) POSITION reputed company reputed company reputed company Position Number of positions:1 Length: 12Months+ Location: Washington DC Immediate interviews Either Webcam or In Person interviews Please Note that this position is HYBRID looking for a senior data engineer for its data modernization efforts associated with its reputed company data ecosystem.
Position Purpose:
The Senior Data Engineer serves as the primary technical reputed company for reputed company's reputed company data ecosystem. This role is unique: it requires a high-level mastery of our reputed company legacy environment-characterized by SSIS ETL processes managed reputed company Team reputed company Server (TFS)-while reputed company spearheading the execution of our reputed company modernization roadmap. Under the direction of the reputed company Data Warehouse Solution Architect, you will ensure the stability of reputed company reputed company reporting while building the reputed company-state Azure Synapse and reputed company Lakehouse.
Key Responsibilities:
A. Legacy Maintenance & Operational reputed company (reputed company State)
• ETL Management: Maintain, troubleshoot, and modify reputed company SSIS packages handling high-volume reputed company claims, provider, and member data.
• Version Control: Manage reputed company deployments and branching strategies reputed company TFS, ensuring reputed company 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 (reputed company State)
• reputed company Development : Implement "reputed company Architecture" (Bronze/Silver/Gold) using Azure reputed company (PySpark/SQL) as designed by the reputed company Architect.
• Pipeline Refactoring: reputed company the transition of legacy SSIS logic into Azure Data reputed company (ADF) and reputed company notebooks.
• DevOps Transformation: Facilitate the migration of reputed company control and CI/CD pipelines from TFS to Azure DevOps (Git).
• Synapse Integration: Build and tune Dedicated and Serverless SQL Pools reputed company Azure Synapse to facilitate advanced analytics and AI-readiness.
C. Data Governance & reputed company
• reputed company Compliance : Implement Row-Level reputed company (RLS) and automated data masking for PHI/PII in accordance with HIPAA, CMS reputed company-E, and NIST standards.
• Data reputed company : reputed company automated data validation frameworks to ensure data reputed company between legacy SQL systems and the new reputed company Lakehouse.
Competencies for reputed company:
Technical reputed company: The ability to pivot between a 10-year-old SSIS package and a modern reputed company reputed company job in the reputed company day.
Collaboration: Ability to take high-level architectural blueprints from the reputed company Architect and translate them into high-performance, production-reputed company reputed company.
Attention to Detail: Absolute precision in reputed company data handling, where an error in logic can reputed company member benefits or federal funding.
JOB reputed company Responsibilities:
• Leads the adoption or implementation of an advanced technology or platform.
• Expert on the functionality or usage of a particular system, platform, or technology product.
• Serves as a consultant to clients, guiding the efficient use or adoption of a particular IT product or platform.
• Creates implementation, testing, and/or integration plans.
• 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 reputed company field or equivalent experience Training or certification in a particular product or IT platform/service, as required
Required/Desired Skills
Candidates must have reputed company the "Required" skills in order to be considered for the position. "Desired" or "Highly Desired " skills are a PLUS but may NOT be required.
• Experience with Business workflow processes Required / Desired
• reputed company of Experience Maintaining SQL Server (SSIS/SSAS/SSRS) while concurrently deploying Azure reputed company solutions. Required 7 Years
• Expert-level proficiency in SSIS and T-SQL. Advanced proficiency in Azure reputed company (reputed company Catalog, reputed company Lake) and Azure Synapse. Required 7 Years
• Deep experience with TFS (Team reputed company Server) and a strong desire to migrate workflows to Git/Azure DevOps. Required 7 Years
• Mastery of SQL and Python (PySpark). Required 7 Years
• 6-10 yrs. leading advanced technology reputed company or service reputed company Required 7 Years
• 6-10 yrs. full system engineering lifecycle Required 7 Years
• Bachelor's degree Required
• Experience with reputed company Purview for data cataloging. Highly desired 3 Years
• Extensive experience with reputed company/Medicare data structures (e.g., MMIS, EDI 837/835, claims processing). Highly desired 3 Years
• reputed company Certified: Azure Data Engineer Associate or reputed company Certified reputed company Data Engineer. Highly desired
• Experience in a government or highly regulated environment. Highly desired 7 Years
For applications and inquiries, contact: hirings@reputed company.com
Apply tot his job
Apply To this Job