Merchants Bancorp is seeking a Data Analyst to design, optimize, and maintain scalable data pipelines, ensure efficient data processing and integration across business systems, and translate complex business requirements into compelling, interactive dashboards and reports that drive data-driven decision-making.
Requirements
- Expertise in Microsoft Fabric, Medallion Architecture, Fabric Data Factory, and Lakehouse design principles.
- Strong proficiency in Python, SQL, Power Query, and Delta Lake management.
- Proven expertise in Power BI dashboard development and design.
- Advanced proficiency in DAX, Power Query, SQL, and data modeling.
- Experience working with large datasets and ensuring efficient data processing.
- Strong proficiency in Microsoft Fabric, Python, Power BI visualization and design
- Experience in data engineering and business intelligence
Responsibilities
- Design, build, and optimize Fabric Pipelines for seamless data movement, transformation, and automation.
- Implement Fabric Data Factory workflows for ETL orchestration, ensuring performance, scalability, and efficiency within a Fabric-driven ecosystem.
- Support Lakehouse structures using Fabric’s Bronze, Silver, and Gold Medallion methodology for organized, high-quality data processing.
- Ensure data integrity, security, and governance through Microsoft Purview and Fabric compliance frameworks.
- Integrate APIs and external systems to enhance interoperability, automation, and data accessibility across Fabric environments.
- Design, develop, and optimize Power BI dashboards and reports to visualize key business metrics.
- Develop data models that support business intelligence reporting.
Other
- Bachelor’s or master’s degree in computer science, Data Engineering, Business Intelligence, or related fields.
- Minimum experience requirements: At least one year of relevant experience with a master's degree or three years with a bachelor's degree in data engineering, analytics, or business intelligence.
- Excellent communication skills to translate technical findings into business-friendly insights.
- Strong analytical thinking and problem-solving abilities.
- Ability to work closely with stakeholders across departments to enhance data accessibility, automation and ensure that visual analytics align with business objectives and offer actionable insights.
