Data Engineer II
Delan Associates, Inc•Arlington, VA
•Hybrid
About The Position
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.
Requirements
- 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).
Nice To Haves
- Apache Spark (PySpark, Spark SQL, Spark Streaming) - Advanced Level
- Hadoop Ecosystem (HDFS/Ozone, Hive, YARN) - Advanced Level
- Python - Advanced Level
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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
