Data Integration Engineer

Chatham Financial is hiring for the Role of Data Integration Engineer! Responsibilities of the Candidate: Contribute to Data Integration logic together with other Data Integration Engineers using a mix of SQL (dbt) and Python Perform data profiling of Raw Datasets to identify patterns and inform Data Integration logic to be created or validations to be instituted Debug and resolve issues appearing during the manual or automated execution of Data Ingestion workflows related to parsing raw data or Data Integration logic Engage more senior Data Integration Engineers to optimize existing Data Integration logic Take the necessary actions as stemming from technical feedback provided by more senior Data Integration Engineers actively participate in technical reviews to align to best practices Support technical data analysis efforts of peers within cross-functional teams (e.g., of Data Onboarding peers) Requirements: Advanced SQL database querying Intermediate knowledge in manipulating data using Python Proven expertise in handling semi-structured data formats like JSON and XML Proven expertise in using version control systems such as Git Proven experience of working with Command Line Interfaces to interact with tooling such as git, dbt, python, pyenv, choco, brew or other Represents a big plus proven understanding of Agile delivery practices Represents a big plus proven understanding of data warehousing concepts like landing & staging interfaces, idempotent operations, data contracts, interfacing producer and consumer etc. Represents a big plus experience with any of the following: dbt, Dataform or similar Represents a big plus experience with Data Warehouses or Data Lakes Represents a big plus experience in any of the following industries: Real Estate, Investment Management Represents a plus experience with any of the following: Snowflake, Power BI Desktop, Power Query, PowerShell