Job Description

At American Family Insurance, we believe people are an organizations most valuable asset, and their ideas and experiences matter. From our CEO to our agency force, were committed to growing a diverse and inclusive culture that empowers innovation that will inspire, protect, and restore our customers dreams in ways never imagined.

American Family Insurance is driven by our customers and employees. Thats why we provide more than just a job we provide opportunity. Whether youre already part of our team in search of a new challenge or new to our company and ready for whats next, youre in the right place. Every dream is a journey that starts with a single step. Start your journey right here. Join our team. Bring your dreams.



Job ID:

R20117 Data Engineer / Data Modeler / BI Engineer(Open to Remote) (Open)

Compensation may vary based on the job level and your geographic work location.

Compensation Minimum:$76,900

Compensation Maximum:$141,600

Summary:

Second level in the job family. Works independently and collaborate with cross-functional business and IT stakeholders to provide and maintain data, reporting and analytical solutions. Provides flexibility to specialize in one area and/or play multiple roles across business data analysis, design, development, and support functions. Will develop broader and deeper functional and technical skills in data and analytics as well as develop expertise in a business data domain systems


Job Description:

Primary Accountabilities

* Partner with business stakeholders to understand their needs, gather and analyze business requirements, perform data analysis, assist in change management, training and testing efforts.
* Solicit business, functional, non-functional and technical requirements through interviewing and requirements gathering process. Document requirements, including business rules, functional and non-functional requirements and data definitions.
* Develops user acceptance testing and quality assurance test scenarios and cases working with business partners to help ensure data delivery meets business requirements. Collaborates with stakeholders to produce and maintain accurate test documentation.
* Design data warehousing, advanced analytics and business intelligence solutions. Design semantic layer, virtualization layer, appropriate use of BI client tools and technical components within BI client tools. Write functional and technical specifications.
* Performs impact analysis and communicates changes and impact to those affected.
* Assist with establishing design standards and best practices to optimize performance and efficiency of the data warehousing environment.
* Develop code, scripts, Extract Transform Load (ETL) mappings, stored procedures, universes, queries, reports, dashboards, and analytical applications.
* Ensure capture and publish of metadata, proactive and ongoing data quality controls, monitoring and reporting.
* Perform database activities such as setup, configuration, troubleshooting, tuning & optimization, database object creation & modification and metadata management.
* Perform ETL tool related activities such as repository and folder creation and management, troubleshooting and ETL performance optimization.
* Perform second and third level production support activities including production incidence prioritization and resolution, defect and small enhancement implementation.
* May assist junior level employees with data or project issues.

Travel Requirements

* Travel is required up to 10% of the time

Specialized Knowledge and Skills Requirements

* Demonstrated experience providing customer-driven solutions, support or service.
* Solid knowledge and understanding of processes, tools and deliverables for business data analysis.
* Solid knowledge and understanding of translating business requirements into functional and technical specifications.
* Solid knowledge and understanding of data integration, data warehousing, and business intelligence concepts and technologies.
* Solid knowledge and understanding of data models and database design and development concepts and methods.
* Solid knowledge and understanding of data architecture and development standards.
* Solid knowledge and understanding of the systems development life cycle (SDLC).
* Solid knowledge and understanding of developing ETL programs, data processing programs in a specific language for a specific platform.
* Solid knowledge and understanding of testing and quality assurance methodologies, automation, and tools.



Additional Job Information:

We currently have 2 openings. This role is responsible for building a centralized business intelligence- data analytics/data layer for use across the enterprise. This position will support our operating companies and Center of Excellence by providing a place to get metrics and dimensions for further analysis. Also, providing dashboards and information to the business.

Preferred candidates with experience outlined below:

* Experience with data range and data prep tools (SQL, Trifecta)

* Google Cloud platform experience (BigQuery)

* User data visualization tools (Tableau, Power BI)

* We are open to hiring candidates to work remotely (anywhere in the USA).

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

* Open to hiring at level 2 or level 3 of the job family.

LI-Remote

When you work at American Family you can expect 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, and a paid-time off program. 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 Enterprise benefits.

Stay connected: Join Our Enterprise Talent Community!

LI:MR1