Data Modeler

2 weeks ago

Halifax, Canada CGI Full time

CGI is offering an exciting opportunity as a Data Modeler in a digital environment. As a senior member of CGI’s national data 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.

As the data modeler, 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.

**Key Responsibilities**:

- Understand and translate business needs into data models supporting long-term solutions
- 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
- Design the migration of existing ON PREM Datawarehouse / legacy data solution to Azure.
- Design Gateways for bridging ON PREM and Azure Databases.
- 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
- Design and development of SQL Server Datawarehouse and DataMart
- Performance enhancement of existing Datawarehouse for faster data retrieval by the reporting tools.

**Must Have Requirements**:

- Minimum 10+ years of experience in Information Technology and 7+ years of Data Modeling experience.
- Demonstrated experience in designing and developing complex SQL Server Data warehousing solutions
- Demonstrated Experience in BI, ETL (SSIS), Data Warehousing, ODS Data Marts, and performance tuning methods.
- Proven track record of experience in data modeling and evaluating data from multiple sources, reconciling conflicts, decomposing high-level data into details as well as taking details and bringing to a higher level for general communication.
- Experience with data profiling, cleansing, and conforming rules.
- Demonstrated experience developing, validating, publishing, maintaining LOGICAL and PHYSICAL data models
- Demonstrated experience using common data modeling tools and technologies
- Demonstrated experience in developing, publishing, and maintaining all documentation for data models
- Demonstrated experience working with the De-Normalized/OLAP systems is mandatory
- Demonstrated experience with tools such as Erwin or ER-Studio
- Good understanding of the OLTP/Transactional/3NF Data Modelling concepts is needed
- Demonstrated experience with designing and building different types of Transactional, Periodic Snapshot and Accumulating snapshot Fact tables
- Demonstrated experience with designing Dimension tables including population of Slowly Changing Dimensions
- Demonstrated experience with gracefully extending the current Data warehouse artifacts
- Demonstrated experience with documenting the Data warehouse tables using Enterprise Business Matrix

**Nice to Have Requirements**:

- Strong experience with MS SQL Server, MySQL databases is preferred.
- Exposure to AWS & Azure Cloud based technologies is highly preferred
- Knowledge of emerging modeling techniques and experience in physical data modeling for relational and NoSQL/unstructured databases.
- 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 modeled data in the financial domain
- Experience designing BI solutions using Microsoft technology solutions: SQL Server SSAS, SSRS & Power BI

**Required Level of Education**:

- Bachelor’s Degree in a Computer Science or related technical discipline, or the equivalent combination of education, technical certifications or training, or work experience

