Remote Data Analyst Sql Excel Jobs in Bothell, WA

Who We Are:

At PEMCO we're all about people - our customers, our employees, and the community.  We're a mutual insurance company owned by our Northwest policyholders.  We provide auto, home, renters, and boat coverage. Recognized by Forbes as one of America's Best Insurance Companies in both Auto and Home for 2025 based on customer survey feedback and by Newsweek as one of America's Greatest Midsize Workplaces 2025. We are consistently recognized for our outstanding customer service, employee expertise, community partnerships, and social impact programs. All of which makes PEMCO a great place to work!

Our social impact programs motivate high achievement by youth in education; build stronger and greener communities; and increase safety at home, on the road, and at play. We're committed to diversity, equity, inclusion, and belonging, and to fostering an inspiring and inclusive workplace. These efforts create and cultivate an environment that builds fairness and understanding, encourages collaboration and flexibility, and celebrates all the ways in which we're different and the same - enabling all individuals to achieve their full potential.

Why We Need You:

PEMCO has a dynamic and challenging opportunity for a Senior Product Analyst to join our community. In this role, you will be responsible for conducting complex quantitative analysis of property & casualty products to improve product performance and support PEMCO's and Product's initiatives.

What You'll Be Doing:

• Plan and manage large-scale, complex projects with support.
• Document complex system workflows and business processes.
• Develop and implement analytical strategies as a partner to our Product Managers and Actuarial team.
• Create queries, dashboards, and tools for analyzing and tracking product success; identify enhancements and efficiency gains in data strategy and warehousing; consult on data fields, calculations, and methodology.
• Compile and submit materials for rate filings.
• Communicate analysis with business stakeholders to understand its value.
• Build tools and processes to create efficiencies, especially in analyzing metrics.
• Assist less experienced analysts as needed or assigned.
• Assist in product and rating reviews, including making pricing recommendations.
• Perform complex analysis to evaluate the performance of and identify trends and issues for our products and make actionable recommendations for improvements.
• Demonstrate behaviors consistent with PEMCO's policies, values, code of ethics and business conduct.
• Authentically support the PEMCO Brand and constantly are on the lookout for top talent to join us to achieve our Mission to Worry Less and Live More.
• Other duties as assigned.

What You'll Bring:

• B.A. or B.S. degree or equivalent work experience (economics, business, information technology, mathematics, or equivalent quantitative field of study) is required.
• Graduate or other professional degree or equivalent work experience is preferred.
• 3 years of experience in the property and casualty insurance industry is required.
• 6+ years of experience in analytical roles with increasing scale, scope and complexity involving pricing insurance products or similar work including experience in integrating, managing, and manipulating large data files from various corporate systems and external sources is required.
• Proficiency in Power BI, Tableau, and WTW Radar is preferred.
• Problem Solver: Ability to analyze, diagnose and resolve complex unstructured problems quickly, efficiently, and collaboratively is required.
• Presenter: Organizes data visually and speaks clearly and persuasively in group presentations and meetings with multiple peer groups and senior management is required
• Precision: Is detail orientated and has a strong desire for accuracy and thoroughness is required
• Organized: Has excellent time management skills and easily manages multiple tasks, activities, and projects is required
• MS Office: Skilled proficiency in Excel, Word, PowerPoint, Outlook is required.
• Proficiency in SQL, SQL Server, and data visualization is required.
• Ability to demonstrate high level of skill in quantitative modeling, knowledge of data structures and ability to write complex SQL queries is required.
• Independent: Is highly self-motivated and self-directed. The ability to work with limited direction and communicate relevant information to the appropriate levels during times of uncertainty is required.
• Highly Analytical: Is passionate about working with disparate datasets bringing data together to answer business questions. Collaborates to create, manage, and translate data to meaningful insights. Can work with external vendors to integrate data for analysis; knows how to build efficient and scalable infrastructure and data models is required.
• Compliance: Knowledge and understanding of relevant laws, rules, and regulations is required
• Communicator: The ability to communicate clearly and informatively, verbally and in writing, with colleagues, customers, and the community in both technical and non-technical professional language is required
• Analytical and data-driven: Thinks analytically; a structured thinker who can put complex ideas into clear frameworks; uses data to conduct root cause analysis and develops high quality, consumable, and consistent metrics that drive strategic objectives and priorities is required.

