Senior Data Engineer Azure

USEReady Inc.; Bengaluru; On-site; INR 3,000,000 - 5,000,000; Full time

Job summary

USEReady Inc. is hiring a Senior Data Engineer to own an Azure data platform end to end for a client engagement. You will design new sources, lead governance in Microsoft Purview, and ensure secure, fast, and cost-efficient pipelines.

You will architect ADF, Synapse, ADLS Gen2, and Power BI models; onboard sources; drive data quality and FinOps; and mentor junior engineers while collaborating with US stakeholders.

Qualifications

• 5–7 years in data engineering with 3+ years on the Azure data stack.
• Expert Azure Data Factory orchestration with REST sources and paging.
• Deep Azure Synapse Dedicated SQL Pool experience and cost control.
• Advanced T-SQL with SCD Type 1/2 and MERGE patterns.
• Data modeling using Medallion architecture and Kimball.
• Power BI semantic modeling, DAX, and refresh management.
• Hands-on Purview: Data Map, scans, lineage, glossary and classifications.
• CI/CD with GitHub or Azure DevOps for ADF/Synapse deployments.
• Experience leading client-facing delivery with stakeholder alignment.

Responsibilities

• Own end-to-end design: ADF orchestration, ADLS Gen2 layout, Synapse layers, and Power BI models.
• Onboard new sources: API review, Key Vault secrets, linked services, Bronze to Gold data flows.
• Design metadata-driven ADF frameworks: pipelines, watermarking and CDC-like loads.
• Model Gold data products for HR, payroll and finance analytics.
• Tune Synapse pool: distribution keys, indexing, statistics, DWU and pause schedules.
• Lead the data quality framework and live DQ reporting.
• Lead Purview rollout: data map scans, governance domains, and data products.
• Set up catalog operating practices: owners, glossary approvals, and access policies.
• Own security: Key Vault, Managed Identity, RBAC and PII access controls.
• Drive FinOps: monitor Azure spend and recommend savings.
• Prepare curated Gold data for AI/LLM use cases with governance.
• Run workshops/UAT with client stakeholders and document outcomes.

Skills

Data engineering

Azure data stack

SQL & T-SQL

Data modeling

Power BI

Tools

Azure Data Factory

Azure Synapse

Microsoft Purview

Power BI

GitHub / Azure DevOps

Job description

Job Description:

USEReady is a data and analytics firm that provides the strategies, tools, capability, and capacity that businesses need to turn their data into a competitive advantage.

USEReady partners with cloud and data ecosystem leaders like Tableau, Salesforce, Snowflake and Amazon Web Services, and has been named Tableau partner of the year multiple times.

Description

Role: Senior Data Engineer ·

Experience: 5–7 years

You will own an Azure data platform end to end as the technical lead for a client engagement. You will design new sources and data products, lead data governance and cataloguing on Microsoft Purview, and keep the platform secure, fast and cost-efficient.

What you will do

• Own the end-to-end design: ADF orchestration, ADLS Gen2 layout, Synapse Medallion layers and Power BI semantic models.
• Onboard new source systems: API review, Key Vault secret, linked service, Bronze tables, parameterised incremental logic, Silver procedures and Gold views.
• Design metadata-driven, reusable ADF frameworks: parent-child pipelines, watermark and CDC-style loads, alerting.
• Model Gold data products for HR, payroll and finance analytics: attrition, profitability, headcount, budget versus actual, FinOps.
• Tune Synapse Dedicated SQL Pool: distribution keys, CCI, statistics, workload management, DWU scaling and pause schedules.
• Lead the data quality framework: agree DQ rules with business owners and take DQ reporting live.
• Lead the Microsoft Purview rollout: Data Map scans of ADLS, Synapse and Power BI; ADF lineage; governance domains and data products in Unified Catalog; business glossary; classifications and sensitivity labels for PII; data quality and health in Purview.
• Set up catalog operating practices: data owners and stewards, glossary approval workflows, access policies and onboarding standards for new assets.
• Own security and access: Key Vault secret rotation, Managed Identity, Azure RBAC, least-privilege access to PII and payroll data, Power BI RLS where needed.
• Drive FinOps: track Azure spend through Cost Management exports and recommend savings.
• Prepare curated Gold data for AI and LLM analytics use cases with the right governance.
• Run requirements workshops and UAT with client business and IT stakeholders; turn manual reporting into dashboards.
• Set standards for CI/CD (GitHub, ADF / Synapse deployment across environments), code review, runbooks and documentation.
• Review code and mentor junior team members.

Must have

• 5–7 years in data engineering, with 3+ years delivering on the Azure data stack.
• Expert Azure Data Factory: complex orchestration, REST sources with token or session auth, pagination, error handling, metadata-driven design.
• Deep Azure Synapse Dedicated SQL Pool: MPP design, distribution and indexing strategy, performance tuning, cost control.
• Advanced T-SQL: stored-procedure frameworks, SCD Type 1/2, incremental and MERGE patterns, query-plan analysis.
• Data modelling: Medallion architecture and Kimball dimensional modelling.
• Power BI: semantic model design, advanced DAX, performance tuning, workspace and refresh management, RLS.
• Hands‑on Microsoft Purview: Data Map, scanning, Unified Catalog, glossary, classifications and lineage.
• Data governance fundamentals: ownership and stewardship, metadata management, PII classification.
• Azure security: Key Vault, Managed Identity, RBAC, network basics.
• CI/CD with Git (GitHub or Azure DevOps) for ADF and Synapse.
• Has led client‑facing delivery: requirements, estimates, UAT and status reporting with US stakeholders.

Good to have

• Microsoft Fabric (Lakehouse, Warehouse, Data Factory) for future migration paths.
• Python / PySpark and Spark on Synapse or Databricks.
• Azure Cost Management and FinOps practice.
• HR, payroll or finance data; CRM and ERP API integrations.
• GenAI / LLM integration on curated data.
• Certification: DP-203 / DP-700, DP-600, PL-300, AZ-305, or SC-400 / Purview-related.

What we look for

• Owns outcomes for the engagement, not just tickets.
• Explains technical trade-offs to business and IT leaders in plain terms.
• Pushes for early stakeholder alignment and firm UAT timelines.

Requirements: