Data Engineer

Merchants Capital is seeking a Data Engineer for its Merchants Bank of Indiana business technology team. The role focuses on designing, building, and maintaining scalable data pipelines, integrations, and Lakehouse architectures for financial services and enterprise data initiatives.

Responsibilities

Design, build, and optimize ETL/ELT pipelines utilizing Microsoft Fabric Notebooks (Python) and Fabric Pipelines

Utilize CI/CD pipelines (Azure DevOps, Git-based workflows, Fabric deployment pipelines, etc.) 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 Salesforce) for syncing data between source systems and the enterprise data warehouse in Microsoft Fabric

Architect and manage Lakehouse (Bronze/Silver/Gold) structures aligning 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 alignment with Enterprise data governance

Preferred

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

Investment Data

Capital Markets Data

Financial Services Data

Git-Based Workflows

DevOps Pipelines

Fabric Deployment

Power BI

Semantic Model Support

Cloud-Based Orchestration

Event-Driven Patterns

Benefits

Medical, dental and vision coverage

401(k) participation

Employee Stock Ownership Plan (ESOP) participation

Generous paid time off

Wellness resources

Tuition Assistance Program covering 100% of eligible tuition expenses, as well as required books and materials

Company

Multifamily housing lender and tax credit equity syndicator.

Carmel, Indiana, USA

https://www.merchantscapital.com/

Founded in 1990

51-200 employees

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

Proficient 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) from managing code, pipelines, and deployment artifacts

Hands-on experience integrating systems (Bulk API, REST API, or connector-based ingestion)

Experience with data quality frameworks and data governance concepts

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

3+ years of experience in data engineering or cloud ETL development.

Required skills

Python, Microsoft Fabric, CI/CD Pipelines, Azure DevOps, Git, REST API Integration, Bulk API Integration, Data Quality, Data Governance, Financial Services Data, Power BI, Semantic Models

Preferred skills

Power BI and semantic model support experience

Experience

3+ years