RQ07229 - Senior- Data Architect/Modeller - Toronto, Việt Nam - Modis

    Modis
    Modis Toronto, Việt Nam

    1 tháng trước

    Default job background
    TEMPORARY
    Mô tả

    Ontario Government Client is actively seeking a Data Architect/Modeler. As a Data Architect/Modeler, where is your expertise in design documentation, BI data modeling, and quality assurance. This role entails collaborating with stakeholders, refining business requirements, and facilitating knowledge transfer sessions. Technical expertise in tools like PowerBI and SQL Server, along with meticulous attention to detail, ensures effective project execution and continuous support.

    Note: The candidate is present on-site for three days each week.

    Evaluation Criteria:

  • Design Documentation and Analysis Skills:
  • Proficient in creating Functional Design Documents (FDD) & Detailed Design Documents (DDD).
  • Experience in Fit-Gap analysis, system use case reviews, and requirements reviews.
  • Ability to develop and maintain a plan for contract deliverables with weekly status reporting.
  • Collaboration with the Client & Developer(s) to refine Business Requirements.
  • Participation in defect fixing, testing support, and development activities for ETL pipelines.
  • Analysis and documentation of solution complexity and interdependencies.
  • BI Data Modeling and Technical Skills:
  • Expertise in Data Modeling for Business Intelligence, including dimensional modeling.
  • Understanding of Extract/Transform/Load processes and schema definition for reporting databases.
  • Proficiency in BI tools such as PowerBI, Cognos, and advanced modeling tools.
  • Knowledge and experience in MS SQL Server technology, Azure Databricks SQL Warehouse, and Azure Data Lake.
  • Skills in T-SQL, PL/SQL for BI applications development.
  • Experience in performance tuning of BI applications and data model optimization.
  • Quality Assurance:
  • Demonstrated experience in defining and executing tests across the development lifecycle.
  • Utilization of test results to refine database design.
  • Knowledge Transfer:
  • Previous experience in conducting Knowledge Transfer and training sessions.
  • Development of learning activities and materials for effective knowledge transfer.
  • Facilitation of instructor-led sessions for developers.
  • Monitoring milestones and submission of status reports to ensure complete Knowledge Transfer.