Data Engineer II

Delan Associates, Inc

$100K — $130K *
Information Technology
Less than 5 years of experience
Job Overview by Ladders

Qualifications

  • 5+ years of experience as a Data Engineer or in a similar data-focused position.
  • Strong SQL development and query optimization skills.
  • Proficient in Apache Spark (including PySpark, Spark SQL, Spark Streaming).
  • Experience with the Hadoop ecosystem (HDFS/Ozone, Hive, YARN).
  • Solid programming skills in Python for data engineering applications.
  • Familiarity with ETL pipeline construction and maintenance.
  • Understanding of data modeling and database design principles.

Responsibilities

  • Design and develop enterprise-level ETL processes and data pipelines.
  • Build scalable data processing solutions for timely business-critical data delivery.
  • Utilize Apache Spark and Hadoop technologies to optimize big data workflows.
  • Collaborate with Data Engineers, Analysts, and stakeholders on data solutions.
  • Troubleshoot and resolve data issues while ensuring integrity and quality.
  • Support dashboard/reporting initiatives by supplying clean datasets.
  • Improve data processing performance through SQL and database technologies.
  • Participate in automation projects to enhance operational efficiency.

Benefits

  • Hybrid work schedule with three days in the office.
  • Stable work hours, Monday to Friday, 9 AM to 5 PM ET.
  • Opportunity to work on large-scale data platforms for global clients.
  • Collaborative environment with close partnerships across teams.
Full Job Description
Spark, Hadoop, and Python are the skills required for the role. It will be hybrid, 3 days a week in office. Please Focus on local resources or candidates within a commutable distance to Arlington

Interview: F2F

Assessment: Glider - Data Engineering (Advanced)

Overview

seeking an experienced Data Engineer II to join the Analytics Solutions Team. This team partners with stakeholders to extract data from the Data Warehouse, transform and optimize it, and build reporting/dashboard solutions that deliver actionable insights to clients.

The ideal candidate will have strong hands-on experience with Spark, Hadoop, Python, and SQL, along with a background building scalable data pipelines and ETL solutions in large data environments.

Work Schedule

Monday - Friday

9:00 AM - 5:00 PM ET

Hybrid schedule (3 days onsite per week)

No travel required

Interview Process

Two rounds minimum

Hiring Manager

Team Interview

In-person interviews preferred

Top Required Skills
• Apache Spark (PySpark, Spark SQL, Spark Streaming)
• Hadoop Ecosystem (HDFS/Ozone, Hive, YARN)
• Python

Level Required: Advanced

Key Responsibilities

Design, develop, and support enterprise-scale ETL processes and data pipelines.

Build scalable and efficient data processing solutions that ensure timely delivery of business-critical data.

Develop and optimize big data workflows using Apache Spark and Hadoop technologies.

Partner with Data Engineers, Analysts, and business stakeholders to deliver high-quality data solutions.

Troubleshoot data issues and implement solutions that maintain data integrity and quality.

Support dashboard and reporting initiatives by delivering clean, transformed datasets.

Utilize SQL and database technologies to improve data processing performance and efficiency.

Participate in automation initiatives to streamline operational and data engineering processes.

Follow engineering best practices including code reviews, version control, testing, and data validation.

Ensure compliance with Mastercard internal policies and industry regulations.

Required Qualifications

Experience as a Data Engineer or similar data-focused role.

Strong SQL development and query optimization experience.

Hands-on experience with:

Apache Spark (PySpark, Spark SQL, Spark Streaming)

Hadoop ecosystem (HDFS/Ozone, Hive, YARN)

Python

Experience building and maintaining ETL pipelines.

Understanding of data modeling and database design principles.

Ability to troubleshoot and resolve complex data issues independently.

Experience validating and testing data for quality and consistency.

Strong written and verbal communication skills.

Bachelor's degree in Engineering, Mathematics, Finance, Business, Computer Science, or a related field (or equivalent practical experience).

Additional Details

Excellent opportunity to work on large-scale data platforms supporting global clients.

Target Profile: Data Engineers with strong Spark/Hadoop backgrounds who have built enterprise data pipelines and are comfortable working in a large-scale analytics environment.

Similar Jobs

More Jobs at Delan Associates, Inc

More Information Technology Jobs

Find similar Data Engineer II jobs: