ETL/ELT Technical Lead

Summary

Designs, develops and programs methods, processes, and systems to consolidate and analyze unstructured, diverse “big data” sources to generate actionable insights and solutions for client services and product enhancement. Interacts with product and service teams to identify questions and issues for data analysis and experiments. Develops and codes software programs, algorithms and automated processes to cleanse, integrate and evaluate large datasets from multiple disparate sources. Identifies meaningful insights from large data and metadata sources; interprets and communicates insights and findings from analysis and experiments to product, service, and business managers.

Job Description

Responsibilities

• Provide hands-on guidance and leadership for a team of data engineers working on multiple simultaneous projects with a focus on data preparation and pipeline development for predictive modeling. 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

• Demonstrate a culture of ownership and accountability to deliver high velocity, high quality work

• Work collaboratively with other staff including product managers, data scientists, other data analysts, architects to solve problems, develop innovative approaches, and scale product output

• 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

• At Guidewire, we foster a culture of curiosity, innovation, and responsible use of AI—empowering our teams to continuously leverage emerging technologies and data-driven insights to enhance productivity and outcomes.

Qualifications

• Bachelors or Masters degree or equivalent industry experience

• Passion for owning and solving complex data engineering problems 

• Phenomenal communication skills with both technical and non-technical audiences

• 7- 10+ years of relevant data engineering experience

• Deep experience implementing DBT and driving ETL/ELT development

• Extensive hands-on experience with the following AWS technologies:

• Redshift

• MWAA

• EMR

• Glue

• Expert SQL and Python skills

• Exposure to building M data pipelines and features for predictive modeling

• Experience within regulated financial services or P&C insurance a bonus

• 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.

The US base salary range for this full-time position is $144,000 - $216,000 . Your base pay will depend on your experience, skills, education, training, and location among other factors. All full-time positions or part-time roles working 30 hours or more a week at Guidewire are eligible for benefits that support their health and well-being including health, dental, and vision insurance, paid time off, and a company sponsored retirement plan. In addition, some roles may be eligible for the annual company bonus plan, commissions, and/or long term incentive awards which are contingent on a variety of factors including, but not limited to, company and employee performance.

Disability Accommodations and Guidewire’s Appeals Process. Guidewire provides accommodations to the hiring process to create a fair opportunity for candidates with disabilities to contend for open positions. Accommodation requests should be directed to [email protected]. If things do not go as hoped, we invite you to use our appeals process. Guidewire promises to independently review any denied accommodation and any decision not to offer you the position. The appeals process is the same in either case. Within five business days of receiving a notice of denial of an accommodation, or receiving a notice of your non-selection for a vacancy, e-mail [email protected] to make an appeal. Guidewire will assign a new decision-maker to review the request and/or hiring decision, who will then notify you in writing of a decision within 10 business days.

About Guidewire

Guidewire is the platform P&C insurers trust to engage, innovate, and grow efficiently. We combine digital, core, analytics, and AI to deliver our platform as a cloud service. More than 540+ insurers in 40 countries, from new ventures to the largest and most complex in the world, run on Guidewire.

As a partner to our customers, we continually evolve to enable their success. We are proud of our unparalleled implementation track record with 1600+ successful projects, supported by the largest R&D team and partner ecosystem in the industry. Our Marketplace provides hundreds of applications that accelerate integration, localization, and innovation.

For more information, please visit www.guidewire.com and follow us on Twitter: @Guidewire_PandC.

Guidewire Software, Inc. is proud to be an equal opportunity and affirmative action employer. We are committed to an inclusive workplace, and believe that a diversity of perspectives, abilities, and cultures is a key to our success. Qualified applicants will receive consideration without regard to race, color, ancestry, religion, sex, national origin, citizenship, marital status, age, sexual orientation, gender identity, gender expression, veteran status, or disability. All offers are contingent upon passing a criminal history and other background checks where it's applicable to the position.