• Business Intelligence Engineer

    Location US-CA-San Francisco
    Job ID
  • Summary

    Esurance is looking for a Business Intelligence 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. 


    As a Business Intelligence Engineer, you will be responsible for designing and developing OLAP cubes, flat reports, dashboards and data applications using modern Data Warehouse and Big Data solutions. You 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:

    • Designs and develops dashboards, flat reports and data applications using large volume structured and unstructured data.
    • Designs and develops interactive data visualization using Tableau.
    • Builds and maintains scalable cross-platform ETL pipelines to bring the data into the data warehouse.
    • Designs Hive/HBase distributed data warehouse/Data Hub.
    • Maintains dimensions and reference lookup dictionaries.
    • Collaborates with Business, Developers and Data teams to gather requirements and develop reports.


    • Required skills: SQL Server, Oracle, Hadoop, MapReduce/Spark, Hive/Impala/Pig, Python/Java/Scala, RedShift/BigQuery or similar cloud DWH solution.
    • Preferred skills: Cloud Services like AWS/Azure/GCP, Linux Shell Scripting.
    • 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 5 years of progressively responsible experience in a directly related area.
    • 3+ years working experience in SQL Server/Oracle and Object oriented programming.
    • 2+ years of Data engineering experience in Hadoop environment.



    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 (company-paid and supplemental)
    • Accidental death and dismemberment coverage
    • Wellness coaching and incentives
    • Group critical illness coverage
    • Accident indemnity and hospital indemnity plans
    • Group legal


    • 401(k) plan with annual matching contribution
    • 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
    • Maternity leave
    • Buckle Up Baby program
    • Pet insurance discount
    • Charitable gift matching
    • Give Time, Get Time volunteer program
    • Employee Assistance Program

    Time off

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


    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Need help finding the right job?

    We can recommend jobs specifically for you! Click here to get started.