Data Engineer

Merchants Bancorp • Carmel, IN

10d

About The Position

Merchants is seeking a Data Engineer to strengthen its data engineering capabilities, with a focus 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 Python, Microsoft Fabric, Azure DevOps, Jira, and related tools.

The Data Engineer builds ETL/ELT pipelines and system integrations, manages CI/CD and version control workflows, and architects Bronze/Silver/Gold Lakehouse structures in line with enterprise medallion practices. The role also develops data models for investment reporting, portfolio analytics, and capital markets insights; supports data quality, monitoring, reconciliation, and auditability; and maintains metadata, data dictionaries, and technical documentation aligned with Enterprise data governance.

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, such as Azure DevOps, GitHub, or similar.
• 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 release processes.
• Maintain version control across code, pipeline definitions, SQL models, and integration scripts.
• Build and maintain integrations, initially including Salesforce, to sync data between source systems and 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, required books, and materials

What This Job Offers

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