Business Analyst II (Hyperion/Essbase)

5 - 10 years

5 - 10 Lacs

Posted:5 days ago| Platform: Foundit logo

Apply

Skills Required

Work Mode

On-site

Job Type

Full Time

Job Description

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.

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.

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Mastercard logo
Mastercard

IT Services and IT Consulting

Purchase NY

RecommendedJobs for You