Software engineer II (Data Warehouse, MSBI, Power BI, Tableau, SQL, data models, Visualization tools, SSIS)

Our Purpose

We work 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. We cultivate a culture of inclusion for all employees that respects their individual strengths, views, and experiences. We believe that our differences enable us to be a better team – one that makes better decisions, drives innovation and delivers better business results.

Title and Summary

Software engineer II (Data Warehouse, MSBI, Power BI, Tableau, SQL, data models, Visualization tools, SSIS)

Overview
Mastercard is a technology company in the Global Payments Industry. We operate the world’s fastest payments processing network, connecting consumers, financial institutions, merchants, governments and businesses in more than 210 countries and territories. Mastercard products and solutions make everyday commerce activities – such as shopping, travelling, running a business and managing finances – easier, more secure and more efficient for everyone.

Mastercard’s Data & Services team is a key differentiator for MasterCard, providing cutting-edge services that help our customers grow. Focused on thinking big and scaling fast around the globe, this dynamic team is responsible for end-to-end solutions for a diverse global customer base. Centred on data-driven technologies and innovation, these services include payments-focused consulting, loyalty and marketing programs, business experimentation, and data-driven information and risk management services.
We are currently looking for a software engineer for our Operational Insights program within the Data & Services group. The ideal candidate is passionate about data engineering and visualization, highly motivated, intellectually curious, analytical, and possesses an ability to independently work and deliver results.

Role:
• Design, develop, and maintain new data capabilities and infrastructure.
• Collaborate with technical team and business stakeholders to understand data requirements and translate them into technical solutions.
• Work with large datasets, ensuring data quality, accuracy, and performance.
• Implement data transformation, integration, and validation processes to support analytics/BI and reporting needs.
• Optimize and fine-tune data pipelines for improved speed, reliability, and efficiency.
• Implement best practices for data storage, retrieval, and archival to ensure data accessibility and security.
• Troubleshoot and resolve data-related issues, collaborating with the team to identify root causes.
• Document data processes, data lineage, and technical specifications for future reference.
• Participate in code reviews, ensuring adherence to coding standards and best practices.

All About You:
• Bachelors/Masters in Engineering/Information Science with strong hands-on experience in analytical programming in the context of data manipulation, transformation, and data analysis
• Strong data analysis skills across multiple source systems of various formats
• Expertise in data engineering, ETL/ELT processes, data warehousing, and data modelling
• 3-4 years of experience in Data Warehouse related projects
• Expertise in Data Engineering and Data Analysis
• Experience of working with Databases like MS SQL Server, Oracle and have strong SQL knowledge
• Experience in BI tools like Tableau, PowerBI, SSIS
• Familiarity with cloud platforms and services, such as AWS, Azure.
• 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
• Ability to quickly learn and implement new technologies and perform POC to explore best solution for the problem statement.

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.