Data Modeler

CGI; Ottawa; On-site; CAD 70,000 - 110,000; Full time

Job summary

An established industry player is seeking a skilled data modeler to join their team in Ottawa. This role involves assisting in the creation of conceptual, logical, and physical models for data integration and analytics, ensuring data integrity and performance. You will work closely with Agile Scrum teams, translating business requirements into effective database designs. If you have a knack for problem-solving and thrive in collaborative environments, this opportunity offers a chance to make a significant impact on data-driven projects. Join a forward-thinking company committed to innovation and excellence in data management.

Qualifications

• Proficiency in conceptual, logical, and physical data modeling.
• Experience in Agile Scrum teams for database design.
• Strong problem-solving skills for complex data challenges.

Responsibilities

• Assist with creation of data models for integration and reporting.
• Design and build databases related to data architectures.
• Coordinate activities involving computing and data with teams.

Skills

Data Modeling

J2EE

MS SQL Server

Oracle

English

French

Tools

ER/Studio

ERWin

Liquibase

Flyway

DataStage

Qlik

Tableau

Power BI

Job description

Position Description :

Security clearance : Must be able to meet the requirements for obtaining a reliability level clearance.

Your future duties and responsibilities :

1. Assist with creation of Conceptual / Logical / Physical Models for data integration, analytics, and reporting.
2. Assist with creation of full design view (integration) of data.
3. Participate in model management and version control of data models.
4. Participate in reverse-engineering source system structures for data warehouse sourcing / landing.
5. Help with design of data architectures; translate data so that it can be read by various types of computer systems.
6. Design and build databases used in relation to data architectures.
7. Assist with developing strategies for archive recovery, database implementation, and data acquisition.
8. Maintain databases by restructuring and deleting old data.
9. Create data usage reports to provide to scrum masters.
10. Work with teams and departments to coordinate future activities involving computing and data.
11. Identify areas where policy or procedure changes could support future business expansion.
12. Other related activities and deliverables, as required.

Required qualifications to be successful in this role :

1. Proficiency in conceptual, logical, and physical data modeling. Ability to translate business requirements into comprehensive data models ensuring scalability, performance, and data integrity.
2. Experience working within Agile Scrum teams, translating business requirements into database designs aligned with iterative development cycles.
3. Effective communication and collaboration skills with business analysts, developers, and stakeholders, facilitating requirement gathering and design discussions.
4. Proficiency with data modeling tools (ER/Studio, ERWin) for RDBMS (Oracle, SQL Server) and schema management tools (Liquibase, Flyway).
5. Strong problem-solving skills for addressing complex data modeling challenges, optimizing database structures, and adapting to evolving project needs within a dynamic environment.

Nice to have :

• Knowledge of DevOps practices and implementation.
• Experience with Data Warehouse tools (DataStage, Qlik, Tableau, Power BI).
• Understanding of resiliency requirements such as clustering, failover, and disaster recovery.
• Ability to analyze, assess, and make sound decisions and recommendations.
• Capability to manage multiple responsibilities simultaneously while meeting deadlines.
• Ability to work independently and collaboratively within a team.

LI-KM1

Skills :

• Data Modeling
• English
• J2EE
• MS SQL Server
• Oracle
• French