Data Modeler Requirements:
7+ years BI Solution Architect experience in enterprise applications and solutions design/development and related with data warehousing, data lake implementations and dimensional modelling.
Collect business-level questions and propose approaches to address business needs and provide data insights.
Expand documentation and knowledge of business processes relative to available data to provide contextual guidance for operation/project, reporting and insights generation.
Ability to design and articulate complex technical concepts into executable development work packages.
Knowledge of BI tools for metadata modeling and report design(Cognos and/or Power BI)
MS SQL Server Technology, Azure SQL Database or Synapse, Azure Datalake
Expert knowledge developing Datawarehouse solutions to store and retrieve centralized information. Experience designing the data warehouse using dimensional and data vault concepts.
Create/maintain enterprise data model and data dictionary. Help development team to optimize database performance. Coordinate with the Integration department to identify future needs and requirements.
Review, install and configure information systems to ensure functionality and security. Analyze structural requirements for new Datawarehouse and applications
Experience using Oracle database server and tools (12c, 19c), PL/SQL for development of Business Intelligence applications.
Demonstrated skills in writing SQL stored procedures and packages for datamarts and reporting.
Demonstrated experience in Azure DevOps
Demonstrated experience in performance tuning of Business Intelligence applications, including data model and schema optimization
Assets:
Knowledge of Curam IBM Social Management Platform
ETL design concepts
Knowledge of Enterprise Architecture tools and frameworks (ArchiMate, TOGAF, Zachmann)
Job Type: Fixed term contract
Contract length: 3 months
Salary: Up to $80.00 per hour
Flexible Language Requirement:
• French not required
Schedule:
• Monday to Friday
Experience:
• Azure Databricks: 5 years (required)
• R: 5 years (required)
• Python: 5 years (required)
Work Location: Hybrid remote in Toronto, ON M5V 3A4
Application deadline: 2024-01-02
Expected start date: 2024-01-18
