Lead Data Engineer (Hybrid)

American Family Insurance

4.6

(10)

Madison, WI

Why you should apply for a job to American Family Insurance:

  • 4.6/5 in overall job satisfaction
  • 4.9/5 in supportive management
  • 80% say women are treated fairly and equally to men
  • 90% would recommend this company to other women
  • 80% say the CEO supports gender diversity
  • Ratings are based on anonymous reviews by Fairygodboss members.
  • Matching employee donations up to $3,000 each year to qualifying nonprofit organizations.
  • Paid leave program offers two weeks of paid time off each year to parents to care for a child, spouse, domestic partner or parent.
  • Children of employees can apply for an annual scholarship of $2,500 for up to four years ($10,000).
  • #R36504

    Position summary

    rity, privacy, and integrity of data throughout the data lifecycle.

    • Document critical workflows and operational support aspects of team's responsibilities

    • Develop understanding of data sources, granularity, availability, and limitations.

    • Provide proactive technical oversight and advice to application architecture and development teams promoting re-use, design for scale, stability, and operational efficiency of data/analytical solutions.

    • Create maintainable, scalable code to load and manipulate data in the data warehouse.

    • Facilitate communication upward and across project teams and partners.

    Requirements:

    • Expert level Python programming experience, with an emphasis towards building scalable ETL pipelines.

    • Demonstrated experience providing customer-oriented solutions or support.

    • In-depth knowledge of SQL or NoSQL and experience using a variety of data stores (e.g. RDBMS, analytic database, scalable document stores).

    • Employ design patterns and generalize code to address common use cases.

    • Author high quality, reusable code and contributing to the division's inventory of libraries.

    • Expertise in big data batch computing tools (e.g. Hadoop or Spark), with demonstrated experience developing distributed data processing solutions.

    • Applied knowledge of cloud computing (AWS, GCP, Azure).

    • Knowledge of open source machine learning toolkits, such as sklearn, Spark ML, or H2O.

    • Solid data understanding in the data rich industries like insurance or financial

    • Applied knowledge of data modeling principles (e.g. dimensional modeling and star schemas).

    • Experience with database internals, such as indexes, binary logging, and transactions.

    • Experience using tools for infrastructure-as-code (e.g. Docker, CloudFormation, Terraform).

    • Experience with software engineering tools and workflows (i.e. Jenkins, CI/CD, git).

    • Practical experience authoring and consuming web services.

    Additional Information

    • Offer to selected candidate will be made contingent on the results of applicable background checks

    • Offer to selected candidate is contingent on signing a non-disclosure agreement for proprietary information, trade secrets, and inventions

    • Sponsorship will not be considered for this position unless specified in the posting

    In this hybrid role, you will work at least 10 days per month from the office. You should reside within approximately 50 miles of our Madison office, WI 53783

    If you are not currently proximate to Madison , then you will be expected to relocate to Madison, WI (we provide relocation assistance).

    #LI-Hybrid

    Your offer will be made contingent on the results of applicable background checks and signing a non-disclosure agreement for proprietary information, trade secrets, and inventions.

    We encourage you to apply even if you do not meet all of the requirements listed above. Skills can be used in many different ways, and your life and professional experience may be relevant beyond what a list of requirements will capture. We encourage those who are passionate about what we do to apply!

    We provide benefits that support your physical, emotional, and financial wellbeing. You will have access to comprehensive medical, dental, vision and wellbeing benefits that enable you to take care of your health. We also offer a competitive 401(k) contribution, a pension plan, an annual incentive, 9 paid holidays and a paid time off program (23 days accrued annually for full-time employees). In addition, our student loan repayment program and paid-family leave are available to support our employees and their families. Interns and contingent workers are not eligible for American Family Insurance Group benefits.

    We are an equal opportunity employer. It is our policy to comply with all applicable federal, state and local laws pertaining to non-discrimination, non-harassment and equal opportunity. We also consider qualified applicants with criminal histories, consistent with applicable federal, state and local law.

    #LI-DB1

    Why you should apply for a job to American Family Insurance:

  • 4.6/5 in overall job satisfaction
  • 4.9/5 in supportive management
  • 80% say women are treated fairly and equally to men
  • 90% would recommend this company to other women
  • 80% say the CEO supports gender diversity
  • Ratings are based on anonymous reviews by Fairygodboss members.
  • Matching employee donations up to $3,000 each year to qualifying nonprofit organizations.
  • Paid leave program offers two weeks of paid time off each year to parents to care for a child, spouse, domestic partner or parent.
  • Children of employees can apply for an annual scholarship of $2,500 for up to four years ($10,000).