Analyst, Data Engineering (12-Month Contract)

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: HybridThis is a 12-month contract position.Job description:Our team is growing, and we are actively looking to hire an Analyst, Data Engineering to join our team! Reporting to the Manager, Data Engineering & Automation, you will be providing key technical expertise to acquire, investigate, manipulate, and analyze data and report to support Allstate Canada Group (ACG)'s business plans and results.Accountabilities:Develop and maintain actuarial data base and various curated data layers for use by other functions of ACGImplement internal data process improvement, automating manual processes, optimizing data delivery, redesign/restructure database for more efficiencyDesign and build integrated data pipelines to extract large volume of data from diverse data sources and deliver curated common data layersSupport data preprocessing and feature engineering for data science and modeling projectsIdentify various manual processes and queries in the Data and BI areas, design and develop ETL Jobs to automate them.Responsible for monitoring and ensuring data quality of the curated data sets using proper reconciliation methodsAnalyze change requests in the source systems or projects, assess their impact on existing data layers, and suggest and carry out the appropriate changesDevelop and maintain databases and data systems necessary for projects and department functions.Develop and improve SAS/SQL programs to perform various analysis.Generate periodic and ad hoc reports.Collaborate with stakeholders to identify needs and opportunities to build reports and dashboards.Qualifications:Bachelor's degree (Computer Science/Engineering/Math/Stats/Finance or similar) preferred2-3 years of experience using Base SAS/EG, SAS Macro, SQL, SSIS & MS SQL ServerExperience in SAS programming for developing data, performing data validation, auditing data and improve efficiency of SAS programsExperience in building ETL/ELT mappings, SSIS packages data pipelines and WorkflowsStrong knowledge of data modeling, data management, ETL Design, Development, and data warehousing.Strong knowledge of Enterprise automation software packages for data orchestrationExperience in troubleshooting performance issues and errors while handling high volume source data.Proficient in MS Word, Excel, Access, VBA and PowerPointAbility to articulate ideas in both technical and user-friendly languageExcellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skillsSound knowledge of relational database structureBonus qualification:Strong knowledge of Tableau and/or other visual analytics tools is preferredExperience with insurance/actuarial data will be considered a plusExperience with data wrangling with PythonAllstate 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. Insurance,Banking,Financial Services