Sales Data Analyst - Senior
Embrace Pet Insurance · Ohio, United States · 1 mo ago
HybridInformation TechnologyFull-time
Position Overview
As a Business Intelligence Analyst, you’ll play a critical role in transforming data into actionable insights that drive strategic decisions across the organization. You’ll work closely with stakeholders to understand business needs, develop robust reporting solutions, and ensure data integrity across multiple sources—primarily using Power BI and SQL.
Key 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 key performance indicators (KPIs) and develop alerts or visualizations 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, technologies, and best practices to continuously improve analytics maturity
Qualifications
- Bachelor’s degree in Mathematics, Statistics, Engineering, Operations Research, or a related analytical field
- 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, conceptual thinking, and problem-solving skills
- Ability to communicate complex data insights clearly and effectively
- Self-starter with strong organizational and time management skills
- Passion for data-driven decision-making and continuous improvement
- Proven ability to work with cross-functional teams to deliver data-driven solutions that support shared business goals
Why Join Embrace?
- Award-winning workplace culture
- Emphasis on work-life balance and professional development
- Opportunities to make a real impact with data
- Collaborative, pet-loving team environment
- All of our jobs come with great benefits including healthcare, parental leave and opportunities for career advancements
- Comprehensive full medical, dental and vision Insurance
- Basic Life Insurance at no cost to the employee
- Company paid short-term and long-term disability
- 12 weeks of 100% paid Parental Leave
- Health Savings Account (HSA)
- Flexible Spending Accounts (FSA)
- Retail savings plan
- Personal Paid Time Off
- Paid holidays and company-wide Wellness Day off
- Paid time off to volunteer at nonprofit organizations
- Pet friendly office environment
- Commuter Benefits
- Group Pet Insurance
- On the job training and skills development
- Employee Assistance Program (EAP)