Data Analyst

Overview

Merchants Bank is expanding its analytics capability in supporting multifamily lending (MCC) and enterprise reporting requirements. This full‑time Data Analyst role focuses on developing analytical data models and reporting assets on Microsoft Fabric.

• Design, build, and maintain Power BI dashboards and reports using data sourced from Microsoft Fabric.
• Develop and manage Power BI semantic models, including table relationships, DAX measures, calculated columns, and aggregations.
• Write and optimize Fabric PySpark Notebooks for transformation, advanced analysis, data exploration, automation, and validation workflows.
• Utilize Microsoft Fabric (Lakehouse, Warehouse, Notebooks) to explore, analyze, and transform data for analytical consumption.
• Implement and maintain data validation and reconciliation logic to ensure accuracy and consistency of analytical outputs.
• Help support data integrations for pulling new data sources into Microsoft Fabric for reporting and analysis purposes.
• Perform data validation, reconciliation, and quality checks to ensure accuracy of loan, portfolio, and performance reporting.
• Troubleshoot data issues across semantic models, reports, and source datasets.
• Maintain technical documentation covering datasets, KPIs, DAX logic, and semantic definitions.
• Adhere to enterprise standards for data modeling, naming conventions, and analytics best practices.

• Bachelor’s or master’s degree in data analytics, information systems, finance, business analytics, or a related field.
• 2+ years of experience in data analysis, business intelligence, or analytics roles.
• Strong experience with Power BI, including report development and semantic (dataset) modeling.
• Solid working knowledge of SQL for querying and transforming analytical datasets.
• Experience using Microsoft Fabric or similar modern analytics platforms.
• Proficiency in Excel for analysis, validation, and stakeholder‑facing deliverables.
• Working knowledge of Python/PySpark for data analysis and automation.
• Ability to work with large, complex datasets and identify data quality or modeling issues.
• Strong analytical and problem‑solving skills, with the ability to communicate insights clearly to non‑technical audiences.

• Experience analyzing multifamily lending, mortgage, or real estate finance datasets.
• Familiarity with data modeling concepts (star schema, dimensions, facts, measures).
• Experience supporting executive, finance, or portfolio reporting.
• Understanding of data governance, metric standardization, and reporting best practices.
• Ability to communicate effectively with both technical and non‑technical stakeholders.
• Understanding of data integrations and working with APIs or import files.

Merchants Bancorp is a diversified bank holding company headquartered in Carmel, Indiana, with segments including Multi‑family Mortgage Banking, Mortgage Warehousing, and traditional community banking. With $18.8 billion in assets and $11.9 billion in deposits as of December 31 2024, the company operates through subsidiaries such as Merchants Bank of Indiana and Merchants Capital. 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.

The organization has also been named a Best Place to Work in Indiana for seven consecutive years (2016‑2022).