Senior Data Analyst

Orlando, FL - USA

Monthly Salary: Not Disclosed

Posted on: 13 hours ago

Vacancies: 1 Vacancy

Job Summary

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:

Bachelors 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 preferred
Familiarity with ticketing systems used to assign and track work
Strong written and oral communication skills

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 deliv...