Data Engineer

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

Benefits offered by this job

Health

Vision

Dental

401K

ESOP

100% Tuition Assistance

4 weeks paid time off

Job summary

Merchants Bank of Indiana is looking for a skilled Data Engineer to enhance their data engineering capabilities. The ideal candidate will design, build, and maintain scalable data pipelines using technologies like Python, Microsoft Fabric, and Azure DevOps.

With at least three years of experience, you will be responsible for optimizing ETL processes and integrating systems. Benefits include health coverage, tuition assistance, and generous paid time off.

Qualifications

• 3+ years of experience in data engineering or cloud ETL development.
• Proficient in Python for data engineering, automation, and integration tasks.
• Experience with version control (preferably Git-based).

Responsibilities

• Design, build, and optimize ETL/ELT pipelines using Microsoft Fabric Notebooks.
• Utilize CI/CD pipelines for automating code deployments and testing.
• Maintain version control across code, pipeline definitions, and SQL models.

Skills

Python for data engineering

CI/CD pipelines

Integration systems

Data quality frameworks

Education

Bachelor's or Master's degree in computer science, data analytics, or a related field

Tools

Microsoft Fabric

Azure DevOps

Salesforce

Job description

Description

Our business technology team is enhancing its data engineering capabilities with focus in financial services data including accounting, finance, and broader Enterprise Data initiatives. We are seeking a skilled Data Engineer, with at least three years of experience, who will design, build, and maintain scalable data pipelines, integrations, and Lakehouse architectures utilizing Python, Microsoft Fabric, Azure DevOps, Jira and more.

Data Engineer Responsibilities

• Design, build, and optimize ETL/ELT pipelines utilizing Microsoft Fabric Notebooks (Python) and Fabric Pipelines.
• Utilize CI/CD pipelines (Azure DevOps, Git-based workflows, Fabric deployment pipelines, etc.) to automate code deployments, testing, and release processes.
• Maintain version control across code, pipeline definitions, SQL models, and integration scripts.
• Build and maintain integrations (initially Salesforce) for syncing data between source systems and the enterprise data warehouse in Microsoft Fabric.
• Architect and manage Lakehouse (Bronze/Silver/Gold) structures aligning with enterprise medallion best practices.
• Develop scalable data models for investment reporting, portfolio analytics, and capital markets insights.
• Ensure schema alignment, consistency, and auditability across all inbound data flows.
• Implement ongoing monitoring, validation, and reconciliation to support trusted investment and risk reporting.
• Maintain metadata, data dictionaries, and technical documentation in alignment 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.
• Proficient 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) from managing code, pipelines, and deployment artifacts.
• Hands‑on experience integrating systems (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.

Benefits

Health, Vision, Dental, 401K, ESOP, 100% Tuition Assistance, 4 weeks paid time off, plus a few more.