Engineer, Data Engineering

Federated Hermes, Inc., a global leader in active, responsible investing, is seeking an Engineer to join our Enterprise Data Team within our Global Technology Organization basedin our Warrendale, Pennsylvania office.

This position is a senior technical leadership position as a member of the Enterprise Data Team under the Global Technology Organization. In this role, you will be hands on technical lead, leading the design, development, implementation and optimization of data solutions on the Databricks platform. The position does not include direct HR management, but does require technical leadership, mentoring, supporting and leading the establishment of standards for all of the team’s data platform work.

• Design, build, and maintain scalable data pipelines on Databricks
• Provide architectural, design and technical guidance to more junior team members
• Drive best practices in data engineering across the team
• Design and build improvements to the existing metadata driven ingestion framework
• Use generative AI platforms and agents like Claude Enterprise to automate and improve data pipeline creation and maintenance
• Write clean, efficient and maintainable PySpark or SQL code for data pipelines
• Design robust data models for analytics and reporting
• Design and implement batch and streaming data workflows
• Monitor and optimize performance of Spark jobs and cluster usage
• Ensure compliance with data governance, security and data privacy standards

This position offers a hybrid schedule (in-office/remote) and is located in Federated Hermes’ Warrendale, Pennsylvania office (15086).

• Expert level hands-on data engineering with Databricks (Azure preferred), Pyspark, lakehouse and SQL
• Strong experience or working knowledge of data modeling, including knowledge of dimensional modeling and name value pair
• Strong working knowledge of medallion architecture
• Experience using or configuring Databricks features including Unity Catalog, Delta Live Tables, and Delta Sharing
• Minimum of 5 years’ programming experience which includes a minimum of one year working with big data platform, experience in data engineering domain, Python, SQL, and cloud platforms
• Bachelor’s degree in computer science, engineering, or a related field with relevant continuing education preferred
• Ability to elicit requirements and collaborate with senior team members as part of solution design
• Experience with CI/CD pipelines and version control tools required
• Knowledge of data visualization tools and BI platforms preferred

We believe our employees are our most important asset! Therefore, we offer benefits programs designed to help you and your family thrive, training programs to advance your professional development and opportunities for you to give back to the community. Our offerings include:

• A competitive total compensation package, including bonus programs designed to recognize and incentivize our employees to do their best every day.
• Time off programs including paid vacation, parental leave and a volunteer day to help you stay healthy and connected to the things that are important.
• Opportunities to expand your professional network within the firm and the community through participation in programs such as the Women in Investing Employee Resource Business Group and the University Ambassador Program.

At Federated Hermes, our goals are to help individuals invest and retire better, to help our clients achieve better risk-adjusted returns, and to contribute to the positive outcomes in the wider world. We pledge to always putting our clients first and to acting responsibly and transparently. Our commitment to active investment has enabled us to become a leading investment…