Senior Data Engineer at Mastercard

pune, maharashtra, India -

Full Time

Start Date

Immediate

Expiry Date

14 Feb, 26

Salary

0.0

Posted On

16 Nov, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, Data Warehousing, ETL, Alteryx, Data Quality, MS-Excel, MS-PPT, Windows Server, Linux Server, SQL Server, Oracle DB, Essbase, Agile, Data Validation, Performance Tuning, Collaboration, Reporting

Industry

IT Services and IT Consulting

Description

Our Purpose Mastercard powers economies and empowers people in 200+ countries and territories worldwide. Together with our customers, we’re helping build a sustainable economy where everyone can prosper. We support a wide range of digital payments choices, making transactions secure, simple, smart and accessible. Our technology and innovation, partnerships and networks combine to deliver a unique set of products and services that help people, businesses and governments realize their greatest potential. Title and Summary Senior Data Engineer Position Overview: The Senior Data Engineer, MyMPA will be part of GBSC’s Automation & Engineering Team, responsible for implementing enhancements and periodic refreshes of an enterprise-wide data platform. This role will also work closely with the VP of Analytics & Metrics and Director of FP&A and gather requirements for changes and enhancements to the application and contribute to the technology platform's evolution as it grows to support the rapidly expanding Mastercard business. The ideal candidate will have hands-on development skills combined with an ability to analyze and understand end user requirements that are critical success factors within this role. This role requires the skills and desire to work as an individual contributor as well as, collaborate cross functionally with various business constituents. 1. Have you ever worked on an enterprise-wide reporting solution that relied heavily on your own knowledge and abilities to build and maintain the solution? 2. Are you constantly hungry to learn? Do you have the “growth mindset” as opposed to the “fixed mindset”? 3. Do you love working with people, helping them, and turning their requirements into something that can make a difference? Role: • Skilled at writing performant and reliable SQL queries to source data from Centralized data repositories such as a Data Warehouse. • Proficient at designing and developing Relational and Multi-dimensional Databases to host the sourced data and work with Tableau and Power BI developers within and outside the team to support reporting and dashboarding needs of the organization. • Develop ETL workflows and macros in Alteryx to source data for projects and build high-level and detailed data validations to ensure accuracy of the sourced data • Contribute to initiatives aimed at automating the data extraction, application of data quality checks to ensure datasets are released on time and with 100% accuracy. • Develop technical components to ensure department’s compliance with audit requirements such as SOX and other statutory/audit requirements as applicable from time to time. • Organize and lead discussions with customers to brainstorm on data quality issues and contribute to discussions to devise business rules to address data quality issues • Use MS-Excel and MS-PPT to capture findings and present to customers in an easy-to-understand and impactful manner • Liaison with the internal groups in MasterCard Operations and Technology to ensure our solutions remain in compliance with MasterCard technical standards. Navigate O&T requirements around change management and new development. All About You: • Strong understanding of Windows and Linux server. • Good understanding of SQL Server or Oracle DB. • Solid understanding of Essbase technology – understand how this technology works, for both BSO and ASO cubes. • Develop BSO and ASO cubes with a strong eye for performance. • Strong commitment to quality and error testing code you develop. Strong ability to step in and analyze the code of others on the team. • Be able to work within an Agile environment that is highly responsive to the business. Our team is part of the Finance organization – you must be comfortable with working as part of the business with a strong “roll up your sleeves” mentality. Corporate Security Responsibility All activities involving access to Mastercard assets, information, and networks comes with an inherent risk to the organization and, therefore, it is expected that every person working for, or on behalf of, Mastercard is responsible for information security and must: 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, and Complete all periodic mandatory security trainings in accordance with Mastercard’s guidelines. Everyone wants easier ways to pay; we invent them. Checkout lines are slow; we speed them along. Merchants want more sales; we give them data and insights. People need financial access; we connect them. Corporate purchasing is complicated; we make it simple. Commuters are busy; we speed them on their way. Governments need greater efficiencies; we help create them. Small businesses are virtual; we give them access to a world of buyers. Retailers want to fight fraud; we provide the tools.

Responsibilities

The Senior Data Engineer will implement enhancements and periodic refreshes of an enterprise-wide data platform while collaborating with various business constituents. This role involves developing ETL workflows, ensuring data quality, and maintaining compliance with audit requirements.