Senior Specialist - Data Engineering

Technical Team Lead: Azure Data ETL

Lead a team of developers responsible for designing developing and supporting the endtoend TPA Claims Processing platform

Drive the implementation of Azurebased data ingestion transformation reconciliation stewardship and reporting solutions while ensuring adherence to architecture standards quality processes and project timelines

The solution includes SFTPbased file ingestion PGP decryption Azure Data Factory pipelines Azure SQL processing claims conversion exception management and downstream integrations

Key Responsibilities

Technical Leadership

Lead a team of ETL SQL and Azure developers

Translate functional and technical requirements into detailed implementation designs

Review technical solutions code database objects and ETL workflows

Ensure adherence to architecture security and development standards

Provide guidance on complex technical issues and production support activities

Delivery Management

Own delivery of assigned workstreams and sprint commitments

Track project progress risks dependencies and blockers

Coordinate development testing deployment and production support activities

Ensure timely delivery of project milestones and releases

Support effort estimation planning and resource allocation activities

Azure ETL Solution Implementation

Oversee development of Azure Data Factory pipelines and SQLbased ETL frameworks

Ensure implementation of

File ingestion and validation

PGP decryption processes

Data transformation and conversion logic

Audit and reconciliation controls

Exception handling frameworks

Data archival and retention processes

Database Data Engineering Oversight

Review and approve

Stored Procedures

Functions

Views

ETL Control Tables

Audit Tables

Exception Management Tables

Ensure database performance optimization and data quality compliance

Stakeholder Coordination

Act as the primary technical contact for architects business analysts QA teams and business stakeholders

Participate in design reviews requirement clarification sessions and project governance meetings

Provide project status updates and technical risk assessments

Collaborate with offshore and onsite teams to ensure alignment

Quality Governance

Establish coding standards and review processes

Conduct code reviews and design walkthroughs

Ensure compliance with project documentation standards

Drive defect prevention and continuous improvement initiatives

Required Technical Skills

Must Have

Azure Data Factory ADF

Azure SQL Managed Instance SQL Server Snowflake

Advanced TSQL Programming

ETL Framework Development

Data Warehousing Concepts

Azure Data Lake Storage ADLS

Git Azure DevOps

Database Performance Tuning

Azure Functions

Azure Key Vault

Managed Identity

Logic Apps

REST API Integration

Insurance Claims Domain Knowledge

Leadership Expectations

Mentor and coach development team members

Conduct technical knowledgesharing sessions

Review deliverables and ensure quality standards are met

Drive problem resolution and decisionmaking

Foster collaboration across development QA and business teams

Experience

8 years of IT experience

3 years of technical team leadership experience

Strong experience delivering Azurebased data engineering or ETL projects

Experience managing distributed development teams

Experience with largescale data migration conversion or integration programs

Insurance Domain Knowledge Preferred

Key Deliverables

Technical Solution Designs

Detailed Technical Specifications

ETL Framework Components

Azure Data Pipelines

Database Objects Data Models

Reconciliation Audit Reports

Deployment Packages

Production Support Documentation

Team Delivery Metrics

Success Measures

Ontime sprint and release delivery

ETL processing accuracy and data quality

Reduction in production defects

Compliance with architecture and security standards

Successful mentoring and development of team members

Effective stakeholder communication and project governance