Director of Business Intelligence

Position Summary

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.

Key Responsibilities

 

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.

Key Competencies

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.

Mentorship & Development

Invests in the growth of junior team members by sharing knowledge, modeling best practices, and building analytical capability across the team.

 

Qualifications

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

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.

Department Business Operations

Required Experience: 2-5 years of relevant experience

Required Travel: Up to 25%

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

HUB International Limited is an equal opportunity employer that does not discriminate on the basis of race/ethnicity, national origin, religion, age, color, sex, sexual orientation, gender identity, disability or veteran's status, or any other characteristic protected by local, state or federal laws, rules or regulations.

E-Verify Program

We endeavor to make this website accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact the recruiting team [email protected]. This contact information is for accommodation requests only; do not use this contact information to inquire about the status of applications.