Impress employers and recruiters.
Choose from hundreds of resume examples.

Impress employers and recruiters.
Choose from hundreds of resume examples.

Target Resume Now

About the Role

As a Data Integration Specialist, you will autonomously contribute to various initiatives by engineering data solutions for analytics purposes. You will be responsible for providing business value through the creation, maintenance, and implementation of back-end data solutions (e.g., Source System Data Store & Business Data Store) through the full software development lifecycle.

Responsibilities

• Execute data extraction, cleaning, reconciliation, and preparation processes for analytics solutions.
• Understand data requirements and complete simple analysis to assess data characteristics.
• Work with data engineering tools, general purpose languages, BI frameworks, data querying, data handling, and DevOps platforms.
• Assess data quality and build automated controls.
• Build data solutions including data models, data pipelines, and APIs.
• Develop analytic solutions to solve business problems by understanding the role of data in reporting, metrics, predictive models, and other analytic solutions within the BI Environment.
• Deliver production-ready code by assessing data solutions and following best practices and standards.
• Apply design principles based on the solution and best practices in terms of data handling, SDLC, production code standards, and meeting SLAs.
• Understand the insurance domain, business objectives, and how tasks contribute to meeting business objectives.

Requirements

• 3-5 years of experience in Data Engineering/Integration or other relevant field.
• Experience solving standard problems by analyzing possible solutions using experience, judgment, and precedent.
• Experience challenging the status quo.
• Good knowledge and understanding of data analysis, programming, modeling techniques, data warehouse and data management, research, architecture, and design.
• Experience with SQL and Relational databases (Azure Synapse / SQL Server).
• Experience with Git (Azure DevOps and GitHub).
• Experience with Microsoft Office (Word, Excel).
• Subject to a Background check as a condition of employment.

Skills

• Innovative mindset
• Ability to influence change
• Critical thinking skills
• Strong communication skills
• Ability to build trusting relationships
• Ability to provide guidance
• Data extraction
• Data cleaning
• Data reconciliation
• Data preparation
• Data requirements analysis
• Data quality assessment
• Automated controls building
• Data modeling
• Data pipeline development
• API development
• Analytic solution development
• SDLC best practices
• Unit testing
• Production code standards
• Low latency response
• Data handling best practices
• Data security
• Data governance
• Insurance domain knowledge
• SQL
• Relational databases
• Azure Synapse
• SQL Server
• Git
• Azure DevOps
• GitHub
• Microsoft Office
• Word
• Excel
• Databricks
• Python
• ADLS
• Power BI
• Feature Store
• R
• Shiny app

Location

• Canada

Work Type

• Hybrid
• Regular Full-Time

Experience Level

• 3-5 years

Education Level

• Bachelor’s degree in Computer Science or other relevant field

Salary/Compensations

• $69,660.00 to $116,100.00 CAD

Benefits

• Training and development opportunities
• Flexible work options
• Paid time off
• Physical and mental health programs
• Supportive workplace culture
• Paid volunteer days
• Competitive salary
• Incentive programs
• Comprehensive total rewards package
• Group retirement savings plans
• Pension
• Health and wellness benefits
• Dental coverage
• Disability coverage
• Life coverage
• Mental health support
• Employee assistance program

About the Company

• CGIC is a leading Canadian financial services co-operative committed to being a catalyst for a sustainable and resilient society.
• The Business Intelligence team empowers decision making using leading edge science and analytics.
• The team strives to deliver a single version of truth by providing business partners with access to comprehensive data and valuable insights to help the organization achieve operational excellence.

Equal Opportunity

• Proficiency in both English and French is essential to the main duties in this role, including servicing and communicating primarily with majority anglophone and francophone clients, groups, and teams. The essential non-French duties are not assignable to adjacent or other team members.