Senior Business Intelligence & Data Insights Analyst

Embrace Pet Insurance; Ohio; On-site; USD 91,000 - 114,000; Full time

Benefits offered by this job

Health insurance

Life Insurance

Disability insurance

Parental Leave

Health Savings Account (HSA)

Flexible Spending Accounts (FSA)

Retirement savings plan

Paid Time Off

Paid holidays and Wellness Day off

Volunteer time off

Pet friendly office environment

Commuter Benefits

Group Pet Insurance

On-the-job training and skills dev.

Employee Assistance Program (EAP)

Job summary

Embrace Pet Insurance is seeking a Business Intelligence Analyst to transform data into actionable insights. You will partner with stakeholders across the business to build robust reporting solutions and ensure data integrity, primarily using Power BI and SQL.

You will design dashboards, optimize SQL queries, and automate reporting workflows, enabling strategic decisions and scalable operations. This role offers a collaborative, pet-friendly environment with strong growth opportunities.

Qualifications

• 5+ years of experience with SQL (SQL Server Management Studio preferred).
• 5+ years of experience with Power BI or Tableau.
• Strong understanding of data warehousing and data wrangling techniques.
• Excellent analytical and problem-solving skills.
• Ability to communicate complex data insights clearly.

Responsibilities

• Collaborate with stakeholders to understand business needs and translate them into data-driven solutions.
• Design, develop, and maintain interactive dashboards and reports using Power BI (or similar tools).
• Write and optimize SQL queries to extract, transform, and analyze data from multiple sources.
• Perform ad-hoc analyses to support strategic decision-making and operational improvements.
• Ensure data accuracy and integrity through validation, cleansing, and reconciliation processes.
• Automate data collection and reporting workflows to improve efficiency and scalability.
• Identify trends, patterns, and insights that inform business strategy and performance.
• Monitor KPIs and develop alerts or visualisations to track them.
• Document data definitions, processes, and reporting standards for consistency and transparency.
• Partner with data engineering and IT teams to enhance data infrastructure and reporting capabilities.
• Stay current with BI tools and best practices to advance analytics maturity.

Skills

SQL

Power BI

Data warehousing

Data wrangling

Analytical thinking

Cross-functional collaboration

Communication

Education

Bachelor’s degree in Mathematics or related analytics field

Tools

Power BI

Tableau

Job description

Embrace Pet Insurance is seeking a Business Intelligence Analyst to transform data into actionable insights. You will partner with stakeholders across the business to build robust reporting solutions and ensure data integrity, primarily using Power BI and SQL.

You will design dashboards, optimize SQL queries, and automate reporting workflows, enabling strategic decisions and scalable operations. This role offers a collaborative, pet-friendly environment with strong growth opportunities.