Data Engineer II

TN United Kingdom; United Kingdom; On-site; GBP 40,000 - 60,000; Full time

Job summary

A leading company is seeking a Data Engineer II to manage and optimize data processes for global clients. The role involves executing large-scale ETL projects, developing scalable code, and collaborating with teams across various locations. Ideal candidates will have a strong background in data management, excellent communication skills, and the ability to innovate in a fast-paced environment.

Qualifications

• 2-4 years of relevant experience in data engineering.
• Expertise in RDBMS technologies and data management.
• Proficient in at least one scripting language.

Responsibilities

• Execute projects for large-scale ETL processes.
• Develop scalable code for data processing.
• Manage data delivery processes across teams.

Skills

Communication

Problem Solving

Innovation

Critical Thinking

Education

Bachelor's degree in a quantitative field

Master's degree (preferred)

Tools

Microsoft SQL Server

SSIS

.NET

Python

PowerShell

Job description

Social network you want to login/join with:

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

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 enable seamless communication with several 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 the 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 oversee, validate, and ensure quality in own and team work products.
• Skilled at balancing multiple projects and 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 inherent risks. 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.