AFMIC American Family Mutual Insurance Company, S.I.

Compensation

Full Description

As a Data Engineer with American Family Insurance, you will play an important part in harnessing the power of data to guide innovation. You'll collect, store, and process data to create impactful applications within our dynamic big data platform. You will integrate these applications into our architecture and contribute to a collaborative and forward-thinking environment. This engineering role focuses on collecting data from multiple sources, partners, and platforms and ingesting it into our GCP platform. Primarily tools are Python, SQL, GCP, Terraform, and BigQuery. You will report to a Senior Manager, Data Engineering. In this flex office/home role, you will be expected to work a minimum of 10 days per month from the following office location: Madison, WI 53783. #LI-Hybrid Position Compensation Range: $80,000.00 - $131,000.00 Pay Rate Type: Salary Compensation may vary based on the job level and your geographic work location. Relocation support is offered for eligible candidates. Primary Accountabilities Perform exploratory data analysis to determine which questions can be answered with a given dataset. Develop scalable and extensible data pipelines from internal and external sources. Work on teams to develop data-driven applications and products, particularly within the space of data science. Help prototype new technologies involving data ingestion and transformation, distributed file systems, databases and frameworks. Develop tools to increase the productivity of application development and client-facing teams. Develop and automate data quality checks. Develop big data applications and data visualization tools. Specialized Knowledge & Skills Requirements Demonstrated experience providing customer-oriented solutions or support. Knowledge of SQL and experience using a variety of data stores (e.g. RDBMS, analytic database, scalable document stores). Hands-on programming experience in Python or java, with an emphasis towards building ETL workflows and data-driven solutions. Work experience with Linux scripting to automate workflows. Understanding of database internals, such as indexes, binary logging, and transactions. Knowledge of cloud computing platforms (e.g. GCP, AWS, Azure). Understanding of Infrastructure as Code (e.g. Terraform, Docker, CloudFormation) Your offer will be contingent on the results of applicable background checks and signing a non-disclosure agreement for proprietary information, trade secrets, and inventions. We will not consider candidates who require sponsorship. 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 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. American Family Insurance is committed to the full inclusion of all qualified individuals. If a reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and/or to receive other benefits and privileges of employment, please email AskHR@AmFam.com to request a reasonable accommodation. #LI-DB1 American Family Insurance, a mutual holding company based in Madison, Wis., has been serving customers since 1927. We inspire, protect and restore dreams through our insurance products, exceptional service from our agency owners and employees, community investments and creative partnerships. American Family Insurance Group is the nation’s 12th-largest property/casualty insurance group, ranking No. 202 on the Fortune 500 list. The American Family Insurance Group also includes CONNECT, powered by American Family Insurance, Homesite and Main Street America Insurance and has approximately 11,000 employees nationwide. Join our Talent Community