Enterprise Data Integration Developer - Data Engineer

Empire Life; Canada; Remote; CAD 65,000 - 123,000; Full time

Job summary

A leading insurance company is seeking an Enterprise Data Integration Developer to join their IT & Data Analytics team. This role involves designing and developing logical data integration solutions to help the company become more data-driven. The ideal candidate will have extensive experience in data warehousing, ETL processes, and a strong background in statistical methods and data analysis.

Benefits

Competitive salary with annual pay increases

Annual bonus program

Employer-funded benefits package

Flexible work arrangements

Four weeks annual vacation

Defined contribution pension plan

Parental and compassionate leave top-up programs

Employee wellness programs

Qualifications

• 5+ years of IT experience with data solutions.
• Strong knowledge of database concepts and SQL.
• Completion of a university degree in Computer Science preferred.

Responsibilities

• Design and develop data integration solutions.
• Collaborate with cross-functional teams on projects.
• Develop ETL processes sourcing data from various systems.

Skills

Data modeling

Data analysis

Data warehousing

ETL development

Statistical methods

SQL

Problem-solving

Communication

Agile development

Technical skills (Python, Java)

Education

University degree in Computer Science

Tools

Power BI

Informatica Data Quality

SQL Server

Snowflake

JIRA

Alation

Job description

Enterprise Data Integration Developer - Data Engineer

Enterprise Data Integration Developer - Data Engineer

Get AI-powered advice on this job and more exclusive features.

This range is provided by Empire Life. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

CA$65,800.00/yr - CA$123,000.00/yr

Direct message the job poster from Empire Life

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 enterprise’s 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 you’ll be working on

• Data and Information are recognized, critical enablers of Empire Life’s 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 we’re 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
• 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 https://www.empire.ca/workatempire.

Get 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 [e-mail] .

Seniority level

• Seniority level

  Mid-Senior level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Information Technology

• Industries

  Insurance

Referrals increase your chances of interviewing at Empire Life by 2x

Sign in to set job alerts for “Data Engineer” roles.

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.