Senior Data Engineer

Senior Data Engineer American Family Insurance - 3.5 Madison, WI Job Details $99,000 - $167,000 a year 20 hours ago Benefits Paid holidays Loan repayment program Health insurance Dental insurance Paid time off Pension plan Family leave Vision insurance Qualifications RDBMS Senior level Full Job Description 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.

Position Compensation Range:

$99,000.00 - $167,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 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.

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 flex office/home role, you will be expected to work a minimum of 10 days per month from one of the following office locations: Madison, WI. Candidates must reside within a 50-mile radius of the office location. Internal Candidates are encouraged to apply and will be considered based upon the needs of the role. However Internal Candidates that are not located Madison, Wi and not in the same Job Family. You will be required to relocate to Madison, Wi. 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 to request a reasonable accommodation. #LI-BC2