People Analytics Data Engineer - Lead Consultant

People Analytics Data Engineer - Lead Consultant

The world isn’t standing still, and neither is Allstate. We’re moving quickly, looking across our businesses and brands and taking bold steps to better serve customers’ evolving needs. That’s why now is an exciting time to join our team. You’ll have opportunities to take risks, challenge the status quo and shape the future for the greater good.

You’ll 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 life’s uncertainties so they can realize their hopes and dreams. For more than 89 years we’ve thrived by staying a step ahead of whatever’s 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. We’ve been an industry leader in pricing sophistication, telematics, digital photo claims and, more recently, device and identity protection.

We are the Good Hands. We don’t 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 year and is based on experience and qualifications.

Good Hands. Greater Together. ℠

As a Fortune 100 company and industry leader, we provide a competitive salary – but that’s 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, you’ll 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 Allstate’s benefits, visit

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


Logos/outerjoin logo full

Outer Join is the premier job board for remote jobs in data science, analytics, and engineering.