Senior Data Engineer

Baker Tilly US; Bengaluru; On-site; INR 700,000 - 1,000,000; Full time

Job summary

Baker Tilly US is seeking a candidate in Bengaluru, India to design and optimize data solutions for mid-market and enterprise clients. You will work primarily with the Microsoft stack, including Azure, and your responsibilities will include transforming data into analytics-ready assets and developing scalable ETL/ELT pipelines.

Ideal candidates will have a Bachelor's degree and at least 3 years of experience in a consulting role, strong SQL, Python skills, and familiarity with Azure services. Key benefits of this position include the opportunity to work in a supportive environment focused on innovation and best practices.

Qualifications

• Minimum of 3 years delivering production data solutions.
• Experience in a consulting or client-facing role.
• Solid grasp of Azure fundamentals—storage, networking, security.

Responsibilities

• Design, build, and optimize modern data solutions.
• Transform raw data into analytics-ready assets.
• Develop scalable ETL/ELT pipelines using T-SQL and Python.

Skills

SQL for data transformation

Python for data wrangling

ETL/ELT with Microsoft services

Azure fundamentals

DevOps exposure

Education

Bachelor’s degree

Tools

Azure Data Factory

Databricks

Microsoft Fabric

Job description

Overview

BTVK Advisory is a leading advisory firm whose specialized professionals guide clients through an ever-changing business world, helping them win now and anticipate tomorrow. BTVK Advisory, and its affiliated entities, have operations in North America, South America, Europe, Asia, and Australia. BTVK Advisory’s ultimate parent entity, Baker Tilly US, LLP, is an independent member of Baker Tilly International, a worldwide network of independent accounting and business advisory firms in 141 territories, with 43,000 professionals and a combined worldwide revenue of $5.2 billion.

Baker Tilly is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability or protected veteran status, gender identity, sexual orientation, or any other legally protected basis, in accordance with applicable federal, state or local law.

Responsibilities

• Design, build, and optimize modern data solutions for our mid‑market and enterprise clients
• Transform raw data into trusted, analytics‑ready assets that power dashboards, advanced analytics, and AI use cases – working primarily inside the Microsoft stack (Azure, Synapse, and Microsoft Fabric)
• Develop scalable, well‑documented ETL/ELT pipelines using T‑SQL, Python, Azure Data Factory/Fabric Data Pipelines, and Databricks; implement best‑practice patterns for performance, security, and cost control.
• Design relational and lakehouse models; create Fabric OneLake shortcuts, medallion‑style layers, and dimensional/semantic models for Power BI.
• Build automated data‑quality checks, lineage, and observability metrics; contribute to CI/CD workflows in Azure DevOps or GitHub
• Gather requirements, demo iterative deliverables, document technical designs, and translate complex concepts to non‑technical audiences.
• Research new Fabric capabilities, share findings in internal communities of practice, and contribute to reusable accelerators.

Qualifications

• Bachelor’s degree required.
• Minimum of 3 years delivering production data solutions, preferably in a consulting or client‑facing role.
• Strong SQL for data transformation and performance tuning.
• Python for data wrangling, orchestration, or notebook-based development (PySpark), and hands on ETL/ELT with at least one Microsoft service (ADF, Synapse Pipelines, Fabric Data Pipelines).
• Solid grasp of Azure fundamentals—storage, networking, security, and cost management.
• Project experience with Microsoft Fabric (OneLake, Lakehouses, Data Pipelines, Notebooks, Warehouse, Power BI DirectLake).
• Familiarity with Databricks, Delta Lake, or comparable lakehouse technologies, and exposure to DevOps (YAML pipelines, Terraform/Bicep) and test automation frameworks.
• Experience writing unit tests for data pipelines and transformation logic, understanding or working with metadata frameworks for data governance and lineage, and integrating SaaS/ERP sources (e.g., Dynamics 365, Workday, Costpoint, SAP, Netsuite, Sage Intacct, IFS, etc.).