Role:
• Skilled at writing performant and reliable SQL queries to source data from Centralized data repositories such as a Data Warehouse.
• Proficient at designing and developing Relational and Multi-dimensional Databases to host the sourced data and work with Tableau and Power BI developers within and outside the team to support reporting and dashboarding needs of the organization.
• Develop ETL workflows and macros in Alteryx to source data for projects and build high-level and detailed data validations to ensure accuracy of the sourced data
• Contribute to initiatives aimed at automating the data extraction, application of data quality checks to ensure datasets are released on time and with 100% accuracy.
• Develop technical components to ensure department’s compliance with audit requirements such as SOX and other statutory/audit requirements as applicable from time to time.
• 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
• Use MS-Excel and MS-PPT to capture findings and present to customers in an easy-to-understand and impactful manner
• 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.
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.