Database Modeller

**Req ID**: 343644 We are currently seeking a Database Modeller to join our team in Ottawa, Ontario (CA-ON), Canada (CA). We are currently seeking a Database Modeller to join our team in Canada. Position Overview: We require the services of a Data Modeller to support and enhance the Statistical Analysis System (SAS) suite of software processes and custom program code, and to support the transition of their ETL process from SAS 9 to SAS Viya. The Data Modeller/Information Management Modeller will provide support, enhancements, programming and industry knowledge for the various SAS software tools/solutions available. The Data Modeller will update, modify and develop as required existing and new pharmacy, medical supplies and equipment, dental, mental health, vision care and medical transportation data warehouses and ETL processes, as well as perform system maintenance and implement other enhancements as necessary. **Job Description**: - Updating, modifying, enhancing and/or developing new aspects of the current data warehouse(s) of Pharmacy, Medical Supplies and Equipment, Dental, Vision Care and Mental Health and Medical Transportation benefit claims and the ETL processes that load data into the data warehouse(s). - Writing SAS program code, SAS Macros, chron, Python and Linux scripts as required. - Use SAS Data Integration and SAS Studio Flow to perform tasks related to ETL development and maintenance. - Implementing other enhancements as necessary. - Any other elements applicable to the development and maintenance of SAS solution. - Improving performance and scalability. - Developing custom stored processes and macros. - Performing maintenance functions. - 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. Mandatory Qualifications: - 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. Assets/Preferences: - Experience working with big data an asset. - Bilingual in English and French. - Located in the Ottawa/ National Capital Region and able to work hybrid if needed. - Experience working in the Public Sector. " **About NTT DATA