Data Engineer

Merchants Bank of Indiana • Carmel, IN

10d

About The Position

The Data Engineer will enhance the business technology team’s data engineering capabilities, focusing on financial services data—including accounting and finance—and broader Enterprise Data initiatives. The role designs, builds, and maintains scalable data pipelines, integrations, and Lakehouse architectures using technologies such as Python, Microsoft Fabric, Azure DevOps, and Jira.

The Data Engineer works confidently and independently to develop ETL/ELT pipelines, automate deployments and testing, maintain version control, integrate source systems with the enterprise data warehouse, and manage medallion-architecture Lakehouse structures. The role also supports investment reporting, portfolio analytics, capital markets insights, data quality, auditability, monitoring, reconciliation, and enterprise data governance documentation.

Requirements

• Bachelor’s or Master’s degree in computer science, data analytics, or a related field.
• At least 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 using Azure DevOps, GitHub, or similar tools.
• Experience with version control, preferably Git-based, for managing 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.

Nice To Haves

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

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 code deployments, testing, and releases.
• Maintain version control across code, pipeline definitions, SQL models, and integration scripts.
• Build and maintain integrations, initially with Salesforce, to sync source-system data with the enterprise data warehouse in Microsoft Fabric.
• Architect and manage Bronze/Silver/Gold Lakehouse structures aligned 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 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.

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level