• Lead Data Modeller Jobs in Canada

  • CGI Information Systems and Management Consultants Pvt Ltd
  • Canada

Job Description:

Lead Data Modeller Category Development/Engineering

City Halifax, Nova Scotia, Canada

Position ID J0719-0259

Employment Type Full Time

Position Description CGI is offering an exciting opportunity as a Lead Data Modeller As a senior member of CGIs national practice providing retail banking solutions and services to credit unions, you will be joining an experienced and dynamic team of global IT professionals serving our clients across Canada and the world

The financial industry is in the midst of dramatic change and credit unions are challenged with finding faster, more innovative ways of providing solutions and services to their customers who have more alternatives than ever before Digital transformation and digital services are disrupting traditional financial institutions, instead offering businesses and households access to services that are customized specifically to personalized needs and wants of the end consumer Omni-channel experience, mobile self-service, predictive analytics, data governance, robotic process automation, FinTech partnerships, and open banking requirements have turned the banking industry on its head Staying relevant is key while customer retention and growth has never been more challenging Our clients are turning to CGI to help them remodel their operations and assist in navigating through the massive digital transformational changes required to remain competitive

As the Lead Data Modeller, you will lead the activities associated with designing, implementing and enhancing a multi-layer data storage and access solution Your knowledge of database design and development as well as your agile delivery experience will be leveraged to assist with enabling and enriching our strategic data services roadmap In addition to leading a small team of dedicated IT professionals, you will collaborate directly with the CGI management team and progressive clients Your passion for researching new data-centric technologies and tools, ability to articulate the pros and cons of various data modelling concepts, and your proficiency for designing and developing data solutions will be relied upon to promote success throughout our journey

If you are searching for a role that allows you to apply your data modelling knowledge and expertise in an exciting environment and lead a team that is eager to collaborate and propel data-centric solutions, this is definitely opportunity is for you

Key Responsibilities

Lead a data solutions team using agile development principles

Understand and translate business needs into data models supporting long-term solutions

Work with the overall application development team to implement new data strategies, build data flows and develop conceptual data models

Design and creation of ETL process from disparate data sources

Create logical and physical data models using best practices to ensure high data quality and reduced redundancy

Optimize and update logical and physical data models to support new and existing projects

Maintain conceptual, logical and physical data models along with corresponding metadata

Develop best practices for standard naming conventions and coding practices to ensure consistency of data models

Recommend opportunities for reuse of data models in new environments

Design and implement a centralized data security and access control using windows active directory

Perform reverse engineering of physical data models from databases and SQL scripts

Evaluate data models and physical databases for variances and discrepancies

Analyze data-related system integration challenges and propose appropriate solutions

Guide your team members and other on available data driven capabilities as well as limitations, performance requirements and associated interfaces

Must Have Requirements

Demonstrated experience leading a team of database developers and business analysts

Demonstrated experience developing, validating, publishing, maintaining LOGICAL and PHYSICAL data models

Evaluate existing data models and physical databases for variances and discrepancies

Experience working with dimensionally modeled data in the financial domain

Ability to discuss tactical solutions and their relationship to logical data models with business clients

Ability to work with clients to generate use case scenarios based on user requirements

Demonstrated experience using common data modeling tools and technologies

Demonstrated experience in developing, publishing, and maintaining all documentation for data models

Ability to validate business use cases for accuracy and completeness of proposed data models

Experience designing BI solutions using Microsoft technology solutions SQL Server SSAS, SSIS,SSRS & Power BI

Ability to produce the data dictionary and database support documentation

Ability to clearly communicate complex technical ideas, regardless of the technical capacity of the audience

Demonstrated knowledge of agile development principles and bi-modal delivery models

Demonstrated commitment to continuous learning

Senior level coaching and mentoring capabilities

Senior level consulting, communication and presentation skills

Excellent relationship building and negotiation skills

Demonstrated knowledge of digital services, associated technologies and concepts, and industry trends

Nice to Have Requirements

Knowledge and experience working specifically in the retail banking and/or credit union space

Knowledge of data governance principles and best practises

Skills Data Analysis
Data Modeling
ETL
Data Warehousing
Mentoring/Coaching
Data Cleansing

What you can expect from us Build your career with us

It is an extraordinary time to be in business As digital transformation continues to accelerate, CGI is at the center of this changesupporting our clients digital journeys and offering our professionals exciting career opportunities

At CGI, our success comes from the talent and commitment of our professionals As one team, we share the challenges and rewards that come from growing our company, which reinforces our culture of ownership All of our professionals benefit from the value we collectively create

Be part of building one of the largest independent technology and business services firms in the world

Learn more about CGI at wwwcgicom

No unsolicited agency referrals please

CGI is an equal opportunity employer In addition, CGI is committed to providing accommodations for people with disabilities in accordance with provincial legislation Please let us know if you require a reasonable accommodation due to a disability during any aspect of the recruitment process and we will work with you to address your needs

Have you been referred by a CGI Member for this position* Yes No

CGI members email (cgicom)*

First Name

Last Name

I agree to allow CGI to contact the CGI member who referred me to obtain additional information about my application and to confirm my referral *

* This field is required

Profile Summary:

Employment Type : Full Time
Eligibility : Any Graduate
Industry : Software Services
Functional Area : IT Software : Software Products & Services
Role : Data Warehousing
Salary : As per Industry Standards
Deadline : 20th Feb 2020

Key Skills:

Company Profile:

Company
CGI Information Systems and Management Consultants Pvt Ltdarfix

Salary trends based on over 1 crore profiles

View Salaries

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status