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…