BI Data Analyst

Safety National; St. Louis (MO); Hybrid; USD 67,000 - 86,000; Full time

Benefits offered by this job

Hybrid work environment

Tuition reimbursement

Wellness perks

401(k) matching

Job summary

Safety National is seeking a Business Intelligence Data Analyst to transform data into meaningful insights and support decision-making across the organization. You will collaborate with business partners to translate reporting needs into technical solutions, building reports and dashboards with Power BI and SSRS.

You will leverage SQL to query data across systems, ensure accuracy in outputs, and contribute to data validation and process improvements in a hybrid work environment with in-office

Qualifications

• 1+ years of experience in reporting, data analysis, or analytics within a business environment
• Experience translating business requirements into technical requirements
• Ability to read, write, and modify moderately complex SQL queries
• Experience managing data tables and understanding data structures and joins
• Excel skills including VLOOKUPs, pivot tables, conditional formatting, and moderately complex formulas
• Hands-on reporting and/or data visualization using Power BI or SSRS/Visual Studio
• Authorized to work in the U.S. without sponsorship now or in the future
• Hybrid work schedule with at least 3 days/week in the St. Louis office at 1832 Schuetz Rd, Saint Louis, MO

Responsibilities

• Transform data into insights that drive business decisions
• Collaborate with partners to understand reporting needs and translate into technical solutions
• Build and maintain reports and dashboards using Power BI and SSRS
• Query and manage data across multiple systems with SQL
• Support data validation and refine reporting processes
• Contribute to documentation to enhance transparency and usability

Skills

SQL queries

Data analysis

Power BI

Excel

Data visualization

Education

Bachelor’s degree in data analytics or related field

Tools

Snowflake

SSRS

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.