Senior Data Engineer (Hybrid in Madison, WI and Boston, MA only)

Position Compensation Range:

Pay Rate Type:

Compensation may vary based on the job level and your geographic work location. Relocation support is offered for eligible candidates.

Primary Accountabilities
*Performs exploratory data analysis to determine which questions can be answered effectively with a given dataset and has the ability to analyze new (possibly unstructured) data sources to determine what additional value they may bring.
*Designs and develops highly scalable and extensible data pipelines from internal and external sources.
*Works on cross-functional teams to design, develop, and deploy data-driven applications and products, particularly within the space of data science.
*Prototypes emerging technologies involving data ingestion and transformation, distributed file systems, databases and frameworks.
*Designs, builds, and maintains tools to increase the productivity of application development and client facing teams.
*Partners with business analyst to define, develop, and automate data quality checks.
*Designs and develops big data applications and data visualization tools.

Specialized Knowledge & Skills Requirements
*Demonstrated experience providing customer-driven solutions, support or service.
In-depth 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.
*Experience with big data batch computing tools (e.g. Hadoop or Spark) and developing distributed data processing solutions.
*Experience with cloud computing platforms (e.g. AWS, GCP, Azure)
*Good data understanding and business acumen in the data rich industries like insurance or financial
*Solid understanding of data modeling principles (e.g. dimensional modeling and star schemas).
*Solid understanding of database internals, such as indexes, binary logging, and transactions.
*Solid understanding of Infrastructure as Code (e.g. Docker, CloudFormation, Terraform, etc.)
*Solid understanding of with software engineering tools and workflows (i.e. Jenkins, CI/CD, git).

Licenses:
*Not Applicable.

Travel Requirements
*Up to 10%.

Physical Requirements
*Work that primarily involves sitting/standing.

Working Conditions
*Not Applicable.

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.