Data Integration Engineer I

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 Data Integration Engineer I will report to the Lead Data Integration Engineer and will be a part of the Data Integration team. As part of the Data Integration projects, the Data Integration Engineer I will be focused on delivering a wider Product Enablement engagements in which cross-functional teams in the Chatham Financial Asset Platform enable and customize the company product for our clients in the Commercial Real Estate industry. The role will be based in Romania.

In this role you will:

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

Your impact:

As a Data Integration Engineer I you will play a critical role in the debugging, resolving issues and optimization processes along with more senior Data Integration Engineers. You will collaborate with internal teams and support technical data analysis to align to best practices.

Contributors to your success: 

• S. in Business / Economics / Management Information Systems / Computer Science
• 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

About Chatham Financial:

Chatham Financial is the largest independent financial risk management advisory and technology firm. A leader in debt and derivative solutions, Chatham provides clients with access to in-depth knowledge, innovative tools, and an incomparable team of over 750 employees to help mitigate risks associated with interest rate, foreign currency, and commodity exposures. Founded in 1991, Chatham serves more than 3,500 companies across a wide range of industries — handling over $1.5 trillion in transaction volume annually and helping businesses maximize their value in the capital markets, every day. To learn more, visit chathamfinancial.com.

Chatham Financial is an equal opportunity employer.

#LA-onsite 

#LA