Senior Data Engineer
Guidewire Software•San Mateo, CA
•$148,000 - $247,000
About The Position
Ready for a new challenge? Join Guidewire as a Data Engineer! We are building a new team to take advantage of our market leading position and access to data to build advanced predictive models and variables to drive the next generation of growth in the P&C insurance market. This is an opportunity to come on board early and shape our direction and have a broad impact on the insurance industry.
Requirements
- Bachelors or Masters degree or equivalent industry experience
- Passion for solving complex data problems
- 7-10+ years of relevant experience
- Advanced, hands on experience building modeling datasets, pipelines and features for predictive modeling
- Extensive experience using DBT, Apache Iceberg, and AWS data capabilities like Airflow, Glue, Redshift, EMR to build ML data pipelines, with a strong focus on data quality and governance.
- Expert SQL skills, including advanced functions, table design, view creation, stored procedure and script design and coding, general performance tuning
- Proficient in data processing and transformations using Apache Spark.
- Working knowledge of Python
- Experience with version control systems (e.g., Git) for managing data pipelines and features.
- Understanding of MLOps principles and practices related to data preparation and feature engineering
- Self-motivated and detail-oriented with desire to solve problems
- Demonstrated ability to embrace AI and apply it to your role as well as use data-driven insights to drive innovation, productivity, and continuous improvement.
Nice To Haves
- experience using Sagemaker and feature stores a plus
- Familiarity with common challenges in integrating RDBMS-sourced data into a data warehouse, including temporal data handling, Change Data Capture (CDC), Slowly Changing Dimensions (SCD), and data modeling methodologies like Kimball and Data Vault
- Experience within a regulated industry (finance, insurance, etc…); P&C policy administration and claims processing concepts as well as US/Canadian P&C standard lines of business experience a plus
Responsibilities
- Participate in multiple simultaneous projects with a focus on data preparation and pipeline development for predictive modeling and machine learning.
- Includes: Data interrogation, exploratory data analysis, profiling, and reconciliation
- Data pipeline creation, revision and monitoring based on product manager and data scientist/actuarial input
- Feature creation, initial testing, and ongoing management
- Work collaboratively with other staff including product managers, data scientists, other data analysts, architects to solve problems, develop innovative approaches, and provide project status
- Create and manage data assets, datasets, features, and code with a focus on simplicity, scalability, reusability, and clear documentation
- Additional work assignments not related to specific project work such as new feature development, external data research, providing user feedback on new products and tools under development
Benefits
- health, dental, and vision insurance
- paid time off
- a company sponsored retirement plan
- annual company bonus plan
- commissions
- long term incentive awards
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Upload and Match Resume
What This Job Offers
Job Type
Full-time
Career Level
Senior
Education Level
Associate degree
