Data Engineer II

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
Data Engineer II
The Business Analyst, MyMPA will be part of GBSC's Automation & Engineering Team, responsible for developing and implementing end-to-end workflows that will generate datasets crucial to the delivery and support of ongoing/future reporting and analytics projects.
This role will also work closely with the VP of Analytics & Metrics and Director of FP&A and gather requirements for new datasets to support and strengthen the continuous evolution of reporting requirements and contribute to our reporting platform's success 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 resources 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:
• Hyperion/Essbase (ASO/BSO) knowledge and experience is necessary.• Proficiency in writing and debugging SQL queries that can be used to extract datasets from Data Warehouse and other Relational databases.• Nice to have, if skilled at developing workflows and macros in Alteryx to handle data transformations and for applying business rules.• Use Alteryx to build high-level and detailed validations to ensure data quality and uphold a high degree of user confidence in our datasets.• Use MS-Excel and MS-PPT to capture findings and present to customers in an easy-to-understand and impactful manner• Organize and participate in discussions with customers to brainstorm on data quality issues and contribute to discussions to devise business rules to address data quality issues• Work closely with Essbase developers to align the structure of the data feeds to the dimensionality of the application.• Assist Essbase development team in testing the data loaded in the application and flag issues while performing sanity checks on the data.• Partner with customers during the UAT phase and work with the Development team to fix data /application issues identified during UAT• Be a Level 2 resource that is comfortable diving deep into data and process flows/breaks.• 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.• The candidate should have strong metadata management, data transformation/manipulation and reporting skills, preferably in an FP&A environment. A prior FP&A experience is desirable since the individual will be closely working with stakeholders from the FP&A organization and an understanding of the data in an FP&A context will make engagement with stakeholders more productive and easier.
In terms of hard skills, we are looking for individuals who are proficient in Alteryx, SQL, Power BI and Advanced MS-Excel along with Project Management experience.
All About You:
• Strong understanding of Windows and Linux server.• Good understanding of SQL Server or Oracle DB.• Strong commitment to development, testing and ensuring quality of data workflows you will be developing.• Strong ability to step in and debug/analyze the workflow 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.