DataJobs.io
← Back to all jobs
Merchants Bank of Indiana

Data Engineer

Merchants Bank of Indiana
Carmel, IN Full time Posted 4d ago
Python Data Architecture Data Engineer Data Integration Data Pipeline Data Platform Data Warehouse ETL Lakehouse Power BI Reporting and Analytics SQL
Apply Now

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

Similar Jobs