BI Data Analyst

Safety National; Maryland Heights (MO); Hybrid; USD 67,000 - 86,000; Full time

Job summary

Safety National in Saint Louis is seeking a Business Intelligence Data Analyst in the BI & Planning department. You will transform data into insights, partner with stakeholders, and build reports and dashboards using Power BI and SSRS.

You will query across systems with SQL, validate data, and help refine reporting processes. The role supports a culture of data excellence in a growing company with flexible hybrid work options.

Qualifications

• 1+ years of experience in reporting, data analysis, or analytics in a business environment
• Ability to read, write, and modify moderately complex SQL queries
• Experience using Power BI or SSRS / Visual Studio for reporting and visualization
• Strong knowledge of data structures and table joins

Responsibilities

• Transform data into meaningful insights to drive business decisions
• Collaborate with business partners to define reporting needs and translate them into technical solutions
• Build and maintain reports and dashboards using Power BI and SSRS
• Support data validation and refine reporting processes

Skills

SQL

Excel

Power BI

SSRS

Education

Bachelor's degree in data analytics, information systems, computer science, or a related field

Tools

Snowflake

Visual Studio

Job description

At Safety National, we don't just offer jobs - we build careers with purpose! Since 1942, we've been an industry leader, valuing integrity, teamwork, and stability while providing competitive rewards, top-tier benefits, career growth opportunities, and flexible work options that promote balance. With tuition reimbursement, wellness perks, and a strong community impact, we invest in your success-both personally and professionally.

This opportunity is in the Business Intelligence & Planning department.

The Business Intelligence & Planning Department is dedicated to empowering informed decision-making and driving strategic growth through comprehensive financial planning, data-driven insights, and governance excellence. Our mission is to deliver accurate, timely, and actionable intelligence to all stakeholders around the company by leveraging the strengths of our integrated teams, including Planning & Reserving, Portfolio Management, BI Analysis, BI Data Analysis, Data Quality and Data Governance. Together, we support a culture of data excellence and financial foresight.

Role Description

As a Business Intelligence Data Analyst, you will play a key role in transforming data into meaningful insights that drive business decisions across the organization. You will work closely with business partners to understand reporting needs and translate them into technical solutions, building and maintaining reports and dashboards using tools like Power BI and SSRS.

In this role, you will leverage your SQL expertise to query and manage data across multiple systems, ensuring accuracy and consistency in reporting outputs. You will also support data validation, assist in refining reporting processes, and contribute to documentation that enhances transparency and usability.

This is an excellent opportunity for someone who enjoys working with data, solving business problems, and collaborating with stakeholders to deliver impactful analytics solutions in a dynamic and growing environment.

Qualifications

Education

Bachelor's degree in data analytics, information systems, computer science, or a related field is preferred

Required Qualifications

• 1 or more years of experience in reporting, data analysis, or analytics within a business environment
• Prior experience interpreting business requirements and translating to technical requirements
• Ability to read, write, and modify moderately complex SQL queries
• Prior experience managing data tables and strong knowledge of common data structures and table joins
• Intermediate Microsoft Excel skills including proficiency in vlookups, pivot tables, conditional formatting, and writing moderately complex formulas
• Prior hands‑on experience providing reporting and/or data visualization using Power BI or SSRS / Visual Studio
• Must be presently authorized to work in the U.S. without a requirement for work authorization sponsorship by our company for this position now or in the future
• This position allows for a hybrid work schedule which includes a minimum of 3 days per week in our St. Louis Corporate Office, located at 1832 Schuetz Rd. Saint Louis, MO. All employees are required to submit work from home requests and follow our Work From Home policy, which will be provided to all candidates selected to interview.

Preferred Qualifications

• Bachelor's degree in data analytics, information systems, computer science, or a related field
• Prior experience with Snowflake data cloud
• Exposure to data warehousing concepts or working with large, complex datasets

Protect the confidentiality, integrity and availability of information and technology assets against unauthorized disclosure, destruction and/or alteration, in accordance with Safety National policies, standards, and procedures.

Safety National is a leading specialty insurance and reinsurance provider. Our culture is built upon relationships, which allow us to demonstrate our expertise gained through our rich 80-year history. As a wholly‑owned subsidiary of Tokio Marine, Inc., we appreciate the benefits and support provided by our affiliation with one of the top 10 insurance companies in the world.

Total Rewards That Put Employees First

In our vision to be First with Co‑Workers, compensation that includes base salary, holiday bonus, and incentive awards is only a small portion of the comprehensive total rewards package we offer. Our total rewards approach recognizes and rewards the time, talents, efforts, and results of our valued employees. Highlights of our exceptional benefits include generous health, dental, and vision coverage, health savings accounts, a 401(k)-retirement savings match and an annual profit sharing contribution. We proudly offer family forming benefits for adoption, fertility, and surrogacy, generous paid time off and paid holidays, paid parental and caregiver leave, a hybrid work environment, and company‑paid life insurance and disability. To support employees in their career journeys, we provide professional growth and development opportunities in addition to employee recognition and well‑being programs.

Safety National is committed to fair, transparent pay and we strive to provide competitive, market‑based compensation. In our vision to be First with Co‑Workers, compensation is only one piece of the comprehensive total rewards package we offer. The target base salary range for this position is $66,500 to $86,000. Compensation for the successful candidate will consider the candidate's particular combination of knowledge, skills, competencies, experience and geographic location.

Equal Opportunity Employer

This employer is required to notify all applicants of their rights pursuant to federal employment laws.

For further information, please review the Know Your Rights notice from the Department of Labor.