Job Description

Company: CGIC

Department: Business Intelligence

Employment Type: Regular Full-Time

Work Model: Hybrid

Language: This role operates in English.

Additional Information: This/these role(s) is/are currently vacant




###

The Opportunity:

We are a leading Canadian financial services co-operative committed to being a catalyst for a sustainable and resilient society and our team is essential to deliver on this strategy. That's why we prioritize our people, to ensure we provide a strong culture and development opportunities which enables our team to thrive and to live our purpose. The best part is that you will work with people that care passionately about you, our clients, and our communities.



Our Business Intelligence team empowers decision making using leading edge science and analytics. We strive to deliver a single version of truth, by providing our business partners with access to comprehensive data and valuable insights to help our organization achieve operational excellence.



As an Associate Data Integration Specialist, you will contribute to various initiatives by engineering data solutions for analytic purposes. You will be responsible for providing business value through the creation; maintenance; implementation of back-end data solution (ie. Source System Data Store & Business Data Store) with support from peers.




###

How you will create impact:

Work with data engineering tools: general purpose languages used in data engineering or generally in BI and related framework or interfaces, data querying and data handling and DevOps platforms. Contribute to building data solutions (data models, data pipelines, APIs and more). Help 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 the data solution and follow best practices and standards (no technical debt, automation, scalable solution, incremental load, etc.) with the support of senior resources. Follow design principles based on the solution (ex: REST API) and best practice in terms of data handling (ex: security, governance), the SDLC (ex: unit testing), production code standards and meeting SLAs (ex: low latency responses). Understand the insurance domain (metrics, KPI, key insurance concept), business objectives and how your own tasks contribute to meeting the business objectives.



###

How you will succeed:

You influence change and are committed to continuous improvement, in order to exceed client expectations. You leverage critical thinking skills to identify problems and proactively propose solutions. Your strong communication skills allow you to clearly convey messages. You're an effective team player who shares knowledge to support your peers.



###

To join our team:

You have up to 2 years of experience in the Data Engineering/Integration or other related field. You have a Bachelor's degree in Computer Science or any other relevant field. You have experience solving routine problems using and following existing procedures, guidelines, and standard practices. You have functional knowledge and understanding of data analysis, programming, modeling techniques, data warehouse and data management, research, architecture and design. Experience with following technologies is required: SQL & Relational databases (ex: Azure Synapse / SQL Server), Git (esp. Azure DevOps and GitHub), Microsoft Office (Word, Excel) Experience with following technologies is an asset: Python (ex: Dash, Shiny), or other programming languages (ex: object-oriented), R, Azure DevOps, Atlassian Jira, Databricks, Fabric, Azure Data Factory Having strong and demonstrated skills in the following would be an asset: Analysis, Accountability, Communication/Story-telling and Team work. Proficiency in English is essential to the main duties in this role, including servicing and communicating primarily with majority non-francophone clients, groups, teams. Drafting complex English documents and preparing daily reports for anglophone leaders. The essential non-French duties are not assignable to adjacent or other team members.





###

What you need to know:

You will be subject to a Background check as a condition of employment, in the event you are the successful candidate.



###

What's in it for you?

Training and development opportunities to grow your career. Flexible work options and paid time off to support your personal and family needs. A holistic approach to your well-being, with physical and mental health programs and a supportive workplace culture. Paid volunteer days to give back to your community. * In addition to our competitive salary and incentive programs, eligible employees also benefit from a comprehensive total rewards package including group retirement savings plans, pension and benefits (e.g., health and wellness, dental, disability and life coverage), mental health support and an employee assistance program.