Senior Business Intelligence Analyst

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

Job summary

Falcon Insurance Group LLC in Oak Brook, IL, seeks a Senior Business Intelligence Analyst to lead enterprise reporting, data governance, and analytics strategy. You will design and guide Power BI solutions, partner with stakeholders, and own the data model to enable data-driven decision-making across the organization.

The ideal candidate has a bachelor’s degree and 5+ years of Power BI data-analytics experience, strong SQL skills, data modeling, and excellent communication to translate complex

Qualifications

• 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 KPI development.
• Strong proficiency in SQL and relational database concepts; experience designing data models.
• Analytical, problem-solving, and critical-thinking skills with the ability to translate data into insights.
• Excellent communication and presentation skills; able to explain technical concepts to non-technical audiences.
• Knowledge of property and casualty insurance operations and data.

Responsibilities

• Design, develop, maintain, and support enterprise reporting and analytics solutions using Power BI.
• Collaborate with IT, Accounting, Underwriting, Claims, Operations, and leadership to define requirements.
• Design and optimize semantic models, datasets, data marts, and KPIs for reporting.
• Maintain data quality, metadata, and governance practices across reports.
• Identify opportunities to automate reporting and improve efficiency through data-driven solutions.
• Support strategic initiatives and ad hoc analyses as requested by leadership.

Skills

SQL

Data modeling

Analytical thinking

Communication

Stakeholder management

Problem solving

Insurance domain knowledge

Education

Bachelor’s degree in Information Systems, Data Analytics, Business, Computer Science, Statistics, or a related field

Tools

Power BI

Job description

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!

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.