Role:
• 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
• Proficiency in writing and debugging SQL queries that can be used to extract datasets from Data Warehouse and other Relational databases.
• 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.
• Individuals with 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
All About You:
• Strong understanding of Alteryx workflows and Macros.
• Good understanding of SQL Server or Oracle DB.
• Advanced MS-Excel and PPT.
• Ability to work on Windows and Linux servers.
• 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.