Director of Business Intelligence

HUB International Limited
Des Plaines, IL, United States
21 days ago
Apply on www.juju.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
2 years minimum
Compensation
$135,000.0 - $155,000.0
Working hours
Regular working hours
Job source

Tech stack

Microsoft Excel Application Programming Interfaces (APIs) Amazon Web Services Data Analysis Analysis of Variance (ANOVA) Microsoft Azure Big Data Information Engineering Data Files Data Infrastructure Data Integrity Extract Transform Load (ETL)
+11 more
Data Visualization Software Debugging Python (Programming Language) Machine Learning Power BI SQL Databases SQL Server Integration Services Data Processing Cloud Platform System Tools for Reporting Data Pipelines

Job description

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., Financial Analysis

  • 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.

Analytics & Data

  • 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.

Leadership & Communication

  • 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.

Requirements

Analytical Thinking

Applies rigorous, logical reasoning to complex data and business problems; extracts meaningful patterns and translates findings into actionable insights.

Financial Acumen

Understands P&L structure, margin mechanics, and budget-to-actual dynamics; builds models and narratives that connect analytical outputs to financial outcomes.

Technical Excellence

Demonstrates proficiency across the analytics toolkit (SQL, Python, Excel, Azure, reporting tools); continuously optimizes queries, models, and pipelines.

Communication & Storytelling

Translates complex data and financial concepts into clear, compelling narratives for both technical and non-technical audiences, including senior leadership.

Results Orientation

Focuses analytical efforts on the highest-impact business questions; delivers work that directly informs decisions and drives measurable outcomes.

Intellectual Curiosity

Maintains a persistent drive to understand VIU’s data sources, business processes, and analytical models; proactively identifies opportunities to improve quality and efficiency., + Experience: 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.

  • Technical Skills - SQL & Python: 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.

  • Data Visualization: Proficiency with data visualization tools (Power BI or equivalent); ability to build and maintain dashboards, troubleshoot issues, and deliver self-service reporting solutions.

  • Financial Modeling: Hands-on experience building financial models, including revenue forecasts, variance analysis, scenario planning, and contribution margin/EBITDA reporting.

  • Data Engineering: 3+ years of experience with data wrangling, transformation, and standardization; experience integrating datasets via API, ETL, SDK, and SSIS in a Microsoft/Azure environment.

  • Excel: Power user with advanced modeling, analysis, and financial reporting capabilities.

  • Communication: Ability to communicate effectively with senior leadership and translate complex technical and financial concepts into actionable business language.

  • Education: Bachelor’s or Master’s degree in a technical, analytical, finance, or business concentration.

Preferred Qualifications

  • 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., Required Experience: 2-5 years of relevant experience

Required Travel: Up to 25%

Required Education: Bachelor’s degree (4-year degree)

Benefits & conditions

The expected base salary range for this position is $135,000 to $155,000 annually. Actual compensation within this range will depend on factors such as the candidate’s experience, qualifications, skills, and geographic location. This role may also be eligible for additional forms of compensation and a comprehensive benefits package.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.juju.com
Prepare application

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:03 min

Career evolution in data engineering and AI platforms

Maria Apazoglou · Coffee With Developers

3:38 min

Reusing email software standards for HTTP file uploads

Imran Nazar · World Congress 2023

3:28 min

Defining big data and machine learning fundamentals

Ayon Roy · LIVE

1:24 min

Moving the semantic layer upstream to avoid vendor lock-in

Piotr Menclewicz Piotr Menclewicz · Europe 2026 Virtual

1:42 min

Combining technical skills with strong business communication

Lukas Kölbl · LIVE

5:21 min

Extracting and preprocessing HTML data into markdown files

Rainer Stropek Rainer Stropek · LIVE

Videos

See all

Related articles

See all