Senior Data Engineer

  • Location: Wayne, Pennsylvania
  • Type: Direct Hire
  • Job #163229

This is a full time, direct hire position working for our client. 3 days on-site a week.


  • A minimum of 5 years of demonstrated experience in ETL processes using enterprise-level ETL tools (e.g., Informatica, SSIS, Talend, Matillion, Pentaho).
  • Bachelor’s degree in computer science, information technology, or a related field.
  • Proficiency in SQL and expertise in database systems, with a preference for experience in enterprise relational databases, such as Snowflake.
  • Hands-on experience with Microsoft and Unix platforms.
  • Strong knowledge of scripting languages (e.g., Powershell) and job schedulers.
  • Familiarity with various integration patterns, including Flat Files and Web Services.
  • Solid understanding of fundamental data modeling concepts, including ER Diagrams and normalization.
  • Experience with data warehousing techniques, such as dimensional modeling and star schema.
  • Ability to write technical documentation effectively.
  • Excellent troubleshooting and problem-solving skills, with the capability to debug complex code efficiently.
  • Aptitude for understanding the business context of problems to ensure optimal solutions.
  • Strong communication skills and the ability to work in a fast-paced, high-impact environment.


  • Conduct data profiling, source-target mappings, ETL development, SQL tuning, optimization, testing, and implementation.
  • Provide business and technical analysis for Data Warehouse and Business Intelligence initiatives.
  • Influence data warehouse design with recommendations for efficient data structuring.
  • Develop detailed technical specifications and ETL documentation in collaboration with data warehouse architects and Business Intelligence developers.
  • Lead both onshore and offshore developers to ensure efficient delivery of high-quality solutions.
  • Mentor ETL developers and conduct peer reviews, offering feedback on ETL design and implementation.
  • Design and develop ETL code, ETL audit controls, and scheduling processes.
  • Develop testing strategies and conduct testing to identify and resolve data quality issues.
  • Collaborate with Business Intelligence Developers throughout dashboard and application development, including requirements gathering, design feedback, and acceptance testing.
  • Independently build custom solutions, even when requirements are not clearly defined.
  • Stay current with emerging technologies and industry best practices.

Preferred Skills/Experience:

  • Familiarity with Python.
  • Experience with XML/XSLT.
  • Knowledge of Snowflake and Talend.
  • Cloud platform experience (AWS/Azure).


Attach a resume file. Accepted file types are DOC, DOCX, PDF, HTML, and TXT.

We are uploading your application. It may take a few moments to read your resume. Please wait!

Back to Top