RQ10622 - Data Architect / Modeller - Senior

Responsibilities :

Develops and implements the data architecture for application development in a complex and distributed environment, including the determination of the flow and distribution of data, the location of databases, and data access methods.

Data Modeler Requirements :

• 7+ years BI Data 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 (e.g. Power BI)
• MS SQL Server Technology, Azure Data Lake, Azure Databricks
• Expert knowledge developing data warehouse solutions on MS Stack (Azure Data Lake, SQL, ADF, Databricks, PowerBI) to store and retrieve centralized information. Experience designing the data warehouse using dimensional and delta lake concepts.
• Create / maintain enterprise data model and data dictionary. Help development team to optimize database performance. Coordinate with the business analysts to identify future needs and requirements.
• Extensive knowledge of data modelling tools (e.g. PowerDesigner, Visio)
• Review, install and configure information systems to ensure functionality and security. Analyze structural requirements for new data warehouse and applications
• Experience using Oracle database server and tools, 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

Skills :

Assets :

Requirements

Experience and Skill Set Requirements :

Must Haves :

Skill Set Requirements :

Design Documentation and Analysis Skills :

BI Data Modelling and Technical Skills :

a. Expert Knowledge of data warehouse design methodologies, delta lake and dimensional modeling in particular

b. Understanding of Extract / Transform / Load processes to transform data for reporting / BI purposes

c. Ability to define schema for reporting databases

d. Experience with advanced modeling tools

Quality Assurance :

Knowledge Transfer :