Director of Business Intelligence

HUB International•Des Plaines, IL

2d•$135,000 - $155,000

About The Position

The Director of Business Intelligence is a versatile, senior individual contributor and team leader responsible for turning data into strategic advantage across the organization. This role blends deep analytical capability with financial acumen, structured project management, and executive communication skills. The Director partners directly with senior leadership to develop financial models, track performance against plan, and drive cross-functional initiatives. While a strong technical foundation in data and reporting is essential, the ideal candidate operates with equal fluency in operational settings and the data environment — connecting analytical outputs to business outcomes and organizational priorities.

Requirements

5+ years of experience in analytics, financial analysis, or a related business intelligence role, with demonstrated ability to work across both data and financial domains.
5+ years of experience with SQL and Python, including translating complex analyses into code and visualizations; ability to build, debug, tune, and automate complex queries.
Proficiency with data visualization tools (Power BI or equivalent); ability to build and maintain dashboards, troubleshoot issues, and deliver self-service reporting solutions.
Hands-on experience building financial models, including revenue forecasts, variance analysis, scenario planning, and contribution margin/EBITDA reporting.
3+ years of experience with data wrangling, transformation, and standardization; experience integrating datasets via API, ETL, SDK, and SSIS in a Microsoft/Azure environment.
Power user with advanced modeling, analysis, and financial reporting capabilities in Excel.
Ability to communicate effectively with senior leadership and translate complex technical and financial concepts into actionable business language.
Bachelor's or Master's degree in a technical, analytical, finance, or business concentration.
2-5 years of relevant experience (Department: Business Operations)
Bachelor's degree (4-year degree)

Nice To Haves

Experience in the insurance, financial services, or financial technology industry.
Familiarity with cloud-based data platforms beyond Azure (e.g., AWS, GCP).
Experience with advanced statistical modeling, predictive analytics, or machine learning techniques.
Track record of building scalable, automated reporting solutions that reduce manual effort and improve data accessibility.
Prior experience supporting executive or board-level financial reporting, including preparation of performance decks, budget reviews, or investor materials.

Responsibilities

Develop and maintain financial models supporting revenue forecasting, margin analysis, budget-to-actual variance tracking, and scenario planning.
Translate financial data into clear executive narratives — including P&L summaries, channel-level performance analysis, and KPI dashboards — for senior leadership review.
Partner with Finance and Operations to ensure analytical outputs align with company P&L structure, cost allocation methodologies, and reporting cadences.
Support EBITDA and contribution margin analysis, identifying levers for improvement and quantifying the impact of business decisions.
Prepare ad hoc financial analyses and investment cases to support strategic planning, vendor negotiations, and new business initiatives.
Mine large datasets to identify patterns, solve complex business problems, and extract actionable insights that inform strategic and operational decisions.
Analyze and model diverse data sets to uncover trends, forecast outcomes, and support data-driven decision-making across the organization.
Own end-to-end data integrity — including wrangling, transforming, standardizing, extracting, staging, cleansing, and enriching data — within a Microsoft/Azure environment.
Build and maintain SQL queries and automate processes; manage complex schema and table joins to ensure reliable, performant data pipelines.
Integrate data sets via API, ETL, SDK, and SSIS to create a unified, trustworthy data foundation.
Develop and automate reporting solutions that provide stakeholders with timely, self-service access to key business metrics.
Build and maintain dashboards and visualizations (Power BI and other tools) to support operational and executive reporting needs.
Communicate effectively with senior leadership, translating technical findings and financial analyses into business-relevant recommendations and executive-ready materials.
Collaborate cross-functionally to understand business requirements and ensure the outputs align with organizational priorities.
Maintain a continuous improvement mindset — identify and prioritize opportunities to streamline reporting processes, reduce manual effort, and scale analytical capabilities.
Facilitate structured workstreams across business and technical stakeholders, ensuring alignment and accountability throughout the project lifecycle.