
Data & Analytics Solutions Consultant
EPIC Insurance Brokers & Consultants · San Ramon, CA
- On site
- Full-time
- $175,000 / year
- San Ramon, CA
Job highlights
- Design and deploy analytics applications.
- Build broker-facing UIs and dashboards.
- Operationalize actuarial and statistical models.
- Develop and maintain data pipelines.
- Collaborate with data engineering and BAs.
About the role
About EPIC Insurance Brokers & Consultants
There are many reasons why EPIC Insurance Brokers & Consultants has become one of the fastest-growing firms in the insurance industry. Fueled and driven by capable, committed people who share common beliefs and values and “bring it” every day, EPIC is always looking for people who have “the right stuff” – people who know what they want and aren’t afraid to make it happen. Headquartered in New York City and founded in 2007, our company has over 3,000 employees nationwide. With locations spread out across the U.S., our local market knowledge and industry expertise helps support our clients' regional and global needs. We have grown very quickly since our founding, and we continue to see growth and success thanks to our hard-working and growth-minded employees. Our core values are: Owner mindset, Inspire trust, Think big, and Drive results. If these values and growth align with what you're looking for in your next career? Then consider joining our amazing team!
Analytics Technology Solutions Lead — Commercial Insurance
A unique opportunity to join specialization-driven, client-focused commercial insurance brokerage to develop and deploy analytics applications of the future!
JOB OVERVIEW
We are looking for an Analytics Technology Solutions Lead (Data & Analytics Solutions Consultant) who builds things that influence insurance deal cycles. This is not a mere data engineering or infrastructure role. You will design, build, and deploy production-grade analytics applications that support placement decisions, benchmark limits and pricing, and give clients a clearer view of their risk across Commercial Lines and Employee Benefits. Your work spans the full delivery cycle: translating broker and BA requirements into technical specifications, architecting data pipelines, building Python Dash applications and maintaining the critical data & analytics infrastructure. By operationalizing intelligent dashboards and actuarial models, you create best self-service experience and provide client-ready deliverables accelerating operational efficiency and increasing sales velocity for the enterprise. If you are a hands-on builder with creative imagination, comfortable leveraging modern development tools including AI-assisted coding environments to produce production grade codes, love troubleshooting and solving problems, and understand actuarial intricacies of the business, you will thrive in this role!
LOCATION
Hybrid - at least 3 days a week in one of our EPIC offices, preferably San Ramon CA but open to any of our office locations (for a full list, visit: https://www.epicbrokers.com/about/locations/)
WHAT YOU’LL DO:
- Design and lead full-stack development of analytics applications using Python, Dash, and Fast API hosted on Databricks and Azure from architecture through production.
- Build broker-facing UIs that are intuitive and produce client-ready deliverables with limited analyst intervention.
- Operationalize statistical and actuarial models for loss trend analysis, frequency-severity decomposition, and program pricing validation in collaboration with actuaries, data scientists, and claims analysts.
- Develop and maintain data pipelines and adapters that ingest, normalize, and quality-check data from clients, carriers and third-party sources.
- Apply CI/CD practices across both pipeline and application deployments and maintain governance and auditability standards appropriate for client-facing work.
- Collaborate with data engineering partners on scalable architecture that supports growing benchmarking and modeling workloads.
- Partner with Business Analysts to translate brokerage workflows into application requirements and data architecture decisions.
- Engage directly with brokers and client executives to understand value of analytics in deal cycles and develop modular architecture for variety of solutions.
- Working with change management leads, create adoption plans, training materials, and feedback mechanisms for every tool shipped.
WHAT YOU’LL BRING:
Core Skills:
- Python/Dash: Expert-level proficiency for application development, data pipelines, statistical modeling, API development, and application logic — this is your primary tool
- Database: Deep SQL expertise with relational and columnar environments; comfort with large underwriting, loss and related data domains.
- Actuarial & Data Science: Working knowledge of building, evaluating, and deploying actuarial analysis and models.
- APIs and more: Continuous experience with web frameworks (Fast API, Flask, JavaScript, React). You build working applications, not just notebooks.
- Cloud: Hands-on experience with Databricks, Azure, or equivalent cloud data platforms for deploying and managing CI/CD pipelines.
Work Experience and Education:
- 7+ years in the insurance industry (or equivalent experience in a data-intensive financial services environment) in either combination of brokerage, carrier, or consulting with strong focus on delivering data & analytics solutions in a process driven environment.
- Bachelor’s degree in computer science or any quantitative engineering, Master's degree is preferred.
Domain Expertise:
- Working knowledge of commercial lines insurance brokerage workflows and actuarial concepts: underwriting applications, submissions, program towers, loss runs, exposure schedules, coverage terms, renewals, RFP cycles, loss development factors, IBNR, frequency-severity, layer pricing etc. or willingness and potential to learn.
- Demonstrated experience working with Business Analysts to convert workflow requirements into application specifications.
- Comfort operating within a change management framework where adoption is part of the solution development and not an afterthought.
- Ability to present technical work to non-technical audiences: brokers, practice leaders, and client risk managers
- Familiarity with ACORD data standards or commercial lines data normalization
COMPENSATION:
The national average salary for this role is $150,000.00 - $200,000.00 in base pay and exclusive of any bonuses or benefits. The base pay offered will be determined based on your experience, skills, training, certifications and education, while also considering internal equity and market data.
WHY EPIC:
EPIC has over 60 offices and 3,000 employees nationwide – and we’re growing! It’s a great time to join the team and be a part of this growth. We offer:
- Generous Paid Time offManaged PTO for salaried/exempt employees (personal time off without accruals or caps); 22 PTO days starting out for hourly/non-exempt employees; 12 company-observed paid holidays; 4 early-close days
- Generous leave time options: Paid parental leave, pregnancy disability and bonding leave, and organ donor/bone marrow donor leave
- Generous employee referral bonus program of $1,500 per hired referral
- Employee recognition programs for demonstrating EPIC’s values plus additional employee recognition awards and programs (and trips!)
- Employee Resource Groups: Women’s Coalition, EPIC Veterans Group
- Professional growth & development: Mentorship Program, Tuition Reimbursement Program, Leadership Development
- Unique benefits such as Pet Insurance, Identity Theft & Fraud Protection Coverage, Legal Planning, Family Planning, and Menopause & Midlife Support
- Additional benefits include (but are not limited to): 401(k) matching, medical insurance, dental insurance, vision insurance, and wellness & employee assistance programs
- 50/50 Work Culture: EPIC fosters a 50/50 culture between producers and the rest of the business, supporting collaboration, teamwork, and an inclusive work environment. It takes both production and service to be EPIC!
- EPIC Gives Back – Some of our charitable efforts include Donation Connection, Employee Assistance Fund, and People First Foundation
- We’re in the top 10 of property/casualty agencies according to “Insurance Journal”
To learn more about EPIC, visit our Careers Page: https://www.epicbrokers.com/about/epic-careers/.
EPIC embraces diversity in all its various forms—whether it be diversity of thought, background, race, religion, gender, skills or experience. We are committed to fostering a work community where every colleague feels welcomed, valued, respected and heard. It is our belief that diversity drives innovation and that creating an environment where every employee feels included and empowered, helps us to deliver the best outcome to our clients. California Applicants - View your privacy rights at: https://www.epicbrokers.com/wp-content/uploads/2025/01/epic-ca-employee-privacy-notice.pdf. Massachusetts G.L.c. 149 section 19B (b) requires the following statement: It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability. (3564)
Key skills/competency
- Data & Analytics Solutions Consultant
- Python
- Dash
- Fast API
- SQL
- Azure
- Databricks
- Actuarial Models
- Commercial Insurance
- Data Pipelines
Skills & topics
- Data Analytics
- Solutions Consultant
- Python
- Dash
- Fast API
- SQL
- Azure
- Databricks
- Actuarial Models
- Commercial Insurance
- Data Pipelines
- Insurance Brokerage
- Analytics Applications
- Full-Stack Development
How to get hired
- Tailor your resume: Highlight Python, Dash, SQL, and insurance domain expertise.
- Showcase your projects: Emphasize full-stack development and production-grade code examples.
- Quantify achievements: Use numbers to demonstrate impact on efficiency and sales.
- Prepare for technical questions: Review actuarial concepts and cloud platform experience.
- Demonstrate business acumen: Articulate how analytics drives deal cycles and client value.
Technical preparation
Behavioral questions
Frequently asked questions
- What is the work arrangement for the Data & Analytics Solutions Consultant role at EPIC?
- This is a hybrid role, requiring at least 3 days per week in one of EPIC's offices. While San Ramon, CA is preferred, other EPIC office locations are open for consideration.
- What are the core technical skills required for the Data & Analytics Solutions Consultant position?
- Key technical skills include expert-level proficiency in Python/Dash for application development, data pipelines, and API development. Strong SQL expertise, experience with web frameworks (FastAPI, Flask, JavaScript, React), and hands-on experience with cloud platforms like Databricks and Azure are also essential.
- Does the Data & Analytics Solutions Consultant role involve actuarial work?
- Yes, the role requires a working knowledge of building, evaluating, and deploying actuarial analysis and models. You will collaborate with actuaries and data scientists to operationalize statistical and actuarial models for various insurance analyses.
- What is the expected experience level for the Data & Analytics Solutions Consultant role?
- The role requires 7+ years of experience in the insurance industry or a similar data-intensive financial services environment, with a strong focus on delivering data and analytics solutions.
- What kind of insurance domain expertise is needed for this role?
- A working knowledge of commercial lines insurance brokerage workflows and actuarial concepts is highly beneficial. This includes understanding underwriting, submissions, loss runs, exposure schedules, coverage terms, renewals, RFP cycles, loss development factors, IBNR, and pricing.
- How does EPIC support professional growth for its employees?
- EPIC offers a Mentorship Program, Tuition Reimbursement Program, and Leadership Development opportunities to support professional growth and development.
- What are some of the unique benefits offered by EPIC Insurance Brokers & Consultants?
- EPIC offers unique benefits such as Pet Insurance, Identity Theft & Fraud Protection Coverage, Legal Planning, Family Planning, and Menopause & Midlife Support, in addition to standard benefits like 401(k) matching and comprehensive health insurance.
- What is the company culture like at EPIC?
- EPIC fosters a collaborative and inclusive work environment with a 50/50 culture between producers and the rest of the business. They value diversity, innovation, and aim to create a community where every colleague feels welcomed, valued, and respected.