Data Engineer

Chatham Financial Company; Kennett Square (Chester County); Presencial; USD 90.000 - 130.000; Jornada completa

Descripción de la vacante

Chatham Financial in Kennett Square, PA is seeking a Data Engineer to design and implement data models, pipelines, and analytics on a scalable data platform. You will collaborate with analysts, engineers, and data scientists to deliver reliable data services powering AI-first analytics and client-facing capabilities.

The role emphasizes cloud data platforms, dbt, Snowflake, and modern orchestration with Dagster or Airflow.

Formación

• BS/MS in CS/IT/Stats/Math/MIS or equivalent.
• Strong SQL skills and scripting ability.
• Experience with data modeling, ETL/ELT, and data warehousing concepts.
• Hands-on with cloud data platforms and orchestration tools.

Responsabilidades

• Design data models, pipelines, and analytics on the data platform.
• Collaborate with analysts/scientists to support analytics use-cases.
• Review data warehouse integration and modeling for completeness.
• Develop scalable data services and expose data at scale.

Conocimientos

Advanced SQL

Python

OOP & Design Patterns

Cloud data platforms

dbt or similar tooling

Snowflake

Databricks / Microsoft Fabric

REST/Web services concepts

Dagster or Airflow

Azure cloud services

CI/CD (GitHub)

Educación

B.S. or M.S. in CS/IT/Statistics/Math/MIS

Herramientas

Snowflake

Cube Core

Power BI / Looker ML

Databricks

GitHub Actions

Descripción del empleo

Data Engineer# Careers Home## Data EngineerApply: Kennett Square: Full time: Posted 2 Days Ago: R-100347**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. Our technology platform unifies data across assets, debt, and derivatives, giving you unmatched agility, transparency, and insight.**It’s clear ahead.**Our commitment is to carry that light forward in every partnership, every solution, and every market we serve.We help guide the way—giving clients the insight and momentum to move forward with confidence, no matter what lies ahead.