Data Engineer II-R-248120

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

Data Engineer II

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. We are looking for data engineer who can build efficient data pipelines to feed downstream reporting and analytics platform

Ideal candidates will answer yes to all of the following questions:

• Have you worked in an agile development team?
• Are you proficient in Big Data, ETL/ELT tool (example NiFi)
• Are you passionate about building technology to deliver quality solutions providing superior customer experience?
• Do you thrive in a fast-paced environment and have the ability to learn new skills and applications quickly?
  
  
  

Role Description

The Data Engineer II will participate on data management aspects of client engagements to deliver data products, as well as contribute to and foster a high-performance collaborative workplace. A Data Engineer II will:

• Independently execute projects through design, implementation, automation, and maintenance of large-scale enterprise ETL processes for a global client base
• Develop repeatable and scalable code that processes client data in an automated and efficient manner to ensure data availability in the platform is as real-time as possible.
• Act as an expert data resource within the team
• Manage the process of data delivery on teams by overseeing other Data Engineers and Analysts to deliver on-time, accurate, high-value, robust data solutions across multiple clients, solutions, and industry sectors
• Build trust-based working relationships with peers and clients across local and global teams
• Leverage industry best practices including proper use of source control, code reviews, data validation and testing
• Enhance big data pipelines using Python, R, SSIS and Powershell to address complex technical challenges and seamless communication with several cloud storage technologies
• Leverage new SQL Server features such as Columnstore Indexes, In-Memory OLTP, Incremental statistics, Trace Flags, SQL CLR functions, window aggregate functions, and parallel computing algorithms to reduce the processing time of multi-billion row data sets
• Contribute to the automation capabilities of the team. Implement techniques to optimize and routinize repeatable tasks
• Comply with and uphold all Mastercard internal policies and external regulations
  
  
  

All About You

• Bachelor's degree in Computer Science, Software Engineering, or a related field
• Extensive hands-on experience in Data Engineering, including implementing multiple end-to-end data warehouse projects in Big Data environments.
• Proficiency in application development frameworks (Python, Java/Scala) and data processing/storage frameworks (Hadoop, Spark, Kafka).
• Experience in developing data orchestration workflows using tools such as Apache NiFi, Apache Airflow, or similar platforms to automate and streamline data pipelines.
• Experience with performance tuning of database schemas, databases, SQL, ETL jobs, and related scripts.
• Experience of working in Agile teams
• Experience in development of data-driven applications and data processing workflows/pipelines and/or implementing machine learning systems at scale using Java, Scala, or Python. This includes all phases such as data ingestion, feature engineering, modeling, tuning, evaluating, monitoring, and presenting analytics.
• Experience in developing integrated cloud applications with services like Azure, Databricks, AWS or GCP.
• Excellent analytical and problem-solving skills, with the ability to analyze complex data issues and develop practical solutions.
• Strong communication and interpersonal skills, with the ability to collaborate effectively with and facilitate activities across cross-functional teams, geographically distributed, and stakeholders.
  
  
  

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.
  
  
  

R-248120