Nortak Software is currently seeking Database Modeller / Information Management Modeller with the following qualifications:
Mandatory Requirements:
Minimum 10 years of experience as a Database Modeller / IM Modeller
Must have successfully completed a post-secondary education program in computer science, information technology (IT), engineering or a scientific discipline with ten (10) years of IT experience or other post-secondary education with fifteen (15) years of IT experience
Must have five (5) years of experience within the last ten (10) years developing dimensional data models, using Ralph Kimball methodology, for an enterprise data warehouse
Must have five (5) years of experience designing and developing the data warehouse architecture and data integration strategies for enterprise data warehouse solutions
Must have five (5) years of experience troubleshooting SQL queries; and conducting database performance tuning
Valid Government of Canada Secret Level II security clearance granted by CSP/PSPC
Rated Criteria:
Experience developing and documenting conceptual, logical and physical data models, including dimensional data models using the Ralph Kimball methodology
Experience gathering data requirements through workshops and interviews with clients, in the context of a business intelligence, data warehouse or analytics project
Experience developing data warehouse and ETL design specifications, including source to target data mappings
Experience working in an environment where the reporting tools used were IBM Cognos and/or Microsoft Power BI, and the data warehouse database is SQL Server, and source data is from an ERP or CRM system
Experience developing data models and entity relationship diagrams using ERwin Data Modeler or an equivalent software tool
Location of Work:
Ottawa / Gatineau (NCR)
To apply for this job opportunity, please email us your updated résumé citing job number MD-FADM-189020N in the subject line.
——————————————————————————————
We would like to thank you for your interest. Please note that all submissions will be assessed, however, only candidates selected for interview will be contacted.
NORTAK SOFTWARE LTD. is a Canadian-owned private corporation with offices in Ottawa and Toronto serving a global client base since 1975.
Nortak is committed to providing equal employment opportunities to all qualified employees and applicants.