Sr. Data Architect/Modeler
4 weeks ago
Location: Toronto, ON (Hybrid)
Duration: days contract with the possibility of extension.
Job Description:
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 Provides a standard common business vocabulary, expresses strategic data requirements, outlines high level integrated designs to meet these requirements, and aligns with the enterprise strategy and related business architecture General Skills: Knowledge and experience in information resource management tools and techniques Experience with at least two different platforms, operating systems, environments, database technologies, languages and communications protocols Knowledge of performance considerations for different database designs in different environments Experience in structured methodologies for the design, development and implementation of applications Experience in systems analysis and design in large or medium systems environments Experience in the use of Computer Aided Software Engineering (CASE) tools for the development and documentation of data architectures and detailed data models Experience in the use of data modelling methods and tools ( ERWIN, VISIO, PowerDesigner) including a working knowledge of metadata structures, repository functions, and data dictionaries Knowledge and experience in the use of information retrieval packages Awareness of emerging I&IT trends and directions Experience in monitoring and enforcing data modelling/normalization standards Experience in developing enterprise architecture deliverables ( models) Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills A team player with a track record for meeting deadlines Desirable Skills: Experience with middleware and gateways Experience in designing/developing an automated data distribution mechanism Knowledge and understanding of object-oriented analysis and design techniques. Experience in developing enterprise architecture deliverables ( models) based on Ontario Government Enterprise Architecture processes and practice Knowledge and understanding of Information Management principles, concepts, policies and practices Experience creating detailed data standards to enable integration with other systems Experience reviewing conceptual, logical and physical data models for quality and adherence to standards Knowledge and understanding of dimensional and relational data models Knowledge and experience in information resource management tools and techniques.
Data Modeler Requirements: + 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 Customer 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 (c, c), 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) Evaluation Criteria:
BI Data Modelling ( points)
Understanding of Data Modelling for Business Intelligence including: Understanding of data warehouse design methodologies, data vault and dimensional modeling in particular Understanding of Extract/Transform/Load processes to transform data for reporting/BI purposes Ability to define schema for reporting databases Experience with advanced modeling tools, Knowledge of BI tools for metadata modeling and report design Cognos / PowerBI Design Documentation and Analysis Skills ( points) 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 Informatica/ETL tool. Assist with defect fixing and testing support for Cognos reports. Analyze and document solution complexity and interdependencies Technical Skills ( points) Experience using Oracle database server and tools (c, c), PL/SQL for development of Business Intelligence applications. Demonstrated skills in writing SQL stored procedures and packages for datamarts and reporting. Demonstrated experience in performance tuning of Business Intelligence applications, including data model and schema optimization Quality Assurance ( points) Demonstrated experience in defining and executing tests across the development lifecycle (unit testing, system testing, user acceptance testing) and using results to refine database design Knowledge Transfer ( points) The Architect / Modeller must have previous work experience in conducting Knowledge Transfer and training sessions, ensuring the resources will receive the required knowledge to support the system. 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
-
Sr Project Architect
2 days ago
Toronto, Canada HOK Full timeHOK designs buildings and spaces that respond to the needs ofpeople and the environment. Our designers are rooted in technical excellence,driven by imagination and focused on a solitary goal: to deliver solutions thatinspire clients and communities. We are currently seeking a Sr Project Architect to join our team. As a Sr Project Architect, you, in...
-
Data Modeler
5 days ago
Toronto, Canada spruceinfotech Full timeJob DescriptionData ModelerToronto/Montreal- 3 days/week Mandatory: Erwin, Data Vault 2.0• Designing and implementing data modeling solutions using relational, dimensional, and NoSQL databases. Working closely with data architects, they develop bespoke databases utilizing a mixture of conceptual, physical, and logical...
-
Data Modeler
4 days ago
Toronto, Canada spruceinfotech Full time**Company Description** Spruce InfoTech is a leading information technology firm that provides varied services to help clients change manage and transform their businesses by means of high quality, innovative and cost effective solutions. We provide services to different companies from small scale level to even fortune 500 organizations and guide them in the...
-
Data Architect Modeler 5782
4 weeks ago
Toronto, Canada Foilcon Full timeGeneral ResponsibilitiesReview business requirements, familiarize with and understand business rules and transactional data modelDefine conceptual, logical model and physical model mapping from data source to curated model and data mart.a) Analyze requirements and recommend changes to the physical model.b) Develop scripts for the physical model, create...
-
Data Architect/Modeller
4 weeks ago
Toronto, Canada Global Pharma Tek Full timePosition: Data Architect/Modeller - Senior Location: Toronto, ON Duration: Months Contract Job Description: Technical Skills: Experience creating physical database designs and operates and experience administering database management systems (DBMS) including database optimization, capacity planning, installation and migration, database...
-
Data Architect
2 weeks ago
Toronto, Canada Trinity Infotech Inc. Full timePosition: Data Architect Location: Toronto, ON (Hybrid onsite from day 1) Duration: Contract Mandatory Skills: AWS Glue, Kafka, Redshift/Postgres, RDBMS/Datawarehousing Primary Skills: Power BI, REST APIs Relevant experience: Overall 10+ years of experience in SAP data management, data quality assurance, data extraction from legacy systems. Detailed...
-
Data Architect
2 weeks ago
Toronto, Canada Trinity Infotech Inc. Full timePosition: Data Architect Location: Toronto, ON (Hybrid onsite from day 1) Duration: Contract Mandatory Skills: AWS Glue, Kafka, Redshift/Postgres, RDBMS/Datawarehousing Primary Skills: Power BI, REST APIs Relevant experience: Overall 10+ years of experience in SAP data management, data quality assurance, data extraction from legacy systems. Detailed...
-
Data Architect
2 weeks ago
Toronto, Canada Trinity Infotech Inc. Full timePosition: Data Architect Location: Toronto, ON (Hybrid onsite from day 1) Duration: Contract Mandatory Skills: AWS Glue, Kafka, Redshift/Postgres, RDBMS/Datawarehousing Primary Skills: Power BI, REST APIs Relevant experience: Overall 10+ years of experience in SAP data management, data quality assurance, data extraction from legacy systems. Detailed...
-
Data Architect
1 week ago
Toronto, Canada Trinity Infotech Inc. Full timePosition: Data ArchitectLocation: Toronto, ON (Hybrid onsite from day 1) Duration: ContractMandatory Skills:AWS Glue, Kafka, Redshift/Postgres, RDBMS/Datawarehousing Primary Skills:Power BI, REST APIsRelevant experience:Overall 10+ years of experience in SAP data management, data quality assurance, data extraction from legacy systems.Detailed JD: Hands-on...
-
Data Architect
2 weeks ago
Toronto, Canada Trinity Infotech Inc. Full timePosition: Data Architect Location: Toronto, ON (Hybrid onsite from day 1) Duration: ContractMandatory Skills:AWS Glue, Kafka, Redshift/Postgres, RDBMS/Datawarehousing Primary Skills:Power BI, REST APIsRelevant experience:Overall 10+ years of experience in SAP data management, data quality assurance, data extraction from legacy systems.Detailed JD: Hands-on...
-
Data Architect
4 weeks ago
Toronto, Canada hireVouch Full timeData ArchitectAbout Us: We're committed to leveraging data to drive insights, innovation, and strategic decision-making. As a Data Architect, you'll play a pivotal role in shaping our (and our clients) data infrastructure and ensuring the integrity, efficiency, and accessibility of our data assets.Job Description:As a Data Architect, you will be responsible...
-
Data Architect
2 weeks ago
Toronto, Canada Trinity Infotech Inc. Full timePosition: Data ArchitectLocation: Toronto, ON (Hybrid onsite from day 1)Duration: Contract Mandatory Skills: AWS Glue, Kafka, Redshift/Postgres, RDBMS/Datawarehousing Primary Skills: Power BI, REST APIs Relevant experience: Overall 10+ years of experience in SAP data management, data quality assurance, data extraction from legacy systems. Detailed...
-
Data Architect
2 weeks ago
Toronto, Canada Trinity Infotech Inc. Full timePosition: Data ArchitectLocation: Toronto, ON (Hybrid onsite from day 1)Duration: Contract Mandatory Skills: AWS Glue, Kafka, Redshift/Postgres, RDBMS/Datawarehousing Primary Skills: Power BI, REST APIs Relevant experience: Overall 10+ years of experience in SAP data management, data quality assurance, data extraction from legacy systems. Detailed...
-
Data Architect
1 month ago
Toronto, Ontario, Canada Project X Full timeRole SummaryAs a Data Architect at Project X Ltd., you will be providing our clients with your knowledge and experience in making sense of messy, unstructured data. The Data Architect will be responsible for designing, implementing, and overseeing end-to-end solutions that address designing scalable and efficient data solutions, and complex business...
-
Data Architect
3 days ago
Toronto, Canada Net2source Inc. Full timeJob Title: Data ArchitectLocation: Toronto, ON (Hybrid onsite from day 1) Type: ContractPRIMARY SKILL: AWS Glue, Kafka, Redshift/Postgres, RDBMS/Data warehousing SECONDARY SKILL: Power BI, REST APIs Relevant experience: Overall 10+ years of experience in SAP data management, data quality assurance, data extraction from legacy systems.Detailed JD:Hands-on...
-
Data Architect
3 days ago
Toronto, Canada Trinity Infotech Inc. Full timePosition: Data ArchitectLocation: Toronto, ON (Hybrid onsite from day 1)Duration: Contract Mandatory Skills: AWS Glue, Kafka, Redshift/Postgres, RDBMS/Datawarehousing Primary Skills: Power BI, REST APIs Relevant experience: Overall 10+ years of experience in SAP data management, data quality assurance, data extraction from legacy systems. Detailed...
-
Data Architect
2 weeks ago
Toronto, Canada Trinity Infotech Inc. Full timePosition: Data ArchitectLocation: Toronto, ON (Hybrid onsite from day 1)Duration: Contract Mandatory Skills: AWS Glue, Kafka, Redshift/Postgres, RDBMS/Datawarehousing Primary Skills: Power BI, REST APIs Relevant experience: Overall 10+ years of experience in SAP data management, data quality assurance, data extraction from legacy systems. Detailed...
-
Data Architect
2 weeks ago
Toronto, Canada Trinity Infotech Inc. Full timePosition: Data Architect Location: Toronto, ON (Hybrid onsite from day 1) Duration: Contract Mandatory Skills: AWS Glue, Kafka, Redshift/Postgres, RDBMS/Datawarehousing Primary Skills: Power BI, REST APIs Relevant experience: Overall 10+ years of experience in SAP data management, data quality assurance, data extraction from legacy systems. ...
-
Data Architect
2 weeks ago
Toronto, Canada Trinity Infotech Inc. Full timePosition: Data ArchitectLocation: Toronto, ON (Hybrid onsite from day 1)Duration: Contract Mandatory Skills: AWS Glue, Kafka, Redshift/Postgres, RDBMS/Datawarehousing Primary Skills: Power BI, REST APIs Relevant experience: Overall 10+ years of experience in SAP data management, data quality assurance, data extraction from legacy systems. Detailed...
-
Mulesoft Architect/Sr. Developer
7 days ago
Toronto, Canada Cloud SynApps Inc. Full timeCompany Description Cloud SynApps Inc. is a Systems Integration firm that focuses on Cloud-based digital solutions built on Salesforce and its ecosystem partners. Role Description This is a full-time hybrid role for a Mulesoft Architect/Sr. Developer at Cloud SynApps Inc. located in Toronto, ON, with flexibility for some remote work. The Mulesoft...
