BI Data Analyst — Growth, Insights & Dashboards

Doist; 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

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