Data Engineer

Merchants Bank IN; India; On-site; INR 1,200,000 - 2,400,000; Full time

Benefits offered by this job

Medical, dental & vision coverage

401(k) & ESOP participation

Tuition Assistance Program

Job summary

Merchants is seeking a Data Engineer to join our business technology team to design, build, and maintain scalable data pipelines and Lakehouse architectures using Python, Microsoft Fabric, and modern DevOps practices.

You will work on data integrations (Salesforce, among others) and ensure data quality, governance, and reliable investment reporting across enterprise data initiatives.

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 (Git-based) for 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.

Responsibilities

• Design, build, and optimize ETL/ELT pipelines using Python in Fabric environments.
• Automate deployments and testing via CI/CD pipelines (Azure DevOps, Git-based).
• Maintain version control across code, pipelines, and SQL models.
• Build integrations (initially Salesforce) between source systems and the data warehouse.
• Architect and manage Lakehouse structures (Bronze/Silver/Gold).
• Develop scalable data models for investment reporting and analytics.
• Ensure schema alignment, consistency, and auditability across inbound data.
• Monitor, validate, and reconcile data for trusted reporting.
• Maintain metadata and data governance documentation.

Skills

Python

ETL pipelines

Data integration

CI/CD

Git

Education

Bachelor’s or Master’s degree in CS/Data Analytics

Tools

Azure DevOps

Microsoft Fabric

GitHub

SQL

Job description

Description

Our business technology team is enhancing its data engineering capabilities with focus in financial services data including accounting, finance, and broader Enterprise Data initiatives. We are seeking a skilled

Job Type

Full-time

Description

Our business technology team is enhancing its data engineering capabilities with focus in financial services data including accounting, finance, and broader Enterprise Data initiatives. We are seeking a skilled Data Engineer, along with at least three years of experience, who will design, build, and maintain scalable data pipelines, integrations, and Lakehouse architectures utilizing Python, Microsoft Fabric, Azure DevOps, Jira and more.

Our Data Engineer will be able to do the following confidently and independently...

• 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.

Requirements

What we are looking for...

• 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.

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.

Our Benefits

At Merchants, we believe in investing in our people. Our comprehensive benefits package includes medical, dental and vision coverage, 401(k) and Employee Stock Ownership Plan (ESOP) participation, generous paid time off, wellness resources, and a standout Tuition Assistance Program that covers 100% of eligible tuition expenses, as well as required books and materials. Whether you’re advancing your education, growing your career, or planning for the future, we’re committed to supporting your success every step of the way.

About Merchants

Ranked as a top performing U.S. public bank by S&P Global Market Intelligence, Merchants Bancorp is a diversified bank holding company headquartered in Carmel, Indiana operating multiple segments, including Multi-family Mortgage Banking that offers multi-family housing and healthcare facility financing and servicing; Mortgage Warehousing that offers mortgage warehouse financing; and Banking that offers retail and correspondent residential mortgage banking, agricultural lending, and traditional community banking. Merchants Bancorp, with $18.8 billion in assets and $11.9 billion in deposits as of December 31, 2024, conducts its business primarily through its direct and indirect subsidiaries, Merchants Bank of Indiana, Merchants Capital Corp., Merchants Capital Investments, LLC, Merchants Capital Servicing, LLC, Merchants Asset Management, LLC, and Merchants Mortgage, a division of Merchants Bank of Indiana.Merchants Bank and Merchants Capital have recently been honored with the 2025 USA Today Top Workplaces recognition, ranking 22nd nationally within the 500-999 employee category. This is the second year that Merchants has been recognized with this award. These accolades build on our strong history of workplace recognition, including being named a Best Place to Work in Indiana for seven consecutive years (2016-2022). For more information read the entire article here.