Business Analyst

United Franchise Group; West Palm Beach (FL); On-site; USD 85,000 - 120,000; Full time

Job summary

Doist is seeking a data-driven BI Analyst to design, develop, and maintain Power BI dashboards across our global brands. You will extract data from APIs, transform it in Python, and integrate outputs into comprehensive BI solutions.

The role focuses on revenue, profitability, and franchisee success, with collaboration across finance, operations, and product teams. You will optimize data models, automate reporting, and lead end-to-end data workflows using SQL databases and Git-based version

Responsibilities

• Design, develop, and maintain dynamic BI dashboards leveraging advanced DAX, data modeling, RLS, Power BI Apps and sophisticated algorithms to deliver insights for all brands and departments.
• Extract data via APIs, perform data transformation in Python using Jupyter Notebook, and integrate outputs into BI solutions.
• Analyze franchise revenue trends, optimize profitability, and measure franchisee success metrics.
• Collaborate with cross-functional teams to gather requirements and ensure BI solutions align with strategic goals.
• Enhance data models and queries for maximum efficiency, scalability, and performance.
• Provide guidance and training to stakeholders on BI tools and data interpretation to foster a data-driven culture.
• Utilize Power Query, pivot tables, complex formulas, and automation to build dynamic financial models and dashboards.
• Own the data pipeline end to end - design and manage SQL databases, use Git and GitHub for version control and disciplined promotion of changes across development and production environments, and build and schedule orchestrated data workflows using Apache Hop or Microsoft Fabric.
• Prepare comprehensive Item 19 Earnings Claims reports to support franchise disclosure compliance.

Skills

Power BI

Python Analytics

Financial Analysis

Stakeholder Collaboration

Performance Optimization

Tools

Power BI

DAX

Data Modeling

RLS

Power BI Apps

Python

Jupyter Notebook

SQL

Git

GitHub

Apache Hop

Microsoft Fabric

Job description

In this role, you'll work at the intersection of data, technology, and business strategy - designing powerful BI solutions that uncover trends, highlight opportunities, and measure performance across our diverse portfolio of global brands. Your work will directly support revenue growth, operational efficiency, and franchisee success, helping us shape the future of our business through a truly data-driven approach.

Essential Duties & Responsibilities:

• Power BI Expertise: Design, develop, and maintain dynamic BI dashboards leveraging advanced DAX, data modeling, RLS, Power BI Apps and sophisticated algorithms to deliver insights for all UFG brands and departments.
• Data Integration & Python Analytics: Extract data via APIs, perform data transformation in Python using Jupyter Notebook, and integrate outputs into BI solutions.
• Financial & Operational Analysis: Analyze franchise revenue trends, optimize profitability, and measure franchisee success metrics.
• Business Partnership: Collaborate with cross-functional teams to gather requirements and ensure BI solutions align with strategic goals.
• Performance Optimization: Enhance data models and queries for maximum efficiency, scalability, and performance.
• Training & Support: Provide guidance and training to stakeholders on BI tools and data interpretation to foster a data-driven culture.
• Advanced Excel Reporting: Utilize Power Query, pivot tables, complex formulas, and automation to build dynamic financial models and dashboards.
• Modern Data Architecture: Own the data pipeline end to end - design and manage SQL databases, use Git and GitHub for version control and disciplined promotion of changes across development and production environments, and build and schedule orchestrated data workflows using Apache Hop or Microsoft Fabric.
• Compliance & Reporting: Prepare comprehensive Item 19 Earnings Claims reports to support franchise disclosure compliance.