Business Analyst II

Title and Summary

Business Analyst II (Hyperion/Essbase)The Business Analyst, MyMPA will be part of GBSCs 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 dataapplication 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.