Database Modeller at NTT DATA

Ottawa, Ontario, Canada -

Full Time

Start Date

Immediate

Expiry Date

16 Jan, 26

Salary

0.0

Posted On

18 Oct, 25

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Database Modelling, Data Warehousing, ETL Processes, SAS Viya, SAS 9.4, SAS Software, Data Integration Studio, SAS Studio, Star Schema, SAS Programs, SAS Macros, Python Programming, Linux Commands, Chron Scheduling, Federal Security Clearance, Bilingual

Industry

IT Services and IT Consulting

Description

Implementing other enhancements as necessary. Developing custom stored processes and macros. Providing advice and supporting migration to SAS Viya from SAS 9. Monthly status reports, summarizing daily activities, identifying the duration and providing a high-level description of activities are to be provided. Formal written documentation of the completed underlying data structure and computer program code for all work completed. 6+ years experience as a Database Modeller, Data Modeller or Information Management Modeller. 5+ years experience delivering projects that develop or enhance ETL processes for data loads exceeding one (1) Million rows. 5+ years experience delivering projects that develop or enhance a Data Warehouse with a fact table of at least one hundred (100) Million rows. 5+ years experience working on a project with SAS Viya or SAS 9.4, where the project must include work to develop, modify, enhance or maintain a Data Warehouse. 5+ years experience working on a project that includes implementing ETL processes using SAS software with preference given to those experienced with Data Integration Studio and/or SAS Studio. 5+ years experience working in the development and maintenance of Data Warehouses with a star schema containing both dimension and fact tables linked via primary and foreign keys. 5+ years experience writing SAS programs, writing SAS macros, writing Python programs, issuing Linux commands and scheduling tasks with chron. Must have a Federal Security Clearance at Reliability level. Must have a Canadian university degree or college/CEGEP diploma related to computer science, information technology, or engineering or the equivalent as established by a recognized Canadian academic credentials assessment service. A copy of the degree or diploma must be provided upon request. Bilingual in English and French. Located in the Ottawa/ National Capital Region and able to work hybrid if needed. "

Responsibilities

The role involves implementing enhancements, developing custom stored processes and macros, and supporting migration to SAS Viya. Monthly status reports and formal documentation of completed work are also required.