Lead ETL Developer


Pennsylvania | Phila


All on Site

Position type

Direct Placement

Job Description

We are looking for a Lead Application Developer for our team.

The Lead Application Developer will architect and deliver data engineering technical solutions in the Data Warehouse / Data Lake space. This position will work closely with various solution development and infrastructure teams across the organization, such as application development teams, DevOps team, and System Administrators. The Developer will work with business partners to understand business needs in the data management area and to translate the specific requirements into technical solutions.

The Developer will design, develop, and maintain ETL / ELT ( Extract, Transform & Load / Extract, Load & Transform) solutions. The Developer is expected to bring the business requirement from a conceptual design to a technical solution through all phases of the software lifecycle: technical design, development, unit test, functional test support, and production implementation. Active participation in daily scrums within the Agile framework is expected.

Develop ETL / ELT data engineering solutions which support the business data requirements

Define and document the technical design specifications

Ensure compliance with security practices within the DevOps process

Participate in on-call support duties and daily scrum meetings

Develop architecture diagrams appropriate for the solutions

Conduct and participate in technical architecture reviews to validate the solution’s conformance to customer and systems requirements

Work with Architects and Database Administrators to enable development of efficient data solutions

Assist in the development of the coding standards

Assist other team members

Stay current with industry best practices and standards

Conduct peer reviews

Performs other duties as assigned

Bachelor’s Degree or equivalent experience in a technology related field or equivalent work experience

7+ years of proven experience in development of software solutions in the data engineering space

Highly skilled in ETL / ELT development

Highly skilled in SQL (Structured Query Language) development

Expert experience in one or more RDBMS systems (Teradata, Oracle, SQLServer, MySQL etc.)

Experience in Google Cloud Platform BigQuery is a plus

Strong data analytical and problem-solving skills

Ability to work within an Agile methodology and according to the DevOps process

Ability to improve application performance and identify performance tuning opportunities

Ability to define deliverables, tasks, and dependencies for multiple work streams

Adhere to enterprise application architecture policies and standards

Adhere to enterprise security standards and practices

Strong team player, excellent oral and written communication skills

Ability to communicate effectively with both business and technical teams

Fast starter, effectively deliver with limited supervision

Ability to work under pressure and meet aggressive deadlines

Experience with facilitating requirements and/or design meetings

Strong interpersonal, written, and verbal communication skills

Effective facilitation and presentation skills necessary to demonstrate business systems solutions in a clear and concise manner

Excellent teamwork

Excellent troubleshooting skills

Ability to learn new or existing systems quickly

Ability to work independently on multiple projects

Accountable for adherence to program and project management standards

Not the right fit?

Register with us and sign up for job alerts.

Ready to take the next step as

Lead ETL Developer?