Data Engineer

Merchants Bank of Indiana is seeking a Data Engineer to support financial services and broader Enterprise Data initiatives. In this onsite role in Carmel, IN, you will design and maintain scalable data pipelines and Lakehouse architectures, helping ensure reliable data flow for investment, portfolio, and capital markets reporting.

You will work with Microsoft Fabric and Python to build ETL/ELT solutions, manage integrations, and strengthen governance and auditability across inbound data. The role also emphasizes automation through CI/CD practices and disciplined version control across the full data delivery lifecycle.

Responsibilities

• Design, build, and optimize ETL/ELT pipelines using Microsoft Fabric Notebooks (Python) and Fabric Pipelines.
• Apply CI/CD pipelines to automate deployments, testing, and releases using tools and workflows such as Azure DevOps and Fabric deployment pipelines.
• Maintain version control for code, pipeline definitions, SQL models, and integration scripts.
• Build and maintain data integrations, starting with 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 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 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, across code 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, plus required books and materials