Senior Data Engineer (MSBI stack - SSIS, SSAS and SSRS)

Our Purpose

Mastercard powers economies and empowers people in 200+ countries and territories worldwide. Together with our customers, we’re helping build a sustainable economy where everyone can prosper. We support a wide range of digital payments choices, making transactions secure, simple, smart and accessible. Our technology and innovation, partnerships and networks combine to deliver a unique set of products and services that help people, businesses and governments realize their greatest potential.

Title and Summary

Senior Data Engineer (MSBI stack - SSIS, SSAS and SSRS)

Job Description Summary
Who is Mastercard?
Mastercard is a global technology company in the payments industry. Our mission is to connect and power an inclusive, digital economy that benefits everyone, everywhere by making transactions safe, simple, smart, and accessible. Using secure data and networks, partnerships and passion, our innovations and solutions help individuals, financial institutions, governments, and businesses realize their greatest potential.
Our decency quotient, or DQ, drives our culture and everything we do inside and outside of our company. With connections across more than 210 countries and territories, we are building a sustainable world that unlocks priceless possibilities for all.
Overview
Mastercard Data Warehouse builds and supports various analytics and reporting platform that includes Domo, Power BI, Tableau, SSRS and WebFOCUS. The ecosystem also includes Microsoft BI stack involving SSAS & SSIS and Alteryx ETL tool.
Role
• Work with cross-functional agile teams that include Front-end Developers, Report/BI Developers and Product Owners to implement the next generation of enterprise application
• Identify and resolve performance bottlenecks proactively
• Work with the customer support group as needed to resolve performance issues in the field
• Explore automation opportunity and develop tools to automate some of the day to day operations tasks
• Provide performance metrics and maintain dashboards to reflect production systems health
• Conceptualize and implement proactive monitoring where possible to catch issues early
• Experiment with new tools to streamline the development, testing and prod deployment
• Help the team improve with the usage of BI Applications best practices.
• Collaborate with other BI teams to improve the BI ecosystem and talent within Mastercard.
• Creatively solve problems when facing constraints, whether it is the number of developers, quality or quantity of data, compute power, storage capacity or just time.
• Maintain awareness of relevant technical and product trends through self-learning/study, training classes and job shadowing
All About You
• 7-10 years of experience in Data Warehouse related projects in product or service-based organization
• Experience in MSBI stack - SSIS, SSAS and SSRS
• Experience of working with Databases like Oracle, Netezza and have strong SQL knowledge
• Experience of working on data pipeline tools like Alteryx, NiFi and real time data flow system like Kafka
• Experience of working on automation in data flow process in a Big Data environment, leveraging tools like Airflow.
• Experience of working in data analytics platforms like Cloud, Snowflake, visualization tools will be added advantage.
• Experience of working in Agile teams
• Strong analytical skills required for debugging production issues, providing root cause and implementing mitigation plan
• Strong communication skills - both verbal and written – and strong relationship, collaboration skills and organizational skills
• Ability to multi-task across multiple projects, interface with external / internal resources and provide technical leadership to junior team members
• Ability to be high-energy, detail-oriented, proactive and able to function under pressure in an independent environment along with a high degree of initiative and self-motivation to drive results
• Ability to quickly learn and implement new technologies, and perform POC to explore best solution for the problem statement
• Flexibility to work as a member of a matrix based diverse and geographically distributed project teams

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.