jobapplier

Senior Data Solutions Engineer

Chatham Financial Corporation

Skills

Required

  • M.S
  • data warehousing methodologies
  • Kimball
  • Inmon
  • Data Vault
  • Dimensional
  • Data Warehousing
  • batch
  • Apache NiFi
  • SSIS
  • PostgreSQL
  • Microsoft SQL Server
  • Oracle

Preferred

  • imperative database deployment patterns
  • Flyway / Terraform
  • data pipelines
  • Power BI
  • Data Platform
  • data quality checks
  • validation processes
  • solution design

About Chatham Financial Corporation

  • 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.
  • 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.

Responsibilities

  • Design and implement data pipelines, transformations, models, and integrations across Chatham’s Data Platform using a mix of Snowflake and Power BI based solutions
  • Design, model, and onboard datasets required by client and product solutions
  • Work closely with the squad’s Tech Lead and Data Analyst to translate solution requirements into reliable Data Platform based implementations
  • Review and improve existing platform components, identifying opportunities for scalability, reliability, performance, and maintainability
  • Implement and maintain data quality checks, validation processes, and appropriate engineering controls
  • Contribute to solution design discussions and provide Data Engineering expertise on implementation approaches and trade-offs
  • Follow and contribute to Data Engineering standards and best practices across development, testing, deployment, and operations
  • Participate in code reviews and provide guidance and mentorship to less experienced engineers where appropriate
  • As a Senior Data Engineer, you will play a key role in turning complex client and product requirements into reliable, scalable Data Engineering solutions.
  • Working alongside the squad’s Tech Lead and Data Analyst, you will take ownership of the engineering components required to onboard, transform, validate, and expose data through Chatham’s Asset Platform.
  • Your work will ensure that solutions are robust, maintainable, and aligned with established platform standards.

Requirements

  • B.S. or M.S. in Statistics / Mathematics / Economics / Computer Science / Management Information Systems Deep understanding of data warehousing methodologies (Kimball, Inmon, Data Vault 2.0), with an emphasis on Dimensional Data Warehousing Deep understanding of data modelling (relational, entity-relationship, object-oriented, flat, query-first)
  • Deep understanding of data engineering design patterns (raw loads, replication, batch ETL, streaming ETL, ELT, stream processing, data virtualization, change data capture)
  • Proven understanding of Data Ops/DevSecOps/DevOps and how to properly implement, deploy, use & improve
  • Experience building Python-based data processing components or services in cloud environments (ideally Azure App Functions) Proven understanding of how data architecture interacts with broader technical, business, and security architecture
  • Ability to design and implement Data Engineering solutions, evaluate technical trade-offs, contribute to architectural decisions, and continuously improve engineering practices using at least one tool/software/technology from each of the following areas: Cloud Data Warehouse / Lakehouse Platforms (Snowflake preferable, but open to the following as well: Microsoft Fabric, Databricks, Amazon Redshift – list not exhaustive) Data Integration & Orchestration (one of the following: dbt, SQLMesh, StreamSets, Apache NiFi, Informatica, Talend, SSIS – legacy experience beneficial, list not exhaustive) RDBMS (one of the following: PostgreSQL, Microsoft SQL Server, Oracle, IBM DB2 – list not exhaustive)

Preferred

  • Great understanding of declarative & imperative database deployment patterns and proven usage of tools like
  • Flyway or Terraform or anything else similar

Storage (one of the following

Azure Blob, Azure Data Lake, AWS S3, Google Storage, general HDFS – list not exhaustive) Data Ops/DevSecOps/DevOps based on GitHub Actions or similar

Apply with Jobapplier