Database Modeller / IM Modeller (MD-FADM-189020N)
November 15, 2021
Ottawa / Gatineau (NCR)
Description: Nortak Software is currently seeking Database Modeller / Information Management Modeller with the following qualifications:
- 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
- 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)
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.
|Job Category||Database Modeller, Database Modeller / IM Modeller, Database Modeller / Information Management Modeller, Information Management Modeller|
|Key Skills||CRM, ERP, ERwin, ERwin Data Modeler, IBM Cognos BI, Microsoft BI, Ralph Kimball methodology|