Senior Database Developer

CGI is offering an exciting opportunity as a Senior Database Developer with a strong background in Data Modelling. As a senior member of CGI’s 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 the 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 have 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 Senior Database Developer, you will lead the activities associated with designing, developing and enhancing a multi-layer data storage and access solution. Your knowledge of data modelling, data profiling, data analysis and database 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 working on 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 work on a team that is eager to collaborate and propel data-centric solutions, this is definitely an opportunity is for you.

Key Responsibilities:

  • 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 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 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 others on available data-driven capabilities as well as limitations, performance requirements and associated interfaces
  • Design and development of SQL Server Datawarehouse and DataMart
  • Performance enhancement of existing Datawarehouse for faster data retrieval by the reporting tools.
  • Design the migration of existing ON PREM Datawarehouse solution to Azure.
  • Design Gateways for bridging ON PREM and Azure Databases.

Must-Have Requirements:

  • Demonstrated experience in designing and developing complex SQL Server Data warehousing solutions
  • Demonstrated experience in designing and developing Azure Databases.
  • Demonstrated experience in designing and developing SSIS based ETL solutions
  • Demonstrated experience developing, validating, publishing, maintaining LOGICAL and PHYSICAL data models
  • Evaluate existing data models and physical databases for variances and discrepancies
  • 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 modelling 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
  • 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 practices
  • Experience working with dimensionally modelled data in the financial domain
  • Experience designing BI solutions using Microsoft technology solutions: SQL Server SSAS, SSRS & Power BI