SENIOR ANALYST, DATA ENGINEERING

Contenuto del lavoro

Who Is Allstate

Allstate Insurance Company of Canada is a leading home and auto insurer focused on providing its customers prevention and protection products and services for every stage of life. The company is proud to have been named a Best Employer in Canada for nine consecutive years and prioritizes supporting employees and fostering an inclusive, welcoming corporate culture. Allstate is committed to making a positive difference in the communities in which it operates through partnerships with charitable organizations, employee giving and volunteerism. Serving Canadians since 1953, Allstate strives to provide reassurance with its "You’re in Good Hands®" promise.

Through our Employee Value Proposition, Opportunity, Flexibility, Community, Diversity and Family, we have worked hard to develop and nurture a culture where employees feel valued, experience personal growth, have career options and truly enjoy the work they do.

Role Designation: Hybrid 1-2 Days in Office

Benefits To Joining Allstate

• 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!

Job Description

Our team is growing and we are actively looking to hire Senior Analyst, Data Engineering to join our team! Reporting to the Manager, Data Engineering, you will be providing key technical expertise to acquire, investigate, manipulate, and analyze data and report to support Allstate Canada Group’s business plans and results.

Accountabilities

• Develop and maintain regular actuarial data base 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, redesign/restructure database 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 volume of data from diverse data sources and deliver curated common data layers
• Develop and improve SAS/SQL programs to perform various analysis.
• 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 advanced data platform that supports 360-degree view of the customer and enable customer journey analysis

Qualifications

• 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 and 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
• Proficient in MS Word, Excel, Access, VBA, and PowerPoint

Bonus Qualifications:

• Strong knowledge of Tableau and/or other visual analytics tools is preferred
• Experience with insurance/actuarial data will be considered a plus

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.