Data Engineer

Chatham Financial
Kennett Square, PA, United States
19 days ago
Apply on jobs.localjobnetwork.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours

Tech stack

.NET Framework Artificial Intelligence Airflow Business Analytics Applications Microsoft Azure Information Engineering Data Infrastructure Extract Transform Load (ETL) Data Structures Data Systems Data Vault Modeling Data Virtualization
+28 more
Data Warehousing Database Queries Software Design Patterns Entity Relationship Models Github Python (Programming Language) Object-Oriented Software Development Systems Development Life Cycle Cloud Services DataOps Software Systems Web Services Scripting Cloud Platform System Snowflake Data Build Tool (dbt) Change Data Capture Microsoft Fabric Information Technology Data Analytics Codebase Data Management Stream Processing Looker Analytics Data Pipelines Container Apps Databricks Programming Languages

Job description

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.

Requirements

  • 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 the company

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. Chatham Financial is an equal opportunity employer. Chatham Financial recruits, employs, compensates, transfers, promotes, and trains without regard to age, race, color, gender, marital status, sexual orientation, gender identity, national origin, religion, Vietnam era or veteran status, physical or mental disability, creed, citizen status or any other status protected by federal, state, or local law.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on jobs.localjobnetwork.com
Prepare application

Good distractions

Loading talks and stories from around this role…