Data Engineer
Job Description
Merchants Bank of Indiana is seeking a Data Engineer in Carmel, IN (onsite) to design, build, and maintain scalable data pipelines, integrations, and Lakehouse architectures. The role supports financial services data initiatives as well as broader Enterprise Data efforts, using Python and Microsoft Fabric.
What you’ll do
- Design, build, and optimize ETL/ELT pipelines using Microsoft Fabric Notebooks (Python) and Fabric Pipelines.
- Apply CI/CD automation with tools such as Azure DevOps, Git-based workflows, and Fabric deployment pipelines to streamline deployments, testing, and release processes.
- Maintain version control for code, pipeline definitions, SQL models, and integration scripts.
- Build and maintain data integrations, starting with Salesforce, to sync data from source systems into the enterprise data warehouse in Microsoft Fabric.
- Architect and manage Lakehouse structures using Bronze/Silver/Gold patterns 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 monitoring, validation, and reconciliation processes to support trusted investment and risk reporting.
- Maintain metadata, data dictionaries, and technical documentation aligned with Enterprise data governance.
What you bring
- 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.
- Strong Python skills for data engineering, automation, and integration tasks.
- Experience building and managing CI/CD pipelines (such as Azure DevOps, GitHub, or similar).
- Hands-on experience with version control, preferably Git-based, across code, pipelines, and deployment artifacts.
- Experience integrating systems using Bulk API, REST API, or connector-based ingestion.
- Knowledge of data quality frameworks and data governance concepts.
Benefits and support
- Medical, dental, and vision coverage
- 401(k) and Employee Stock Ownership Plan (ESOP) participation
- Generous paid time off
- Wellness resources
- Tuition Assistance Program that covers 100% of eligible tuition expenses, plus required books and materials
Tools you’ll work with
- 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
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