Senior Data Engineer

American Family Insurance Group • Madison, WI

170d • $97,000 - $164,000 • Hybrid

About The Position

This position collects, stores, processes and builds business intelligence and analytics applications within our big data platform. The role will also be responsible for integrating these applications with the architecture used across the organization.

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

Responsibilities

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

Benefits

• Comprehensive medical, dental, vision and wellbeing benefits.
• Competitive 401(k) contribution.
• Pension plan.
• Annual incentive.
• 9 paid holidays.
• Paid time off program (23 days accrued annually for full-time employees).
• Student loan repayment program.
• Paid-family leave.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Insurance Carriers and Related Activities