FNIC Trusted insurance advisors · 1 day ago
Data Analyst
FNIC Trusted Insurance Advisors is seeking a highly skilled and collaborative Data Analyst who is passionate about transforming data into meaningful insights. In this role, you will work closely with business stakeholders to gather requirements and create actionable reporting and dashboards, leveraging your analytical expertise and SQL skills.
Auto InsuranceCommercial InsuranceConsultingProperty InsuranceRisk Management
Responsibilities
Partner with business stakeholders to gather, clarify, and document reporting and dashboard requirements
Design, build, and maintain insightful reports and dashboards using PowerBI
Perform ad-hoc analysis to support reporting needs, answer data questions, and assist data engineering initiatives
Write and maintain advanced SQL queries in BigQuery to analyze and validate complex datasets
Collaborate closely with the Senior Data Engineer to validate data models, pipelines, and engineering logic
Review, test, and, when necessary, contribute to data engineering code using Python, dbt, and Airflow (Cloud Composer)
Participate in monitoring, UAT, troubleshooting, and support for data pipelines, reports, and dashboards
Develop and maintain both technical and user-facing documentation
Train colleagues on effective use of dashboards, reporting tools, and advanced reporting capabilities in Microsoft Excel
Work within an agile environment alongside product owners and data teammates to deliver iterative improvements
Provide proactive, customer-focused support for internally developed data products and solutions
Qualification
Required
Bachelor's degree in Data Analytics, Data Science, Statistics, Computer Science, or a related field
3+ years of experience building reports and dashboards, with a strong preference for candidates with 5+ years of experience
Expert-level SQL skills, with proven experience working with large and complex datasets
Strong experience with PowerBI, including dashboard design and data modeling
Demonstrated ability to work directly with non-technical stakeholders and translate business needs into analytical solutions
Working knowledge of Python and familiarity with modern data tooling such as dbt, Airflow (Cloud Composer), and Azure DevOps
Ability to review, validate, and contribute to data engineering code
Strong communication, documentation, and collaboration skills
Comfortable working in agile, iterative development environments
Curious, motivated, independent, and customer-oriented mindset
Legal authorization to work in the United States without the need for employer sponsorship, now or in the future
Preferred
Experience or exposure to the Insurance industry
Familiarity with enterprise analytics, reporting governance, or data quality best practices
Benefits
Health, dental, and vision insurance
HSA with employer contributions
401(k) match
Employer-paid disability coverage
Life insurance
Tuition reimbursement
Training opportunities
Virtual fitness classes
In-office gym access