Merchants Bank is expanding its analytics capability in supporting multifamily lending (MCC) and enterprise reporting requirements. We are seeking a Data Analyst with strong technical proficiency in Power BI, semantic modeling, SQL, and Python/PySpark.
This role focuses on developing analytical data models and reporting assets that sit on top of enterprise data platforms. The Data Analyst will work primarily within Microsoft Fabric to query, model, validate, and present data through scalable Power BI semantic models and reports.
As our Data Analyst, you will know you are successful if you can do the following confidently and independently...
- 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.
- Ability to understand and 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.