Data Engineer

Merchants Bank of Indiana; Carmel (IN); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Medical, dental, and vision coverage

401(k) + ESOP participation

Generous paid time off

Wellness resources

Tuition Assistance Program covering %

Job summary

Merchants Bank of Indiana in Carmel, Indiana is seeking a Data Engineer to design, build, and maintain scalable data pipelines and Lakehouse architectures for financial services and enterprise analytics.

You will leverage Microsoft Fabric, Python, and CI/CD tools to automate deployments, integrate Salesforce data, govern metadata, and support investment reporting and risk analytics in a secure data environment.

Qualifications

• Bachelor’s or Master’s degree in computer science, data analytics, or a related field.
• 3+ years of experience in data engineering or cloud ETL development.
• Proficiency in Python for data engineering, automation, and integration tasks.
• Experience designing and managing CI/CD pipelines (Azure DevOps, GitHub, or similar).
• Experience with version control, preferably Git-based, covering code, pipelines, and deployment artifacts.
• Hands-on experience integrating systems using Bulk API, REST API, or connector-based ingestion.
• Experience with data quality frameworks and data governance concepts.

Responsibilities

• Design, build, and optimize ETL/ELT pipelines using Microsoft Fabric Notebooks (Python) and Fabric Pipelines.
• Use CI/CD pipelines (Azure DevOps, Git-based workflows, Fabric deployment pipelines) to automate deployments, testing, and release processes.
• Maintain version control for code, pipeline definitions, SQL models, and integration scripts.
• Build and maintain data integrations, initially including Salesforce, to sync source systems with the enterprise data warehouse in Microsoft Fabric.
• Architect and manage Lakehouse structures (Bronze/Silver/Gold) aligned with enterprise medallion best practices.
• Develop scalable data models supporting investment reporting, portfolio analytics, and capital markets insights.
• Ensure schema alignment, consistency, and auditability across inbound data flows.
• Perform ongoing monitoring, validation, and reconciliation to support trusted investment and risk reporting.
• Maintain metadata, data dictionaries, and technical documentation in line with enterprise data governance.

Skills

Python

ETL/ELT

CI/CD pipelines

Azure DevOps

GitHub workflows

Salesforce integration

REST API

Bulk API

Data governance

Power BI

Lakehouse concepts

Education

Bachelor's or Master's in CS/Data analytics

Tools

Microsoft Fabric

Azure DevOps

Jira

GitHub

Job description

The Data Engineer role at Merchants Bank of Indiana focuses on designing, building, and maintaining scalable data pipelines, integrations, and Lakehouse architectures for financial services and broader enterprise data initiatives. The position is based onsite in Carmel, Indiana.

Responsibilities

• Design, build, and optimize ETL/ELT pipelines using Microsoft Fabric Notebooks (Python) and Fabric Pipelines.
• Use CI/CD pipelines (including Azure DevOps, Git-based workflows, and Fabric deployment pipelines) to automate deployments, testing, and release processes.
• Maintain version control for code, pipeline definitions, SQL models, and integration scripts.
• Build and maintain data integrations, initially including Salesforce, to sync source systems with the enterprise data warehouse in Microsoft Fabric.
• Architect and manage Lakehouse structures (Bronze/Silver/Gold) aligned with enterprise medallion best practices.
• Develop scalable data models supporting investment reporting, portfolio analytics, and capital markets insights.
• Ensure schema alignment, consistency, and auditability across inbound data flows.
• Perform ongoing monitoring, validation, and reconciliation to support trusted investment and risk reporting.
• Maintain metadata, data dictionaries, and technical documentation in line with enterprise data governance.

Requirements

• Bachelor’s or Master’s degree in computer science, data analytics, or a related field.
• 3+ years of experience in data engineering or cloud ETL development.
• Proficiency in Python for data engineering, automation, and integration tasks.
• Experience designing and managing CI/CD pipelines (Azure DevOps, GitHub, or similar).
• Experience with version control, preferably Git-based, covering code, pipelines, and deployment artifacts.
• Hands‑on experience integrating systems using Bulk API, REST API, or connector‑based ingestion.
• Experience with data quality frameworks and data governance concepts.

Preferred Skills

• Experience working with investment, capital markets, or financial services data.
• Familiarity with Git-based workflows, DevOps pipelines, or Fabric deployment processes.
• Power BI and semantic model support experience.
• Experience with cloud-based orchestration or event‑driven patterns.

Technologies

Python, Microsoft Fabric, Azure DevOps, Jira, Salesforce, ETL, ELT, CI/CD, Git‑based workflows, GitHub, SQL, REST API, Bulk API, Lakehouse (Bronze/Silver/Gold), Power BI.

Benefits

• Medical, dental, and vision coverage
• 401(k) and Employee Stock Ownership Plan (ESOP) participation
• Generous paid time off
• Wellness resources
• Tuition Assistance Program covering 100% of eligible tuition expenses, along with required books and materials