Senior Business Intelligence Analyst

Falcon Insurance Group; Oak Brook (IL); On-site; USD 130,000 - 150,000; Full time

Job summary

Falcon Insurance Group is seeking a Senior Business Intelligence Analyst in Oak Brook, IL to lead enterprise reporting and data analytics initiatives. The role partners with business stakeholders to transform insurance data into actionable insights and promotes data-informed decision making across the organization.

The position focuses on designing semantic models, expanding the data model, and governing reporting standards while supporting strategic initiatives and ad hoc analyses for

Qualifications

• Bachelor’s degree in a related field.
• 5+ years of experience developing reports and dashboards using Power BI.
• Strong proficiency in SQL and relational database concepts.
• Analytical, problem-solving, and critical-thinking skills.
• Excellent communication and presentation skills.
• Strong knowledge of property and casualty insurance operations.

Responsibilities

• Design, develop, maintain, and support enterprise reporting and analytics solutions using Power BI.
• Partner with stakeholders across IT, Accounting, Underwriting, Claims, Operations, and Leadership.
• Design and optimize semantic models, datasets, data marts, and data validation processes.
• Ensure data accuracy and governance with metadata, standards, and data dictionaries.
• Identify opportunities to automate reporting processes and improve efficiency.
• Support strategic initiatives and ad hoc analysis as requested.

Skills

Analytical thinking

Communication

Stakeholder management

Problem solving

Education

Bachelor’s degree

Tools

Power BI

SQL

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Senior Business Intelligence Analyst

Full Time Professional Oak Brook, IL, US

6 days ago Requisition ID: 1009

Salary Range: $130,000.00 To $150,000.00 Annually

About Falcon

At Falcon Insurance Group, we prioritize meaningful careers! Falcon is a property and casualty insurance Company specializing in non‑ standard automobile insurance and related products and services. Falcon is a growing Company who currently write in Texas, Illinois, Oklahoma, Indiana, Arizona, Utah, and Colorado with high expansion expectations. Falcon is led by a strong management team with over 75 years of non‑standard automobile insurance experience.

What’s in it for you?

We offer competitive benefits, 401(k) match, flexible schedule, referral bonus, paid time‑off (PTO), and pay with potential for an annual financial bonus based on both individual and Company performance. Our employees have the opportunity to participate in volunteer events, Company outings, summer happy hours, and holiday events! We offer programs to assist with paid training and licensing, professional learning development, wellness incentives, and so much more!

At Falcon, it’s not the Company that makes the people; it’s the people that make the Company. Visit our Careers page for more information on our benefits, locations and to learn how to join our growing team!

Job Summary

The Senior Business Intelligence Analyst serves as the organization’s lead business intelligence and analytics professional, responsible for the design, development, and governance of enterprise reporting and data analytics solutions. This role partners with business stakeholders to transform complex business and insurance data into actionable insights that support strategic decision‑making, operational excellence, and business growth. The position owns and advances the organization’s enterprise data model and reporting strategy while promoting consistent, data‑informed decision‑making across the organization.

Responsibilities:

• Design, develop, maintain, and support enterprise reporting and analytics solutions using Microsoft Power BI, including executive dashboards, operational scorecards, KPIs, and self‑service reporting.
• Partner with business stakeholders across Information Technology, Accounting, Underwriting, Claims, Operations, and Executive Leadership to identify reporting needs, define requirements, and deliver meaningful analytical solutions.
• Design and optimize semantic models, datasets, data marts, reporting structures, advanced SQL queries, stored procedures, and data‑validation processes to support efficient, accurate analysis and reporting.
• Ensure data accuracy and integrity while establishing and maintaining data‑quality controls, metadata management practices, reporting standards, business definitions, data dictionaries, KPI calculations, and broader data‑governance practices.
• Identify opportunities to automate manual reporting processes and improve organizational efficiency through data‑driven solutions.
• Support strategic initiatives, special projects, and ad hoc analysis as requested by leadership.

Qualifications & Knowledge, Skills and Abilities:

• Bachelor’s degree in Information Systems, Data Analytics, Business, Computer Science, Statistics, or a related field.
• 5+ years of experience developing reports and dashboards using Microsoft Power BI, with expert knowledge of business intelligence, reporting best practices, data visualization, dashboard design, and KPI development.
• Strong proficiency in SQL and relational database concepts, with experience designing and supporting data models for reporting and analytics.
• Strong analytical, problem‑solving, and critical‑thinking skills, with the ability to interpret complex data, gather business requirements, and translate findings into actionable technical solutions.
• Excellent communication and presentation skills, with the ability to explain technical concepts to non‑technical audiences, build relationships across organizational levels, influence stakeholders, and drive adoption of business intelligence solutions.
• Strong knowledge of property and casualty insurance operations and data, combined with strong project management and organizational skills, attention to detail and data accuracy, and the ability to manage multiple priorities independently with minimal supervision.