Senior Data Engineer

Job Title: Senior Associate, BIU, IO, Data Engineer

Location: Gurugram, Haryana, India

Experience: 5-8 years

About the Company

Alvarez & Marsal (A&M) is a global consulting firm built around entrepreneurial, action-oriented professionals who solve complex client problems and deliver measurable results. Its culture values Integrity, Quality, Objectivity, Fun, Personal Reward, and Inclusive Diversity. In 2023, A&M established its Global Capability Center in India to expand specialized talent, strengthen hybrid onshore-offshore delivery, accelerate execution, and apply digital and analytics capabilities across the firm. The GCC partners with case teams on end-to-end delivery and thought leadership rather than operating only as a back-office function. It supports major markets across the Americas, EMEA, and APAC, serving industries including Consumer & Retail, Healthcare, Software & Technology, Automotive & Industrials, Hospitality & Leisure, Energy & Natural Resources, and Financial Services. The rapidly growing center is now home to more than 1,000 professionals.

About the Role

As a Senior Associate, Data Engineer within the Business Intelligence Unit, you will own the data foundations that power analytics, reporting, applications, and emerging AI/ML use cases. This hands-on onsite role combines production engineering, data modelling, platform optimisation, and stakeholder partnership. You will strengthen existing SQL Server pipelines, support the transition to Snowflake and dbt, and embed disciplined engineering practices across the BIU. Working with Analysts, Power Platform Developers, and regional business users, you will turn requirements into reliable, maintainable data solutions. Your work will improve data quality, reporting performance, operational resilience, and the speed at which A&M converts information into objective business decisions.

Key Responsibilities

• Own and improve production ETL scripts, SQL Server processes, and data pipelines, increasing reliability, maintainability, and availability of data used by business-critical reports and applications.
• Design and maintain business-ready dimensional and relational data models that provide trusted foundations for analytics, reporting, application development, and future AI/ML solutions.
• Support the enterprise data warehouse transition to Snowflake by implementing scalable transformations, performance improvements, documentation, and deployment practices using dbt where appropriate.
• Embed application lifecycle management across BIU through Git-based version control, automated testing, controlled releases, and CI/CD processes for database and transformation assets.
• Diagnose and optimise report queries and data workloads, improving response times, scalability, and operational stability for key regional reporting and application use cases.
• Act as the regional technical subject matter expert for BIU data assets, resolving data questions, report issues, permissions, access requirements, and environment setup needs.
• Partner with Analysts, Power Platform Developers, and stakeholders to translate business requirements into robust technical solutions that deliver measurable insight and operational efficiency.

Essential Skills & Technologies

• Five to eight years of experience in data engineering, analytics engineering, platform engineering, or a comparable technical role, with ownership of production-grade pipelines and ETL processes.
• Strong SQL and SQL Server expertise, including query optimisation, relational design, troubleshooting, SQL Server Agent jobs, and production support for business-critical reporting or application data.
• Hands-on experience with Snowflake or another modern cloud data warehouse, including warehouse performance optimisation, data modelling, and engineering practices for scalable analytical workloads.
• Practical experience with dbt or a comparable transformation framework, covering model development, testing, documentation, lineage, and repeatable deployment of data assets.
• Experience using Git, CI/CD, version-controlled database objects, and controlled deployment processes within an application lifecycle management framework.
• Experience with Azure Data Factory and the broader Azure data ecosystem, including permissions, access management, and data setup supporting analytics and application development.
• Working knowledge of Python or a similar scripting language for data transformation, automation, operational support, and process improvement.

Additional Plus

• Familiarity with data governance, metadata management, documentation standards, lineage, and controls that improve trust, discoverability, and responsible use of enterprise data.
• Experience enabling data products or platforms for Power Platform applications, business intelligence solutions, and emerging artificial intelligence or machine learning use cases.
• Exposure to consulting, professional services, or multi-region stakeholder environments where technical teams must respond quickly to changing business priorities.

What You'll Bring

You bring a strong production mindset and the judgement to distinguish between a quick fix and an engineering solution that will remain reliable at scale. You have built, maintained, and improved data pipelines in live environments, and you are comfortable investigating failures, optimising SQL, and supporting business-critical data assets. You can work confidently across SQL Server and cloud data warehouse environments, with hands-on experience in Snowflake, data modelling, and preferably dbt. You understand why Git, testing, CI/CD, documentation, permissions, and repeatable deployments matter, and you apply those practices pragmatically rather than as process for its own sake. You communicate clearly with technical and non-technical stakeholders, explain trade-offs, and provide hands-on support when regional users need answers. You work independently while collaborating closely with analysts, application developers, and business partners. Most importantly, you are curious, detail-oriented, and willing to challenge the status quo when a better, more robust way of delivering data can improve decision-making and operational outcomes.

Why Join Us

• Shape the data architecture behind a rapidly growing global consulting capability center, with direct influence on analytics, applications, operational efficiency, and emerging AI/ML initiatives.
• Work alongside experienced consultants, analysts, developers, and business leaders across the Americas, EMEA, and APAC on high-impact, cross-functional problems.
• Grow through formal training, on-the-job learning, continuous performance development, and a meritocratic culture that rewards ownership, contribution, and measurable impact.

What We Offer

• A collaborative, entrepreneurial environment grounded in Integrity, Quality, Objectivity, Fun, Personal Reward, and Inclusive Diversity, with meaningful opportunities to improve how work is delivered.
• Structured performance development, technical training, and on-the-job learning that support continuous skill development and long-term career progression.
• Well-being benefits and personal resources designed to support your professional growth and personal journey while working with a growing global team.