Data Engineer II

About the Role

The Insights & Enablement Data Engineering team within Services is looking for a Data Engineer II to help build, enhance, and operate scalable, reliable, and governed data solutions that support analytics and data-driven decision making. This role is based in Pune, India.

Our Data Engineering environment spans established on-premises capabilities and an evolving cloud data platform. The team maintains and enhances the Analytics Data Mart (ADM), powered by Microsoft SQL Server and data integration workflows using Alteryx, while expanding cloud-native capabilities through the Strategy & Operations Data Platform (SODP) on Microsoft Fabric. The broader platform direction emphasizes governed production data, reusable data products, analytics, automation, and AI consumption.

You will join a collaborative Data Engineering team focused on building reusable engineering patterns, improving data quality and resiliency, automating repeatable processes, and making trusted enterprise data easier for downstream teams to consume.

Key Responsibilities

• Develop, test, enhance, and maintain data pipelines and data solutions that ingest, transform, and deliver enterprise data for analytics and downstream consumption using Alteryx and Fabric pipelines.
• Work independently on defined elements of Data Engineering projects, applying established engineering standards and patterns while collaborating with experienced engineers on more complex designs.
• Develop and support solutions across our data ecosystem, including Microsoft SQL Server, Alteryx, and the growing Microsoft Fabric platform, while contributing to the team's transition toward scalable cloud-native data engineering patterns.
• Monitor and troubleshoot identifiable data pipeline and processing issues by analyzing logs, identifying root causes, and applying appropriate solutions to maintain data availability and reliability.
• Apply Data Engineering practices for data quality, security, validation, documentation, and operational resiliency, helping ensure solutions are trustworthy and supportable in production.
• Collaborate with Data Engineering colleagues, business stakeholders, and partner teams to understand requirements, review deliverables, assess technical feasibility, and translate data needs into maintainable technical solutions.
• Document technical designs, data processes, reusable patterns, and operational procedures while contributing to continuous improvement and knowledge sharing across the team.

Requirements & Tech Stack

• Intermediate/practical Data Engineering expertise, with the ability to independently develop, test, troubleshoot, and maintain data pipelines and related components using established engineering practices.
• Proficient with SQL and relational data concepts, including data transformation, data modeling, database design, and building reliable solutions for analytical use cases.
• Practical experience with modern data integration and workflow orchestration concepts, including moving and transforming data across multiple enterprise data sources and platforms.
• Understand core practices related to data quality, data security, testing, monitoring, troubleshooting, and operational reliability, and apply them throughout the Data Engineering lifecycle.
• Comfortable working with technologies such as Microsoft SQL Server, Python, and cloud-based data platforms.
• Experience with Microsoft Fabric, Lakehouse architectures, Data Factory/Data Pipelines, OneLake, or Alteryx would be valuable.
• Effective collaborator and communicator who can document technical solutions clearly, contribute to solution reviews and planning discussions, learn new technologies, and work effectively with both technical and business stakeholders.

Corporate Security Responsibility

Every person working for, or on behalf of, Mastercard is responsible for information security.

• Abide by Mastercard's security policies and practices.
• Ensure the confidentiality and integrity of the information being accessed.
• Report any suspected information security violation or breach.
• Complete all periodic mandatory security trainings in accordance with Mastercard's guidelines.