Data Engineer II

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 IIWho is Mastercard?Mastercard is a global technology company in the payments industry. Our mission is 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. With connections across more than 210 countries and territories, we are building a sustainable world that unlocks priceless possibilities for all.
The Open Banking Business Intelligence team is responsible for Analytics, Automation and innovative development of Analytics services to address the evolving performance needs of all of Mastercard’s Open Banking customer segments. The OB BI team in P&E focuses on defining the strategic direction for Metrics and Key Performance Indicators to enable the successful implementation of our services with the end-customer. The team is responsible to look across all the products/services across OB and drive Quality and Performance by democratizing access to Data and Analytics.
The candidate for this position will focus on supporting large account and prospect customer by leveraging data analytics to enable data-driven sales and decision making across all OB products, services and processes.
Role
We are looking for team members who:
• Analyze large volumes of transaction and product data to generate insights and actionable recommendations to drive business growth.
• Support Sales Team in their efforts to scale the Sales effort by identifying data-driven opportunities and developing relevant supporting materials.
• Collect and synthesize feedback from clients, development, product and sales teams for new solutions or product enhancements.
• Apply knowledge of metrics, measurements, and benchmarking to complex and demanding solutions.
• Data mining, model development, time series analysis, forecasting.
• Create highly predictive models using segmentation and regression techniques to drive profits
• Knowledge of metrics, measurements, and benchmarking to complex and demanding solutions across multiple industry verticals
• Review analytics end-products to ensure accuracy, quality and timeliness.
• Synthesize analyses into clear, sound recommendations; takes responsibility for structuring and writing reports and client ready presentations.
• Standardization of data driven insights and advanced analytics solutions using tools such as Tableau, Alteryx, SQL and MS office suite
• Develops effective working relationships with global teams and business partners
• Proactively seeks new knowledge and structures project work to facilitate the capture of Intellectual Capital with minimal oversight
All about You
• Experience in Payments/Financial Services Industry
• Experience in hands-on business analysis, modelling and segmentation and data mining using large volumes of granular data to deliver analytical solutions.
• Strong Tableau, Alteryx, Python, MS-Excel and PowerPoint skills.
• Platforms/Environments: Hadoop, SQL, Tableau, Alteryx
• Exposure to collecting and/or working with data including standardizing, summarizing, offering initial observations and highlighting inconsistencies.
• Strong understanding of the application of analytical methods and data visualization to support business decisions.
• Ability to understand complex operational systems and analytics/business intelligence tools for the delivery of information products and analytical offerings to a large, global user base.
• Able to work in a fast-paced, deadline-driven environment as part of a team and as an individual contributor
• Ability to easily move between business, analytical, and technical teams and articulate solution requirements for each group
• Excellent written and oral communication skills
• The Senior Data Engineer will support Mastercard Open Banking products through client data ingestion, processing, and coordination. A Senior Data Engineer will:
• Lead relationships with Mastercard Operations and Technology teams to facilitate the transfer of client data
• Act as an expert resource within the team across subjects, including Mastercard’s Data Warehouse, PCI compliance, source control, data validation, and testing
• 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.
• Lead the automation capabilities of the team. Implement techniques to optimize and routinize repeatable tasks for Test & Learn data setup
• Apply outstanding communication skills, project management skills, and reliability in promptly reacting to incoming requests with an estimated timeline and any needed clarifications, and meeting expressed timelines.
• Mentor junior team members in terms of career, skillset, and team contributions
• Set an example for and foster a high-performance collaborative workplace
• Comply with and uphold all Mastercard internal policies and external regulations
Minimum job requirements:
• Excellent English communication (oral/written) skills
• Expertise and hands-on experience with RDBMS technologies, preferably with Microsoft SQL Server, the SSIS Stack and .Net
• Proficiency with scripting languages (e.g. Powershell, Python, Bash, Korn Shell, AWK scripting, C Programing, Oracle SQL, PL/SQL)
• Proficiency with Oracle Exadata strongly preferred
• Proven self-motivated leader with experience working in teams spread across several geographies
• Demonstrated excellent skills in the ability to innovate, think critically and disaggregate problems. Able to provide oversight, validation and quality control to own and team work product
• Skilled at balancing multiple projects and differing project priorities
• Flexible to work with global offices across several time zonesMastercard is an inclusive equal 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. In the US or Canada, if you require accommodations or assistance to complete the online application process or during the recruitment process, please contact [email protected] 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.
Pay Ranges
New York City, New York: $115,000 - $184,000 USD