Position is based in Halifax, Nova Scotia. Must have authorization to work in Canada.
-

  • Financial Modeler

    5 days ago

    Halifax, Canada Natural Forces Solar Full time

    **Employment Opportunity Natural Forces** **Financial Modeler**: - ____________________________________________ Natural Forces is a leading Canadian clean energy developer that delivers projects in partnership with Indigenous Communities and Nations, CEDCs, Municipalities and other local communities across Canada, US and Ireland. Natural Forces is an asset...

  • SQL Dba Advisor

    2 weeks ago

    Halifax, Canada NTT DATA Full time

    **Job Description**: - 8+years of experience managing MS SQL Servers and Azure SQL database and/or related infrastructure preferred - Experience in TDE configuration - Able to handle all SQL Database DBA related daily maintenance tasks. - Good exposure in Database and SQL Performance Tuning. - Experience in Database/SQL Performance Tuning. - Create logical...

  • Data Scientist

    4 days ago

    Halifax, Canada X.J solutions Full time

    We are looking to hire a highly creative data scientist to address data analytics challenges in our organization, to collect large volumes of data from varying sources, clean and interpret data, create solutions to overcome challenges, and communicate with interested parties. **Data Scientist Responsibilities**: - Having meetings with team members...

  • Data Analyst

    5 days ago

    Halifax, Canada Virtusa Full time

    **Data Analyst position skills requirement**: - Knowledge of Tableau reporting (intermediate level) - Knowledge of TSQL (intermediate level) - Data analysis and exploration (intermediate level) - Statistical knowledge, data modeling - Presentation competence, clear writing and communication (intermediate level) **Data Analyst Job Description**: - Work...

  • Data Analyst

    4 days ago

    Halifax, Canada PSA Halifax Full time

    **PSA Halifax **is recruiting for a Data Analyst. This position offers an exciting opportunity to be part of a highly successful and leading container terminal in the East Coast of Canada. The position offers a competitive salary with annual performance-based incentives, medical benefits for individual and family, contributive pension benefits, and...

  • Big Data Engineer, Data Services, GFT

    Found in: beBee jobs CA - 7 days ago

    Halifax, Nova Scotia, Canada Royal Bank of Canada Full time

    Job SummarySupports the development and maintenance of scalable data stores that supply big data in forms needed for business analysis. Applies experience and seasoned knowledge, skills, and practices to perform a variety of assignments.Job DescriptionWHAT IS THE OPPORTUNITY? Global Functions Technology has a transformational agenda, and we thrive on the...

  • Big Data Engineer, Data Services, GFT

    Found in: beBee S CA - 2 weeks ago

    HALIFAX, Canada Royal Bank of Canada Full time

    Job SummarySupports the development and maintenance of scalable data stores that supply big data in forms needed for business analysis. Applies experience and seasoned knowledge, skills, and practices to perform a variety of assignments.Job DescriptionWHAT IS THE OPPORTUNITY? Global Functions Technology has a transformational agenda, and we thrive on the...

  • Big Data Engineer, Data Services, GFT

    Found in: beBee S CA - 4 days ago

    HALIFAX, Canada Royal Bank of Canada Full time

    Job SummarySupports the development and maintenance of scalable data stores that supply big data in forms needed for business analysis. Applies experience and seasoned knowledge, skills, and practices to perform a variety of assignments.Job DescriptionWHAT IS THE OPPORTUNITY? Global Functions Technology has a transformational agenda, and we thrive on the...

  • Financial Data Analyst

    5 days ago

    Halifax, Canada Bulletproof Solutions Full time

    **Who We Are**: Headquartered in Canada with locations across the United States and around the globe with a footprint on six continents, Bulletproof, a GLI company has decades of technology, security, and compliance expertise. Bulletproof’s work in the security space has been recognized nationally and globally with Microsoft’s global Security Partner of...

  • Big Data Engineer, Data Services, Gft

    Found in: beBee S CA - 3 days ago

    Halifax, Canada RBC - Royal Bank Full time

    Job SummarySupports the development and maintenance of scalable data stores that supply big data in forms needed for business analysis. Applies experience and seasoned knowledge, skills, and practices to perform a variety of assignments.Job DescriptionWHAT IS THE OPPORTUNITY? Global Functions Technology has a transformational agenda, and we thrive on the...

  • Big Data Engineer, Data Services, Gft

    Found in: beBee S CA - 1 week ago

    Halifax, Canada RBC - Royal Bank Full time

    Job SummarySupports the development and maintenance of scalable data stores that supply big data in forms needed for business analysis. Applies experience and seasoned knowledge, skills, and practices to perform a variety of assignments.Job DescriptionWHAT IS THE OPPORTUNITY? Global Functions Technology has a transformational agenda, and we thrive on the...

  • Data Manager, Strategy and Acquisition

    Found in: Talent CA C2 - 2 weeks ago

    Halifax, Canada CMHC Full time

    Job Requisition ID: 10055 Position Status:  Permanent Full Time  Position Type:  Hybrid Office Location:  Montreal (QC); Calgary (AB); Halifax (NS); Ottawa (ON); Toronto (ON); Vancouver (BC) Travel Requirement:  Limited  Language Designation:  English Essential  Language Skill Levels (Read/Write/Speak):  ZZZ  Salary:  Our...

  • Master Data Governance

    5 days ago

    Halifax, Canada IBM Full time

    **Introduction** **Your Role and Responsibilities** IBM's state-of-the-art Client Innovation Centre (CIC) opened in Nova Scotia in March 2013 and is the first of its kind in Canada. The Centre weaves together IBM’s business insights and industry-leading software portfolio and is ideally suited for any client that needs flexible access to emerging or niche...

  • Data Entry Clerk

    Found in: beBee jobs CA - 2 weeks ago

    Halifax, Nova Scotia, Canada Irving Oil Full time

    As a Data Entry Clerk, you will work closely with our drivers and dispatchers in preparing, verifying, editing and reconciling all liquid inventory such as diesel, gasoline, propane and furnace oil. Your goal will be to provide a strong attention to detail and numbers. Your success will depend on your ability to be self-motivated and in the accomplishments...

  • Big Data Engineer, Data Services, GFT

    Found in: Talent CA C2 - 4 days ago

    Halifax Regional Municipality, Canada Royal Bank of Canada> Full time

    Job SummarySupports the development and maintenance of scalable data stores that supply big data in forms needed for business analysis. Applies experience and seasoned knowledge, skills, and practices to perform a variety of assignments.Job DescriptionWHAT IS THE OPPORTUNITY? Global Functions Technology has a transformational agenda, and we thrive on the...

  • Machine Learning Engineer

    Found in: Whatjobs CA C2 - 1 week ago

    Halifax, Canada Prodigy Labs a UST Company Full time

    We are looking for a Machine Learning Engineer to join our team to help build systems that accelerate the development and deployment of machine learning models, especially large language models (LLMs). You will partner closely with Machine Learning researchers and internal users to understand requirements and apply your own domain expertise to build high...

  • Machine Learning Engineer

    Found in: Appcast CA A2 P - 1 week ago

    Halifax, Canada Prodigy Labs a UST Company Full time

    We are looking for a Machine Learning Engineer to join our team to help build systems that accelerate the development and deployment of machine learning models, especially large language models (LLMs). You will partner closely with Machine Learning researchers and internal users to understand requirements and apply your own domain expertise to build high...

  • Machine Learning Engineer

    Found in: Appcast CA C2 Glassdoor - 1 week ago

    Halifax, Canada Prodigy Labs a UST Company Full time

    We are looking for a Machine Learning Engineer to join our team to help build systems that accelerate the development and deployment of machine learning models, especially large language models (LLMs). You will partner closely with Machine Learning researchers and internal users to understand requirements and apply your own domain expertise to build high...

  • Thoughtspot BI Lead

    20 hours ago

    Halifax, Canada AlphaForce Technology Solutions Full time

    **Role: ThoughtSpot BI Lead** **Location: Canada Ontario or Halifax** - 7+ years experience in BI design & development, at least 2 years using ThoughtSpot suite of tools - Strong experience in Design, building and deploying BI solutions using ThoughtSpot and associated suite of technologies - Experience BI integration with Azure data platform stack - Strong...

  • Tourism Research Analyst

    4 days ago

    Halifax, Canada Discover Halifax Full time

    **Tourism Research Analyst** Halifax, Nova Scotia **About Discover Halifax** Discover Halifax is the regional destination marketing organization responsible for the growth of the visitor economy in Halifax, Nova Scotia. Established in 2002, it promotes Halifax as a year-round destination for both business and leisure travelers. Governed by an independent...