Principal Data Engineer

PEMCO Data Engineer

Applicants must be a resident and work from one of the following states: WA, OR, ID, TX, OH, IL, MN, NC, SC or FL, with occasional travel to our headquarters, located in Seattle, WA.

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 2026, 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:

This position serves as PEMCO's senior individual contributor in the Data & AI Organization and is responsible for designing, building, and evolving scalable data processing patterns and data products that power analytics, reporting, operational intelligence, and AI across the enterprise. The Principal Data Engineer combines deep technical expertise with insurance domain knowledge to deliver trusted, reusable, and governed data assets that support underwriting, claims, policy, customer, finance, and regulatory reporting needs. This role drives technical excellence through hands-on engineering, architectural leadership, mentorship, and influence without direct people management responsibilities.

What You'll Be Doing:

• Design and develop scalable, secure, and resilient data processing patterns, frameworks, pipelines, and reusable data products supporting enterprise analytics, reporting, and AI initiatives.
• Build and optimize cloud-native data solutions leveraging Databricks, Spark, Delta Lake, Azure Data Platform services, SQL Server, and modern lakehouse architectures.
• Design and implement batch, streaming, and near real-time data processing frameworks capable of handling large-scale enterprise data workloads.
• Develop trusted, governed, and reusable datasets at atomic grain that can be leveraged across analytics, operational reporting, and AI use cases.
• Partner with business stakeholders, analysts, data scientists, architects, and engineers to translate complex business requirements into scalable data solutions.
• Establish and promote engineering standards, architectural patterns, and best practices related to data modeling, performance optimization, testing, observability, and reliability.
• Design and implement robust data integration solutions across policy, claims, billing, customer, finance, actuarial, and third-party insurance systems.
• Drive modernization of legacy data platforms and accelerate migration toward cloud-native data architectures and engineering practices.
• Optimize data pipelines, storage, compute utilization, and query performance to improve scalability, reliability, and cost efficiency.
• Collaborate with Data Governance teams to implement metadata management, lineage, data quality controls, stewardship processes, and security standards.
• Contribute to architecture reviews, code reviews, and technical design discussions across multiple projects and teams.
• Evaluate emerging technologies, tools, and architectural patterns to improve engineering productivity and platform capabilities.
• Mentor and provide technical guidance to data engineers through knowledge sharing and hands-on collaboration.
• Participate in troubleshooting, root-cause analysis, and resolution of complex data platform and production issues.
• Support AI, machine learning, and advanced analytics initiatives by enabling high-quality, accessible, and governed data foundations.
• Demonstrate behaviors consistent with PEMCO's policies, values, code of ethics, and business conduct.
• Authentically support the PEMCO Brand and constantly be on the lookout for top talent to join us in achieving our Mission to Worry Less and Live More.
• Other duties as assigned.

What You'll Bring:

• Bachelor's degree in Computer Science, Information Systems, Engineering, Mathematics, Data Science, or a related technical field is required.
• Master's degree or equivalent advanced education is preferred.
• Equivalent combination of education and professional experience may be considered.
• 10+ years of experience in Data Engineering, Data Warehousing, Big Data Engineering, or related disciplines is required.
• 5+ years of experience designing and implementing cloud-based data solutions on Azure or equivalent cloud platforms is required.
• Proven experience building and operating enterprise-scale data platforms supporting high-volume analytics and operational workloads is required.
• Extensive experience with Databricks, Apache Spark, Delta Lake, PySpark, and lakehouse architectures is required.
• Strong experience with SQL Server, T-SQL, database engineering, performance tuning, and large-scale data processing is required.
• Experience designing dimensional models, Data Vault models, or other modern data product architectures is required.
• Experience implementing DataOps, CI/CD, Infrastructure as Code, automated testing, and cloud engineering practices is preferred.
• Familiarity with data platforms that support Artificial Intelligence (AI), Machine Learning (ML), Generative AI, Agentic AI, and advanced analytics use cases is preferred.
• Property & Casualty insurance industry experience is strongly preferred.
• Strong understanding of insurance business domains including Policy, Claims, Underwriting, Billing, Agency, Customer, Finance, and Regulatory Reporting data is preferred.
• Experience integrating third-party data providers, vendor systems, APIs, and enterprise platforms is preferred.
• Databricks Certified Data Engineer Professional preferred.
• Microsoft Azure Data Engineer Associate (DP-203) preferred.
• Azure Solutions Architect Expert certification preferred.
• Certified Data Management Professional (CDMP) preferred.
• Expert-level proficiency in SQL, data modeling, database design, and large-scale data engineering is required.
• Advanced proficiency with Databricks, Spark, Delta Lake, and distributed data processing frameworks is required.
• Demonstrated expertise designing scalable ELT/ETL solutions and modern data architectures is required.
• Strong understanding of cloud-native architecture patterns, data platform design, and analytics engineering is required.
• Experience designing highly reusable and governed data products that support reporting, analytics, and AI workloads is required.
• Demonstrated knowledge of data quality, lineage, metadata management, observability, and operational monitoring is required.
• Strong understanding of data governance, security, privacy, and regulatory compliance controls is required.
• Experience optimizing performance, scalability, reliability, and cost of enterprise data platforms is required.
• Demonstrated ability to solve highly complex technical and business problems in a collaborative environment is required.
• Ability to influence technical direction and engineering standards through expertise, mentorship, and technical leadership is required.
• Familiarity with AI-assisted software development tools such as GitHub Copilot, Databricks Assistant, or equivalent AI coding and productivity tools is preferred.
• Ability to use AI-assisted engineering tools responsibly to improve development, testing, troubleshooting, and documentation is preferred.
• Azure Data Factory, Azure Storage, Azure Event Hub, Azure DevOps, Git, and Infrastructure as Code experience is preferred.
• Problem Solver: Ability to analyze, diagnose, and resolve highly complex, ambiguous, and large-scale technical challenges efficiently and collaboratively.

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: $ 170,330 - $ 208,181. The full pay range is $ 141,941 - $236,569. Outside Greater Seattle area target pay range: $ 150,319 - $ 183,723. The full pay range is $ 125,266 - $ 208,777. 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