Data Engineer II

at  MasterCard

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
Data Engineer II
Data Engineer II, Technical Implementation
Technical Implementation is part of the Mastercard Data & Services (D&S) Technology group and one of its fastest-growing organizations. D&S provides cloud-based analytic software platforms that enable large, consumer-focused businesses to seize Big Data analytics opportunities by triangulating between business strategy, algorithmic math, and large databases to improve decisions.
100 of the largest corporations in the world use these products. Test & Learn™ for Sites, Test & Learn™ for Customers, Mastercard Intelligence Center, and other similar products employ patented algorithms and workflow to design business experiences and interpret real-world data that evaluate, target, and refine business programs.
Technical Implementation is a core component to these services, managing the data acquisition, integration, and transformation of client provided data within the Test & Learn and other platforms for global engagements.
Role

The Data Engineer II will participate on 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:

• 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
• Implement best practices and collaborate in the design of effective streamlined processes for a complex global solutions group
• Leverage industry best practices including proper use of source control, code reviews, data validation and testing
• 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 for Test & Learn data setup
• Comply with and uphold all Mastercard internal policies and external regulations

All about you:

• BE/BTech in a quantitative field (e.g., Computer Science, Statistics, Econometrics, Engineering, Mathematics, Operations Research). ME/MTech preferred
• Excellent English quantitative, technical, and communication (oral/written) skills; an excellent listener
• Expertise with hands-on experience with RDMS technologies, preferably with Microsoft SQL Server, the SSIS Stack and .Net
• Proven self-motivated leader with experience working in teams
• Demonstrated excellent skills in the ability to innovate, think critically and disaggregate problems. Able to provide oversight, validation, and quality control to own work product
• Demonstrated excellent skills in the ability to innovate, think critically and disaggregate problems. Able to provide oversight, validation, and quality control to own and teamwork product
• Skilled at balancing multiple projects and differing project priorities

Flexible to work with global offices across several time zones
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.

• 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