Enterprise Data Integration Developer - Data Engineer Location: Remote, Canada Empire 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 opportunity The 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 on Data and Information are recognized, critical enablers of Empire Lifes strategic and operational objectives The 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 requirements Develop an understanding of enterprise and Business Unit near, medium, and long term data and business intelligence needs Contribute to the definition of planning and solution development methodologies required to deliver logical data warehousing to support business intelligence capabilities Contribute to the design of target architectures to meet the long term data and information needs of the enterprise Contribute to the selection and implementation of logical data warehousing technologies required to support the achievement of the target logical data warehouse architecture Design, develop, test moderately complex to complex ETL processes sourcing data from a variety of internal and external systems Work closely with the Information Relationship Managers to understand business unit requirements, and assist in their documentation Support 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 solutions Develop 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-sets All other duties as assigned What were looking for you to have 5+ 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 asset Completion 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, clustering Strong knowledge of database concepts including normalization and data profiling; and the ability to write SQL and understand entity relationship and dimensional model diagrams Knowledge of API and microservices architecture Hands on experience with collaboration tools with Attlassan suite (Confluence, JIRA, JIRA Service Manager) being the preference Hands-on experience with ER Studio or other data modeling tools Hands on experience with a data cataloging tool such as Alation Hands-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, Progress Hands on experience with cloud database platforms, preferably Snowflake Agile Software Development and code management experience (e.g. Python,Java, Github, Jira, Confluence) Strong analytical and problem solving skills Ability to work on multiple projects in a fast paced environment Able to lead projects with minimal supervision Strong communication skills both written and oral Ability to work independently and as a team member If 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 salary For regular full-time positions, Empire Life offers a comprehensive total rewards package that includes: Competitive salaries with annual pay increases Annual bonus program, which recognizes both strong company performance and individual contributions Competitive uncapped commission for sales positions A comprehensive employer-funded benefits package that includes life insurance, disability, health and dental and a generous health account Flexible work arrangements and an annual allotment of personal health days. Four weeks annual vacation from hire date A defined contribution pension plan with generous employer matching Top up programs for parental leave and compassionate leave Employer-sponsored wellness and recognition programs A cash employee referral program To learn more about working at Empire Life, visit to know us Empire 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 .
Job Title
Enterprise Data Integration Developer - Data Engineer