Data Engineer

CFC- Chatham Financial Corporation; Kennett Square (Chester County); On-site; USD 110,000 - 150,000; Full time

Job summary

Chatham Financial is seeking a Data Engineer to join the Product Engineering team and build scalable data solutions that power analytics and client-facing features. You will design data models, pipelines, and analytics using Python, .NET, Snowflake, and Cube Core, collaborating with analysts, data scientists, and other engineers.

The role emphasizes cloud data platforms, AI-enabled analytics, and data quality, with opportunities to impact product functionality and business insights.

Qualifications

• Educational background in CS/IT/Statistics/Math/MIS required or strongly preferred.
• Advanced SQL and scripting; strong Python skills expected.
• Experience with data modeling, ETL/ELT, and data warehousing best practices.
• Ability to contribute across codebases in multiple languages for microservices.
• Familiarity with modern data platforms (Snowflake, Databricks) and orchestration tools (Dagster, Airflow).

Responsibilities

• Design and implement data models, pipelines, transformations, and analytics across the Data Platform using Python, .NET, Snowflake, and Cube Core.
• Collaborate with teams to enable analytics and ship critical use cases.
• Review data platform components and support improvement plans with senior engineers.
• Model data structures to support analysis and reporting requirements.
• Ensure data warehouse integration, quality, and alignment with business requirements.
• Work with data analysts/scientists to understand data needs and provide solutions.

Skills

Advanced SQL

Python

OOP & Design Patterns

Multi-language codebases

CI/CD with GitHub

Cross-team collaboration

Data modeling

Cloud familiarity

Education

B.S./M.S. in CS/IT/Stats/Math/MIS

Tools

Snowflake

Cube Core

dbt (data build tool)

Databricks

Microsoft Fabric

Dagster

Airflow

Azure Container Apps

Power BI / Looker ML

Job description

Job Description:

Overview:

We don't simply hire employees. We invest in them. When you work at Chatham, we empower you - offering professional development opportunities to help you grow in your career, no matter if you've been here for five months or 15 years. Chatham has worked hard to create a distinct work environment that values people, teamwork, integrity, and client service. You will have immediate opportunities to partner with talented subject matter experts, work on complex projects, and contribute to the value Chatham delivers every day.

The technology team at Chatham is responsible for building scalable, innovative fintech solutions that power global investment decisions. As a Data Engineer, within the Product Engineering department, you will contribute to Data Engineering solutions & infrastructure underpinning products that Chatham Financial exposes to its clients or to its internal users. Reporting to the Senior Data Analyst (TL), you will implement cloud services and capabilities that reliably expose data at scale, enabling AI-first programmatic analytics for critical use-cases.

In this role you will:

• Design and implement data models, pipelines, transformations, and analytics across Chatham's Data Platform using a mix of Python, .NET, Snowflake and Cube Core
• Pair with other teams to supercharge their usage of analytical services that enable them to ship critical use-cases
• Participate in reviewing existing components/features of the Cloud Data Platform periodically with more-experienced Data Engineers and support them in executing against improvement plans
• Participate in data modelling activities to design efficient and effective data structures that support data analysis and reporting requirements.
• Review work done by other Data Engineers from the perspective of data warehouse integration practices, data modeling practices, degree of alignment to and/or completeness of business requirements
• Collaborate with data analysts and data scientists to understand data requirements and provide support for complex Data Analytics solutions
• Assist in identifying and resolving data-related issues and errors, working with the team to implement appropriate solutions.

Your impact:

As a Data Engineer, you will play a key role in building and evolving Chatham's data platforms by delivering modern, scalable and reliable data solutions. Your work will directly support analytics, product functionality, and client-facing capabilities while helping drive improvements in platform quality and performance.

Contributors to your success:

• B.S. or M.S. studies in Computer Science/Information Technology / Statistics / Mathematics / Management Information Systems
• Advanced SQL database querying and scripting
• Strong knowledge of a scripting language (preferably Python) and proven knowledge of OOP and Design Patterns
• Ability to contribute across codebases in multiple programming languages employed in micro-service development or similar (such as Python, .NET)
• Strong knowledge of dbt (data build tool) or similar transformation frameworks such as SQLMesh or Dataform
• Hands-on experience with at least one modern data platform, preferably Snowflake; experience with Databricks or Microsoft Fabric is also relevant
• Hands-on experience with building highly scalable data querying/retrieval Web Services, employing tooling such as Cube Core or similar (Power BI Tabular Models, Looker ML etc.)
• Hands-on experience with at least one modern data orchestration product, preferably Dagster; experience with Prefect or Airflow is also relevant
• Experience with Azure cloud and web services, ideally Azure Container Apps or similar
• Experience with CI/CD pipelines, preferably GitHub-based
• Experience with Cube Core represents a big plus
• Experience applying AI and automation tools in day-to-day engineering work represents a big plus
• Proven previous experience in working as part of Data Engineering or Data Analytics teams for Product companies creating data-oriented software solutions
• Good understanding of data warehousing methodologies (Kimball, Inmon, Data Vault 2.0)
• Good understanding of data modelling practices (relational, entity-relationship, object-oriented, flat, query-first)
• Good understanding of data engineering design patterns (raw loads, replication, batch ETL, streaming ETL, ELT, stream processing, data virtualization, change data capture)
• Strong knowledge of a typical SDLC
• Must be a self-starter, with the ability to work independently, with different groups and teams, utilizing solid communication skills.
• Ability to work in cross-functional teams

About Chatham Financial:

Chatham Financial is the leading independent capital markets advisor, delivering an integrated blend of expert advice and powerful technology to help you reduce risk and seize opportunity. With decades of capital markets strategy, execution, monitoring, and performance expertise, we serve as an unwavering advocate for your best interests and your innovation partner. O