Data Engineer
San Francisco, CA

Job Description

Summary

Esurance is looking for a Data Engineer to join a dynamic and award-winning team of individuals who are committed to making insurance smarter, easier, and dare we say- cooler. As part of a growing company that is focused on providing an outstanding customer experience, you'll have the opportunity to expand your skills and discover your potential.

If you're looking for a career at a socially conscious company that offers great benefits - including matching 401k and tuition reimbursement - then you may have just found your new home.

Esurance combines the spunk of a startup company with the backing of Allstate (the largest publicly held personal lines insurer in the U.S.) to create a unique, energized, and exciting place to work.

Responsibilities

Summary:The Data Engineer will be responsible for building and maintaining data ingestion pipeline, design and develop reports using modern Data Warehouse and Big Data solutions. S/he will be responsible for setting up end to end process to consume, integrate and analyze large volumes of data on Hadoop and other data warehouse platforms.

Job Responsibilities:

* Builds and maintains scalable cross-platform ETL pipelines to keep the metrics flowing into data warehouse.
* Designs and develops dashboards, flat reports and data applications using large volume structured and unstructured data.
* Performs all of the necessary data transformations to populate data into a warehouse table structure that is optimized for reporting.
* Designs, integrates and documents technical components for seamless data extraction and analysis on big data platform.
* Collaborates with product, data science and data analyst teams to gather requirements and develop reports.

Qualifications:

* Experience in programming language (such as Java or Python).
* Experience in Cloud Data Warehouse solutions such as Snowflake Computing or AWS Redshift or Google BigQuery is preferred.
* Strong understanding of Data Warehouse modeling and distributed systems.
* Able to effectively work independently and within a collaborative team oriented environment using sound judgment in decision-making.
* Excellent communication skills, both verbal and written, with excellent analytical and problem solving skills.
* Organized and detail-oriented, able to work well under deadlines in a changing environment and perform multiple tasks effectively and concurrently.

Experience/Education:

* Bachelor's Degree in Computer Science/ Mathematics/Statistics or related field.
* Minimum of 3 years of progressively responsible experience in a directly related area.
* 3+ years working experience in developing SQLs in a data warehouse platform using SQL Server or Oracle or in any MPP platform.
* 2+ years of experience in developing data pipelines and performing analytics using Spark or Scala in Hadoop platform.

Physical Demands and Work Environment:Representative of those that must be met by an employee to successfully perform the essential functions of this job. Must be able to operate a PC and sit for extended periods of time. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Qualifications

Benefits

At Esurance, being committed to our employees is not just something we say, it's something we do. Our benefits package is designed to help our associates stay healthy, meet their long-term financial goals, and balance the demands of work and personal life. Esurance rewards hard work, dedication, and creativity with competitive salaries and a generous bonus system. We are committed to our employees and we are dedicated to creating a diverse, positive, innovative and team-oriented work environment.

Health & wellness

* Medical, vision, and dental insurance
* Life Insurance
* Accidental death and dismemberment coverage
* Wellness tools and coaching
* Group critical illness coverage
* Accident indemnity and hospital indemnity plans
* Group legal
* Student Loan Repayment Program
* Identity Protection

Savings

* 401(k) plan with annual matching contribution
* Choice Dollars
* Referral bonuses
* Performance-rewarding bonus system
* Tuition assistance program (up to $5,250 per year)
* Health savings and flexible spending accounts
* Commuter benefits

Family & community

* Adoption assistance
* Buckle Up Baby program
* Pet insurance discount
* Charitable gift matching
* Give Time, Get Time volunteer program
* Employee Assistance Program

Time off

* Paid time off (holidays, vacation, personal days)
* Short-term disability
* Long-term disability (employee-paid option)