• Data Quality Analyst

    Location US-CA-Rocklin
    Job ID
  • Summary

    Esurance is looking for a Data Quality Analyst 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 Data Quality Analyst at Esurance you will be responsible for maintaining the quality of data at all levels at all times. Additionally, you will design and develop validation models to meet data quality specifications and will work with the business analysts to understand and document data quality requirements and develop medium to complex SQL queries for data integrity analysis. In collaboration with the BI team, DBA's, Development and Support engineers you will work to better understand data sources and implement new requirements and develop Data Quality metrics and will work to resolve issues at the source rather than later in production environments.


    Job Responsibilities:


    • Identifies, compares, and resolves data quality problems.
    • Analyzes, queries and manipulates data according to defined business rules and procedures.
    • Evaluates large dataset for quality and accuracy.
    • Determines business impact level for data quality issues.
    • Researches and determines scope and complexity of issue so as to identify steps to fix issue.
    • Works with Application Engineers and Quality Engineers to eliminate possible data issues in production.
    • Determines root cause for data quality errors and make recommendations for long-term solutions.
    • Develops process improvements to enhance overall data quality.
    • Develops and executes data cleanup measures (Data Quality Metrics and SLA)
    • Ensures new system design meets data quality standards.
    • Ensures adherence to data quality standards.
    • Resolves all internal data exceptions in timely and accurate manner.
    • Other duties may be assigned.




    • Strong Microsoft SQL Server skills.
    • Strong working knowledge on .NET/C#/Java script/Python programing
    • Ability to multi-task and work well under deadlines in a changing environment.
    • Ability to independently manage and prioritize task assignments.
    • Strong quantitative, analytical, process development, facilitation and organizational skills required.
    • Ability to handle confidential information with diplomacy and tact.
    • Ability to be flexible and work extended hours as required.
    • Strong communication skills.
    • Must have an understanding of or ability to quickly grasp technology concepts.


    Experience / Education:

    • Bachelor’s degree in Computer Science, a related field, or equivalent education required.
    • Minimum 4 years of experience in data quality analysis and developing SQL queries out of which there should be at least 2 years of experience in application development using .NET framework/Java/Python.




    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



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


    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.