Senior BI Data Analyst

Role Overview

• Understand complex data structures and underlying relationships across multiple data sources
• Build and maintain SQL data models, views, and relationships to support reporting and analytics
• Identify opportunities to improve data sourcing, transformation, and delivery using internal tools and platforms
• Develop user-friendly, scalable Power BI dashboards with clear storylines and drill-down capabilities
• Create and manage automated reporting and data delivery routines based on agreed timelines and communication methods
• Build quick, stand-alone analytical solutions and prototypes, and translate them into scalable BI assets aligned with BI strategy
• Improve raw data usability by partnering with reporting teams and tool owners
• Apply statistical and exploratory data analysis techniques to identify trends, anomalies, gaps, and opportunities
• Conduct root cause analysis on identified anomalies and collaborate with stakeholders to assign ownership and track resolution
• Independently review dashboards and data outputs, challenge inconsistencies, and recommend cost-effective improvements
• Provide consultative analytics support to business stakeholders throughout the decision-making process
• Ensure accuracy, integrity, and compliance of all reported data and technical solutions
• Test and validate dashboards and analytical solutions to ensure expected functionality
• Support data compliance initiatives and documentation efforts
• Create and maintain documentation for data infrastructure, dashboards, reports, and change logs
• Collaborate across Operations and other business teams to understand data needs and share best practices
• Support ad-hoc analytics, reporting, and special projects as required

Requirements

• 3-5 years relevant experience
• Experience in data collection, cleansing, and transformation, including complex SQL queries and relational databases
• Hands-on experience with exploratory data analysis to uncover trends, patterns, and outliers
• Advanced data visualization skills with Microsoft Power BI (preferred), Tableau, or comparable programs
• Programming experience in Python, R, and Excel (including macros) with familiarity in commonly used data science libraries
• Working knowledge of ETL tools such as KNIME or Alteryx is a plus
• Excellent verbal and written communication skills, with the ability to present complex data clearly to non-technical and senior audiences
• Demonstrated ability to analyze large, complex datasets and proactively recommend solutions
• Proficiency in Power BI, SQL, Excel, and the broader Microsoft Office Suite
• Strong organizational skills with the ability to independently manage multiple priorities
• Results-oriented mindset with strong collaboration and business-partner focus
• Ability to navigate and influence within a highly matrixed organization

Tech Stack

• ETL
• Python
• SQL
• Tableau

Benefits

• Comprehensive, multi-carrier program for medical, dental and vision benefits
• 401(k) with match and an Employee Share Purchase Plan
• Wellness platform with incentives, Headspace app subscription, Employee Assistance and Time-off Programs
• Short-and-Long Term Disability, Life and Accidental Death Insurance, Critical Illness, and Hospital Indemnity
• Family Benefits, including bonding and family care leaves, adoption and surrogacy benefits
• Health Savings, Health Care, Dependent Care and Commuter Spending Accounts
• Up to two days of paid leave each to participate in Employee Resource Groups and to volunteer with your charity of choice