Data Engineer: Lakehouse Pipelines & FinOps (Onsite Carmel)

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

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.