Data Engineer II

Mastercard, Inc.; London; On-site; GBP 45,000 - 80,000; Full time

Job summary

An established industry player is seeking a Data Engineer II to join their dynamic team. This role involves managing large-scale ETL processes and developing scalable code to ensure real-time data availability. The successful candidate will leverage their expertise in SQL Server and scripting languages like Python and PowerShell to enhance data pipelines and contribute to innovative solutions. Join a forward-thinking company that values collaboration and offers a chance to work on impactful projects across global teams. If you have a passion for data and technology, this opportunity is perfect for you!

Qualifications

• 2-4 years of experience in data engineering or related field.
• Expertise in SQL Server and ETL processes.

Responsibilities

• Execute projects for large-scale enterprise ETL processes.
• Manage data delivery and oversee Data Engineers and Analysts.

Skills

SQL Server

Python

PowerShell

RDBMS technologies

Data validation

ETL processes

Data analysis

Education

Bachelor's degree in Computer Science

Master's degree in a quantitative field

Tools

SSIS

.Net

Job description

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, 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

Role description:

The Data Engineer II will participate in data management aspects of client engagements to deliver Test & Learn and other D&S delivery solutions, as well as contribute to and foster a high-performance collaborative workplace. A Data Engineer II will:

1. Independently execute projects through design, implementation, automation, and maintenance of large-scale enterprise ETL processes for a global client base.
2. 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.
3. Act as an expert data resource within the team.
4. 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.
5. Build trust-based working relationships with peers and clients across local and global teams.
6. Implement best practices and collaborate in the design of effective streamlined processes for a complex global solutions group.
7. Leverage industry best practices including proper use of source control, code reviews, data validation, and testing.
8. Enhance big data pipelines using Python, R, SSIS, and PowerShell to address complex technical challenges and seamless communication with cloud storage technologies.
9. 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 processing time of multi-billion row data sets.
10. Contribute to the automation capabilities of the team by implementing techniques to optimize and routinize repeatable tasks for Test & Learn data setup.
11. Comply with and uphold all Mastercard internal policies and external regulations.

Minimum job requirements:

• Bachelor's degree in a quantitative field (e.g., Computer Science, Statistics, Econometrics, Engineering, Mathematics, Operations Research). Master's degree preferred.
• Excellent English quantitative, technical, and communication (oral/written) skills; an excellent listener.
• Expertise and hands-on experience with RDBMS technologies, preferably with Microsoft SQL Server, the SSIS Stack, and .Net.
• Proficiency with at least one scripting language (PowerShell, Python).
• Proven self-motivated leader with experience working in multiple teams spread across several geographies.
• Demonstrated excellent skills in innovation, critical thinking, and problem disaggregation. Able to provide oversight, validation, and quality control to own and team work products.
• Skilled at balancing multiple projects and differing priorities.
• Flexible to work with global offices across several time zones.

Years of relevant experience:

2 - 4 years

Fields of educational study:

Computer Science, Statistics, Econometrics, Engineering, Mathematics, Operations Research

Corporate Security Responsibility

All activities involving access to Mastercard assets, information, and networks come with an inherent risk to the organization. Therefore, 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;
• Complete all periodic mandatory security trainings in accordance with Mastercard's guidelines.