185 applicants

This job has closed.

Company

Original Job Post

Allstate · 2 days ago

Senior Analyst, Data Engineering

Full-time

Hybrid

Senior Level

3+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

BankingFinance

H1B Sponsorship

Insider Connection @Allstate

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Develop and maintain regular actuarial database for use by other functions of ACG

Implement String matching algorithms in Python to maintain customer data

Implement internal data process improvement: automating manual processes, optimizing data delivery, redesigning/restructuring databases for more efficiency

Support data preprocessing and feature engineering for data science and modeling projects

Develop and maintain databases and build necessary data pipelines for projects and department functions

Identify various manual processes and queries in the Data and BI areas, design and develop ETL Jobs to automate them

Design and implement Data Integration and ETL processes with SSIS packages to make data available for reporting/analytics purpose

Responsible for monitoring and ensuring data quality of the curated data sets using proper reconciliation methods

Design integrated data pipelines to extract large volumes of data from diverse data sources and deliver curated common data layers

Develop and improve SAS/SQL programs to perform various analyses

Analyze change requests in the source systems or projects, assess their impact on existing data layers, and suggest and carry out the appropriate changes

Collaborate with DBAs, other IT teams, Architecture teams, and vendor teams as required

Collaborate with stakeholders to identify needs and opportunities to build reports and dashboards

Design and build an advanced data platform that supports a 360-degree view of the customer and enables customer journey analysis

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

Base sas/egSas macroSqlSsisMs sql serverPythonData wranglingString-matching algorithmsFuzzy matchingHash functionsRegular expressionsData transformationData modelingDimensional modelingNormalizationReferential integrityStar schemasSnowflake schemasAnalytics platformsData lakeData warehouseData martsEtlData governanceSas/sql programmingData cleansingData validationData integrity checksAuditing dataEtl/elt mappings

Required

Bachelor’s degree (Computer Science/Engineering/Math/Stats/Finance or similar) preferred

3-5 years of experience using Base SAS/EG, SAS Macro, SQL, SSIS & MS SQL Server

2-3 years of experience with data wrangling with Python specifically String-matching algorithms such as Fuzzy matching, hash functions and regular expressions

Prior experience in the planning and execution of large-scale critical data transformation and enterprise data hub initiatives

Strong data modeling fundamentals including experience with dimensional modeling, normalization, referential integrity, star, and snowflake schemas, etc.

Experience building and maintaining conceptual, logical, and physical data models for reporting and analytics use cases

Experience with analytics platforms and methodologies (data lake, data warehouse, data marts, ETL, data modelling, data governance, etc.)

Experience in SAS/SQL programming for developing data, cleansing, performing data validation, required data integrity checks, auditing data and improve efficiency of programs

Experience in building ETL/ELT mappings, SSIS packages, data pipelines and Workflows

Strong knowledge of Enterprise automation software packages for data orchestration

Good understanding of SAS administration, maintenance, configuration, performance tuning and support

Experience in troubleshooting performance issues and errors while handling high volume of source data

Ability to articulate ideas in both technical and business friendly language

Proficient in MS Word, Excel, Access, VBA, and PowerPoint

Excellent analytical, problem-solving, and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills

Experience with insurance/actuarial data will be considered a plus

Preferred

Strong knowledge of Tableau and/or other visual analytics tools is preferred

Allstate Canada Group has policies and practices that provide workplace accommodations. If you require accommodation please let us know and we will work with you to meet your needs.

Benefits

Flexible Work Arrangements

Employee discounts (15% on auto and property insurance, plus many other products and services)

Good Office program (receive up to 400$ back after purchasing office equipment)

Student Loan Payment Matching Program for Government Student loans

Comprehensive Retirement Savings Program with employer matched contributions

Annual Wellness allowance to support employees with improving health and wellbeing

Personal reflection day

Tuition Reimbursement

Working within the community and giving back!

Company

Allstate

Glassdoor

3.4

Allstate is an insurance company that offers car, home, and life insurance services. It is a sub-organization of Allstate.

Founded in 1931

Northbrook, Illinois, USA

10,001+ employees

http://www.allstate.com

H1B Sponsorship

Allstate has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Trends of Total Sponsorships

2023 (1)