CYNET SYSTEMS -
442 Jobs
Toronto, ON
Posted yesterday
Job Details:
Full-time
Executive
Job Description:
Data Modeler Requirements:
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.
- 7+ years in data modelling and data warehouse design.
- 2+ years Azure Data Lake and Azure Databricks SQL Warehouse.
- 5+ years SQL.
- Demonstrated experience in creating both Functional Design Documents (FDD) & Detailed Design Documents (DDD).
- Experience in Fit-Gap analysis, system use case reviews, requirements reviews, coding exercises and reviews.
- Experience in the development and maintaining a plan to address contract deliverables, through the identification of significant milestones and expected results with weekly status reporting.
- Work with the Client & Developer(s) assigned to refine/confirm Business Requirements.
- Participate in defect fixing, testing support and development activities for ETL pipelines.
- Assist with defect fixing and testing support for PowerBI reports.
- Analyze and document solution complexity and interdependencies.
- The Architect / Modeler must have previous work experience in conducting Knowledge Transfer and training sessions, ensuring the internal staff receive the required knowledge to support the platform.
- The resource must develop learning activities using review-watch-do methodology & demonstrate the ability to prepare and present.
- Development of documentation and materials as part of a review and knowledge transfer to other members.
- Development of specific activities as part of a review (hand over to ministry staff) and building block approach which, build on knowledge transfer and skills development from the previous stage to the next.
- Development and facilitation of classroom based or virtual instructor demo led sessions for developers.
- Monitor identified milestones and submission of status reports to ensure Knowledge Transfer is fully completed.
Share This Job:
