Data Engineer (hybrid)

At Allstate, great things happen when our people work together to protect families and their belongings from lifes uncertainties. And for more than 90 years our innovative drive has kept us a step ahead of our customers evolving needs. From advocating for seat belts, air bags and graduated driving laws, to being an industry leader in pricing sophistication, telematics, and, more recently, device and identity protection. Your role in the team The People Analytics Data Engineer This experienced consultant is responsible for supporting the design and development of data infrastructure and engineering projects for human capital data for People Analytics and the enterprise. This role will contribute to the development, to 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. Key Responsibilities Create and maintain technical documentation such as ERD, information models, flow diagrams, data dictionaries, etc., as well as document data/system contents, concepts, and mapping between data assets and systems. Translate complex technical challenges to both technical and non-technical audiences including a full range of technical and system architectures (SaaS, Security, Hardware) Actively supporting designs, architect, analyze, develops and implements key data and support of architecture and warehousing approaches. Support the build and execute ETL processes from multiple, disparate data sources such as flat files, web services/APIs, databases, etc. Create and maintain technical documents to Support the data solutions in the creation of insightful reports and analyses. Assist in monitoring and consults on existing metrics, analyze data, and partner with other data teams to identify and implement system and process improvements. As an experienced team member, collaborate with 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 experienced professional in data engineering and applying best practices. Essential Skills All applicants must demonstrate they have a legal right to work in the UK for employment at Allstate. Allstate is not providing sponsorship for this vacancy. Database development experience and knowledge with ability to learn new data storage technologies Working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases. Working knowledge of Python or other programming language Hands-on experience with ETL tools such as PySpark, SSIS or similar. Experience in data warehousing, including data modeling, loading, transformation, scripting and process auditing. Experience with engineering best practices to include analyzing, designing, developing, and deploying and supporting software solutions and/or infrastructure implementations/upgrades. Experience in building relationships and collaborating with various levels of management across a broad-spectrum including HR, Technology, and the business Desirable Skills Experience with cloud platforms such as Azure/Fabric, AWS, GCP, etc., for data storage, services, and processing. Familiarity with data modeling tools such as Erwin or equivalent. Working knowledge of HR systems (e.g., Workday, VMS, etc). Experience working with workforce data. Hands-on experience developing and maintaining reports/dashboards in PowerBI and Tableau. Supervisory Responsibilities This job does not have supervisory duties Joining our team isnt just a job its an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. And one where you can impact the future for the greater good. Youll do all this in a flexible environment that embraces connection and belonging. And with the recognition of several inclusivity and diversity awards, weve proven that Allstate empowers everyone to lead, drive change and give back where they work and live. Good Hands. Greater Together. What we offer As Digital DNAs Workplace of the Year 2020 & 2022 winners, we offer a generous benefits package that includes flexible annual leave entitlement, dental and healthcare insurance, an attractive pension package and discounts on gym memberships, public transport and parking. Allstate invests heavily in your development, as an employee you will have access to multiple world-class learning platforms and courses from our award-winning in-house Learning & Development team. We pride ourselves in providing clear career paths and opportunities for internal mobility allowing you to further develop within the organisation. We encourage a better work life balance and youll have the opportunity to apply for various flexible working arrangements. Statement on Fair Employment and Equal Opportunities Allstate NI wishes to ensure equal opportunity is given to all job applicants. This company will not discriminate on the grounds of race, gender (including gender reassignment status), sexual orientation, religious belief, political opinion, marital status, age or disability. We are an equal opportunities employer. We welcome applications from all suitably qualified persons. However, as women are currently under-represented in our workforce, we would particularly welcome applications from women. All appointments will be made on merit. Applicants should note Allstate NI complete AccessNI background checks on all candidates offered a position. Skills: ETL SQL Python Data Warehousing Cloud Platforms