Senior Analyst, Advanced Analytics, AICP

Title and Summary

Senior Analyst, Advanced Analytics, AICP

Position Overview:

The Senior Analyst, MyMPA will be part of GBSC's Analytics & Automation Team, responsible for implementing enhancements and periodic refreshes of a global Essbase application.

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 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:

• Skilled at developing workflows and macros in Alteryx to handle data transformations and application of 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 lead discussions with customers to brainstorm on data quality issues and contribute to discussions to devise business rules to address data quality issues
• Proficiency in writing and debugging SQL queries that can be used to extract datasets from Data Warehouse and other Relational databases.
• Develop and deploy Essbase solutions with best-in-class coding practices.
• Develop the technical components to ensure department's compliance with audit requirements.
• Educate yourself constantly on the latest in Essbase technology and related technologies. Bring new, robust technical solution possibilities to the team.
• 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.
• Be a Level 2 resource that is comfortable diving deep into solutions and process flows/breaks.

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.