onsite
Lead Software Engineer - ETL - PNC Financial Services Group
Software Engineer
Lead a team of engineers to design, build, and maintain scalable ETL pipelines and data warehouses, leveraging SQL, Python, and AWS services while aligning solutions with business strategy.
About the role
Key Responsibilities
- Architect, develop, and optimize high‑performance ETL processes that ingest, transform, and load large volumes of financial data.
- Lead a cross‑functional engineering team, providing technical guidance, code reviews, and mentorship.
- Collaborate with product owners, data analysts, and infrastructure teams to translate business requirements into robust data solutions.
- Implement and maintain data warehouse structures on cloud platforms, ensuring data quality, security, and compliance.
- Drive continuous improvement by adopting Agile practices, automated testing, and CI/CD pipelines.
Requirements
- 5+ years of hands‑on experience designing and operating ETL pipelines, preferably in a financial services environment.
- Strong proficiency in SQL and a programming language such as Python for data manipulation and automation.
- Experience with cloud services (AWS) including S3, Redshift, Glue, or similar data‑engineered solutions.
- Demonstrated ability to lead technical teams, manage stakeholder expectations, and deliver projects on schedule.
- Solid understanding of data modeling, warehousing concepts, and Agile development methodologies.