Job Title

Enterprise Data Integration Developer - Data EngineerLocation: Remote, CanadaEmpire life is looking to hire a Data Integration Developer to join our IT & Data Analytics team!The Enterprise Data Integration Developer will design & develop logical/physical Data Integration solutions (Enterprise Data Warehouse, Data Lake/Business Intelligence solutions) that support business objectives and the enterprises desire to become data-driven. The incumbent is guided by defined procedural constraints, and works under the moderate supervision of the Enterprise Data Integration Solutions Lead and/or Manager of Enterprise Data Services.Why pursue this opportunityThe opportunity - collaborate with cross-functional teams and work on a variety of projects that will keep you engaged and continuously learning.Have your voice heard - with a fresh perspective, we welcome those that can highlight opportunities for improvement. We encourage creative and innovative thinking and welcome candidates who are not afraid to challenge the status quo.Hone your skills - this is an opportunity that allows for you to grow your technical, and functional skills.What youll be working onData and Information are recognized, critical enablers of Empire Lifes strategic and operational objectivesThe Logical Data Warehouse will accept and make accessible internally and externally sourced high-quality, authoritative, structured and unstructured data and information to support a range of business outcomes and decision-making requirementsDevelop an understanding of enterprise and Business Unit near, medium, and long term data and business intelligence needsContribute to the definition of planning and solution development methodologies required to deliver logical data warehousing to support business intelligence capabilitiesContribute to the design of target architectures to meet the long term data and information needs of the enterpriseContribute to the selection and implementation of logical data warehousing technologies required to support the achievement of the target logical data warehouse architectureDesign, develop, test moderately complex to complex ETL processes sourcing data from a variety of internal and external systemsWork closely with the Information Relationship Managers to understand business unit requirements, and assist in their documentationSupport or lead activities relating to end user training, production implementation, transfer of responsibilities to operations, and on-going support of the business intelligence components and solutionsDevelop and maintain expertise in leading data warehouse/business intelligence strategies, trends and technologies within and beyond the financial services industry, basic and intermediate statistical analysis methods, and expertise in business intelligence tool-setsAll other duties as assignedWhat were looking for you to have5+ years of IT experience with data solutions, including; data warehousing, data lake, data modeling, and data analysis. Data migration from on-premise relational database to cloud i.e. Snowflake would be an assetCompletion of a university degree; or equivalent training, education and experience in Computer Science (preferably)Strong knowledge of statistical methods applicable to financial services. Ex: classification, linear regression, clusteringStrong knowledge of database concepts including normalization and data profiling; and the ability to write SQL and understand entity relationship and dimensional model diagramsKnowledge of API and microservices architectureHands on experience with collaboration tools with Attlassan suite (Confluence, JIRA, JIRA Service Manager) being the preferenceHands-on experience with ER Studio or other data modeling toolsHands on experience with a data cataloging tool such as AlationHands-on experience with data profiling and data integration tools (e.g. Informatica Data Quality, Data Cleaner, Pentaho Data Integration, Red etc.)Hands-on experience with enterprise reporting and analysis tools (e.g. Power BI (preference), Spotfire, MS Analysis Services, Tableau, etc.)Hands-on experience with statistical analysis tools (e.g. SAS Data Miner, R, Orange Data Mining, etc.)Hands-on experience with programming languages (e.g. Python, Java, etc.)Hands-on experience with relational databases such as DB2, SQL Server, ProgressHands on experience with cloud database platforms, preferably SnowflakeAgile Software Development and code management experience (e.g. Python,Java, Github, Jira, Confluence)Strong analytical and problem solving skillsAbility to work on multiple projects in a fast paced environmentAble to lead projects with minimal supervisionStrong communication skills both written and oralAbility to work independently and as a team memberIf you are applying for a position which is open to applicants across Canada, unless otherwise indicated in the position, language proficiency in English is required for communicating with customers, advisors, or employees across Canada.Beyond the salaryFor regular full-time positions, Empire Life offers a comprehensive total rewards package that includes:Competitive salaries with annual pay increasesAnnual bonus program, which recognizes both strong company performance and individual contributionsCompetitive uncapped commission for sales positionsA comprehensive employer-funded benefits package that includes life insurance, disability, health and dental and a generous health accountFlexible work arrangements and an annual allotment of personal health days.Four weeks annual vacation from hire dateA defined contribution pension plan with generous employer matchingTop up programs for parental leave and compassionate leaveEmployer-sponsored wellness and recognition programsA cash employee referral programTo learn more about working at Empire Life, visit https://www.empire.ca/workatempire.Get to know usEmpire life is proud to be an equal opportunity employer. We celebrate diversity, are committed to creating an inclusive environment, and welcome everyone to participate in our application process. We encourage those of all backgrounds and experiences to apply, even if you don't believe you meet each unique qualification outlined. Applicants will receive equal consideration without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, disability, or age.Empire Life welcomes applications from people with disabilities and disabled people. Accommodations are available upon request for candidates taking part in all aspects of the screening and selection process. If you need this job posting in an alternative format or have any accessibility questions, please contact recruitment@empire.ca .