Data Engineer II

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

Overview:
We seek a talented and motivated Data Engineer II to join the Mastercard Data and Services Technical Implementation team. As a Data Engineer II, you will participate in data management aspects of client engagements to deliver Data Integrations and other D&S delivery solutions and contribute to and foster a high-performance collaborative workplace.

Role:
•  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
•  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 solution group
•  Leverage industry best practices, including proper use of source control, code reviews, data validation, and testing
•  Leverage new SQL Server features such as Column store 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
•  Additional tasks as required

All About You:
•  Bachelor's degree in Computer Science, Engineering, Information Technology, Statistics, Mathematics, or a related field. Master's degree is a plus.
•  3+ years of experience in data engineering or related roles
•  Experience working with Hadoop, Hive, Spark, and PySpark technologies
•  Experience working with an orchestrator tool like Apache NIFI, Airflow, etc
•  Strong experience with SQL and data modeling concepts
•  Familiarity with data integration tools, ETL frameworks, and workflow management systems.
•  Knowledge of data warehousing, data lakes, and data architecture principles.
•  Hands-on experience with RDMS technologies, preferably with Microsoft SQL Server, the SSIS Stack, and .Net
•  Able to provide oversight, validation, and quality control to own work product
•  Able to handle multiple high-priority demands while driving consistent results
•  Strong communication skills – both verbal and written – and strong relationship, collaborative, and customer service skills
•  Able to work as a member of a diverse and geographically distributed team
•  Ability to quickly learn new technologies, development tools, and frameworks and mentor junior team members

In the US, Mastercard is an inclusive Equal Employment Opportunity employer that considers applicants without regard to gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law. If you require accommodations or assistance to complete the online application process, please contact reasonable_accommodation@mastercard.com and identify the type of accommodation or assistance you are requesting. Do not include any medical or health information in this email. The Reasonable Accommodations team will respond to your email promptly.

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.

In line with Mastercard’s total compensation philosophy and assuming that the job will be performed in the US, the successful candidate will be offered a competitive base salary based on location, experience and other qualifications for the role and may be eligible for an annual bonus or commissions depending on the role. Mastercard benefits for full time (and certain part time) employees generally include: insurance (including medical, prescription drug, dental, vision, disability, life insurance), flexible spending account and health savings account, paid leaves (including 16 weeks new parent leave, up to 20 paid days bereavement leave), 10 annual paid sick days, 10 or more annual paid vacation days based on level, 5 personal days, 10 annual paid U.S. observed holidays, 401k with a best-in-class company match, deferred compensation for eligible roles, fitness reimbursement or on-site fitness facilities, eligibility for tuition reimbursement, gender-inclusive benefits and many more.

Pay Ranges

O'Fallon, Missouri: $92,000 - $147,000 USD

Arlington, Virginia: $106,000 - $169,000 USD