General Description:
The Senior Data Analyst is responsible for leading advanced reporting, analytics, and business intelligence initiatives within the Information Technology organization. This role partners closely with executive leadership, business stakeholders, and data engineering teams to deliver high-impact analytical solutions that drive operational performance, strategic decision-making, and enterprise growth.
The Senior Data Analyst designs scalable reporting frameworks, develops enterprise-grade dashboards and paginated reports, and performs advanced data analysis using modern tools and statistical techniques. This position serves as a subject matter expert in SQL Server, Power BI, and data modeling, while mentoring junior analysts and promoting data governance, automation, and analytical best practices.
Essential Duties and Responsibilities:
Enterprise Reporting & Business Intelligence
- Lead development of executive dashboards and operational reporting solutions using Power BI and Power BI Paginated Reports
- Design scalable semantic models (star schema, dimensional modeling) aligned with enterprise data standards
- Deliver daily, weekly, monthly, and ad-hoc reporting with a focus on automation, accuracy, and performance
- Ensure consistency and reconciliation across financial, underwriting, claims, sales, and operational reports
Advanced Data Analysis
- Perform complex data analysis using SQL Server, Python (pandas, NumPy), and statistical techniques
- Identify trends, patterns, anomalies, and business drivers within large datasets
- Translate business questions into structured analytical approaches and actionable insights
- Develop data validation and reconciliation processes to improve trust in enterprise reporting
Data Modeling & Query Optimization
- Write advanced T-SQL queries, views, and stored procedures optimized for performance
- Collaborate with Data Engineering on data models and data product design
- Optimize report performance through indexing strategies, query tuning, and model design improvements
Automation & Process Improvement
- Automate recurring reports and analytical workflows
- Replace manual Excel-based processes with scalable BI solutions
- Implement quality checks and monitoring processes to reduce reporting risk
Strategic Partnership
- Serve as analytical advisor to department leaders and executives
- Participate in requirements gathering sessions and translate business needs into technical deliverables
- Present findings clearly to both technical and non-technical audiences
- Contribute to roadmap discussions for analytics platform modernization
Mentorship & Governance
- Mentor junior analysts on SQL, data modeling, visualization best practices, and documentation standards
- Promote consistent definitions, KPIs, and metadata usage across departments
- Contribute to documentation, wiki content, and data dictionary standards
Additional Responsibilities
- Contribute to project planning and task tracking
- Successfully manage multiple initiatives simultaneously
- Perform other duties as required
Education and/or Experience:
- Bachelor’s degree in Information Systems, Computer Science, Data Analytics, or related discipline required
- 6+ years of progressive experience in data analysis, business intelligence, or analytics roles
- Advanced proficiency in Microsoft SQL Server (T-SQL, stored procedures, query optimization)
- Strong expertise in Power BI (data modeling, DAX, report design, paginated reports)
- Experience designing dimensional data models (fact/dimension tables, star schema)
- Proficiency in Python for data analysis (pandas, NumPy; scikit-learn a plus)
- Experience with Azure-based data environments and modern data platforms preferred
- Strong understanding of data quality validation, reconciliation, and governance practices
- Familiarity with Machine Learning concepts and predictive modeling methodologies preferred
- Experience working in Property & Casualty Insurance a must
- Familiarity with ticketing systems used to assign and track work
- Strong written and oral communication skills