Data Engineer

Job Title: Data Engineer
Client: Mastercard (via Rose International)
Location: O’Fallon, MO – Hybrid (Local candidates only)
Duration: Contract
Visa: USC / GC only
Role Overview
We are seeking a Data Engineer with strong experience in big data technologies, ETL pipelines, and SQL optimization. The candidate will design and maintain scalable data pipelines, process large datasets, and support data-driven decision-making within enterprise systems.
Required Skills
Strong experience in Data Engineering / Data Pipeline development
Advanced SQL skills for querying and optimizing large datasets
Hands-on experience with Big Data technologies:
Apache Spark (PySpark, Spark SQL, Spark Streaming)
Hadoop ecosystem (HDFS, Hive, YARN)
Experience designing and maintaining ETL pipelines
Understanding of data modeling and database design
Working knowledge of Python
Experience troubleshooting and resolving data pipeline issues
Ability to validate and test data quality and accuracy
Responsibilities
Design, build, and maintain ETL data pipelines
Work with Spark and Hadoop-based data platforms
Write optimized SQL queries for large datasets
Develop scalable data engineering solutions
Collaborate with engineering and analytics teams
Troubleshoot data issues and maintain data quality
Required Education
Bachelor’s degree in Engineering, Mathematics, Finance, Business, or related quantitative field (or equivalent experience)