What We Value:

In fostering a culture where everyone thrives, PEMCO embodies a set of core traits that guide our collective efforts. These traits include:

• Make Agile Decisions: Define desired outcomes. Use a consistent, inclusive approach. Drive decisions with a sense of urgency. Pivot decisions quickly as supported by data.
• Build Trust: Listen to understand and use direct and open communication. Engage in healthy debate with mutual respect. Find solutions and move forward together.
• Own Results: Commit to desired outcomes. Define and achieve success metrics. Anticipate and mitigate risks, and always have a plan B. Take accountability for and learn from outcomes. 
• Empower Execution: Take action to drive desired outcomes. Act with initiative, mastery, and purpose.
• Explore Fearlessly: Make swift, iterative progress through testing and learning, create a safe place to fail fast and learn from mistakes, and continuously improve.
• Value People: Appreciate and care about unique experiences and perspectives Respect the dignity of others and have empathy for people Authentically and meaningfully support and recognize people in real time.

These traits form the bedrock of our commitment to caring deeply for each other, our customers, and our community. As you become a part of PEMCO, your contribution will further enrich our success story, where the power of these shared values propels us forward.

Compensation:

The pay range for this role is shown below. Compensation decisions are determined based on an individual's qualifications, job-related knowledge, skills, and experience.

• Greater Seattle area target pay range: $116,338-$142,190.  The full pay range is $96,948-$161,580.
• Outside greater Seattle area target pay range: $102,670-$125,486.  The full pay range is $85,559-$142,598.

Greater Seattle Area is defined as working within approximately 100 miles of Seattle.

Outside Greater Seattle is defined as working approximately 100 miles or more from Seattle.

Benefits:

Regular part-time PEMCO employees working at least 24 hours per week and regular full-time PEMCO employees are eligible to elect coverage under medical, dental, and vision plans for themselves and their eligible family members with generous employer premium cost shares. In addition, as a benefits-eligible employee, you are:

• covered by employer-paid basic life and accidental death & dismemberment insurance policies as well as long- and short-term disability benefit coverages.
• eligible to participate in PEMCO's 401(k) plan which includes a generous employer match (2 for 1 on the first 6% employee pre-tax and/or Roth deferral, up to federal maximums). 

PEMCO provides the following paid leave programs for benefits-eligible employees in their first year of PEMCO employment:

• Vacation accrues at a rate of 10 days for new hires, and increases based on a schedule to a maximum annual accrual of 25 days based on tenure.
• Granted four (4) personal days immediately upon hire.
• Paid holidays for the eight (8) holidays observed by PEMCO throughout the calendar year.
• Granted up to ten (10) days of sick leave immediately upon hire (pro-rated based on hire date and full-time/part-time status), which is approximately 28 hours more per year than the Washington state-required accrual.
• In addition, PEMCO provides paid time off for bereavement, jury duty, and employee volunteering in the community.

Other miscellaneous benefit programs offered by PEMCO include:

• Flexible Spending Accounts
• Education Assistance Program after one year of service
• Scholarship program for children of PEMCO employees after one year of service
• Employee Assistance Program
• Well-being program
• Discretionary taxable gifts and gift cards
• And other Perks & Benefits including discounts on computer software and hardware, cell phone plans, and rental cars

Other compensation depending on role, contributions, and performance may include:

• Discretionary bonuses
• Tiered sales commissions and/or incentives (from 5-25% of employee's monthly sales)
• Employee referral bonuses
• Shift differential pay

Equal Employment Opportunity:

At PEMCO, we celebrate and support our differences. We know employing a team rich in diverse thoughts, experiences, and opinions allows our employees, our products, and our community to flourish. PEMCO is honored to be an equal opportunity workplace. We are dedicated to equal employment opportunities regardless of race, color, ancestry, religion, sex, national orientation, age, citizenship, marital status, disability, gender identity, sexual orientation, or veteran status.

Applicants have rights under Federal Employment Laws:

• Family and Medical Leave Act (FMLA) 
• Equal Employment Opportunity (EEO) 
• Employee Polygraph Protection Act (EPPA)