People Analytics Data Engineer - Lead Consultant (Remote-Home Based Worker) Job at Allstate Insurance Company, Remote

  • Allstate Insurance Company
  • Remote

Job Description

The world isnt standing still, and neither is Allstate. Were moving quickly, looking across our businesses and brands and taking bold steps to better serve customers evolving needs. Thats why now is an exciting time to join our team. Youll have opportunities to take risks, challenge the status quo and shape the future for the greater good.

Youll do all this in an environment of excellence and the highest ethical standards a place where values such as integrity, inclusive diversity and accountability are paramount. We empower every employee to lead, drive change and give back where they work and live. Our people are our greatest strength, and we work as one team in service of our customers and communities.

Everything we do at Allstate is driven by a shared purpose: to protect people from lifes uncertainties so they can realize their hopes and dreams. For more than 89 years weve thrived by staying a step ahead of whatevers coming next to give customers peace of mind no matter what changes they face. We acted with conviction to advocate for seat belts, air bags and graduated driving laws. We help give survivors of domestic violence a voice through financial empowerment. Weve been an industry leader in pricing sophistication, telematics, digital photo claims and, more recently, device and identity protection.

We are the Good Hands. We dont follow the trends. We set them.

Job Summary:

The People Analytics Data Engineer - Lead Consultant is responsible for the design and development of data infrastructure and engineering projects for human capital data for People Analytics and the enterprise. This role will develop, construct and maintain large, complex data through design, collection, integration, processing and transformation of large datasets from HR, Finance and other data sources. This person will support leaders, data scientists and analysts on their data needs to drive strategic reporting, advanced analytics and workforce planning activities.

This position is a permanent remote home-based worker. Your home office does not need to be near an Allstate office, but it does need to be in the United States. This position is eligible for a monthly connectivity reimbursement to offset the costs of internet and phone expenses.

Key Responsibilities:

  • Designs, architects, analyze, develops and implements key data and support of architecture and warehousing approaches.
  • Build and execute ETL processes from multiple, disparate data sources such as flat files, web services/APIs, databases, etc.
  • Create technical documents to document data/system contents, concepts, and mapping between data assets and systems.
  • Lead and support the data solutions in the creation of insightful reports and analyses.
  • Independently monitor and consults on existing metrics, analyze data, and partner with other data teams to identify and implement system and process improvements.
  • As a team expert, provide direction to peers or AOR partners on technical solutions. Understand the changing analytic needs of users and assists in the development of goals, and tracks of work to meet those needs.
  • Partner on new ideas and initiatives, and executes rapid development of new data and analytic projects
  • Contributes to the innovation of solution development including the consultation on right-sizing decisions, software solutions, and services.
  • Continual improvement of data platforms and pipelines.
  • Actively shares knowledge and experiences with the team, serving as an expert in data engineering and applying best practices.

Supervisory Responsibilities:

This job does not have supervisory duties.

Education and Experience:

  • 4 year Bachelors Degree (Preferred)
  • 5 or more years of experience (Preferred)
  • In lieu of the above education requirements, an equivalent combination of education and experience may be considered.

Certificates, Licenses, Registrations:

  • No Certification, License or Registration is required for the job.

Functional Skills:

  • Advanced database development experience and knowledge with ability to learn new data storage technologies
  • Advanced analytic, data sourcing, and data management skills
  • Proven experience in building relationships and collaborating with various levels of management across a broad-spectrum including HR, Technology, and the business
  • Advanced data management, quality assurance and data stewardship
  • Advanced ability to translate complex technical challenges to both technical and non-technical audiences including a full range of technical and system architectures (SaaS, Security, Hardware)
  • Ability to think strategically and can demonstrate an understanding of the underlying complexities within data strategy
  • Experience with engineering best practices to include analyzing, designing, developing, and deploying and supporting software solutions and/or infrastructure implementations/upgrades.
  • Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
  • Full end-to-end experience in data warehousing, including data modeling, loading, transformation, scripting and process auditing.
  • Proven experience demonstrating strong analytical, logical, problem solving and creative skills


The preceding description is not designed to be a complete list of all duties and responsibilities. May be required to perform other related duties as assigned. Regular, predictable attendance is an essential function of this job.

Compensation offered for this role is$84,500.00-$149,750.00 per yearand is based on experience and qualifications.

Good Hands. Greater Together.

As a Fortune 100 company and industry leader, we provide a competitive salary but thats just the beginning. Our Total Rewards package also offers benefits like tuition assistance, medical and dental insurance, as well as a robust pension and 401(k). Plus, youll have access to a wide variety of programs to help you balance your work and personal life -- including a generous paid time off policy. For a full description of Allstates benefits, visit

Learn more about life at Allstate. Connect with us on Twitter , Facebook , Instagram and LinkedIn or watch a video .


Job Tags

Remote job, Permanent employment, Work from home, Home office,

Similar Jobs

University of Mary

Music Faculty: Choral Director Job at University of Mary

 ...Visiting, Assistant or Associate Professor of Music: Choral Director The University of Mary in Bismarck, ND invites applications for a Visiting, Assistant or Associate Professor of Music to begin fall 2024. The candidate will conduct the University of Mary Concert Choir... 

The 20

IT Support Desk Technician Job at The 20

IT Support Desk TechnicianThe 20 is looking for a hard-working Information...  ...issues~VPN connectivity~Entry-level server support~Hardware issues~...  ...certifications, or equivalent professional experience~1+ year of professional help desk experience~Strong customer... 

Jan-Pro of Kansas City

Janitorial Franchise Business Consultant Job at Jan-Pro of Kansas City

 ...and highly recognized commercial cleaning franchise company with a regional development...  ...and disinfecting franchisees, Certified Business Owners (CBOs), generate and retain business...  ...Description: The Janitorial Franchise Business Consultant's responsibility is to provide daily... 

Monmouth Medical Center

Registered Nurse RN - Psych IP - STCF - Per Diem Job at Monmouth Medical Center

 ...The Registered Nurse provides nursing care in the health care system within the scope of practice defined by the Nurse Practice Act and regulatory standards and assures awareness of ethical standards of practice as defined by the ANA code of ethics, The Registered Nurse... 

Fox Carriers

7 Car Hauler CDL- A Driver Job at Fox Carriers

 ...UA/RU SPEAKING 7-Car Hauler CDL Driver Needed! We speak Ukrainian, Russian and English! Only Nationwide Routes! Driver Qualifications: Clean record only. Experience in car hauling(3+ cars). CDL-A license(could be fresh). Job Details: ~ Weekly...