Data Architect/Modeller

4 weeks ago

Toronto, Canada Global Pharma Tek Full time
Position: 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 design, performance tuning, backup and recovery
Experience cloud environments especially Azure
Extensive hands on experience in Azure SQL Database experience, proficiency in T-SQL, understanding of SQL maintenance and audit, user and permissions management, performance management and tuning
Hands on experience with the following technologies, certifications are an asset: Azure Data Factories, Databricks, Azure Synapse, Azure SQL, Cosmos DB, Oracle DBMS, along with Big Data/Data Lake/Hadoop experience
Hands on experience with SSIS, SSRS, Talend, Informatica etc.
Hands on experience working with NoSQL databases and formats (JSON, xml)

Experience:
Experience in one or more programming languages
Experience with custom build cloud development and microservices based architecture
Experience with data migrations
Experience in the use of information retrieval packages and proficiency with query languages
Experience in monitoring and enforcing database rules
Experience in Incident, Change and Configuration Management procedures
Experience with one or more communications protocols
Experience with distributed data systems
Experience with middleware and gateways
Experience with researching and implementing cyber security vulnerability remediation
Knowledge and understanding of Information Management principles, concepts, policies and practices
Extensive experience in production Database Administration, Maintenance Optimization
Subject matter expert in database design of the data warehouse or data marts.
Experience and expert knowledge in technology and/or application required including installation, configuration, maintenance, upgrade (technology stack) and cloning
Experience in designing/developing an automated data distribution mechanisms
Knowledge and understanding of object-oriented analysis and design techniques.
Experience in developing enterprise architecture deliverables ( models) based
Knowledge and understanding of Information Management principles, concepts, policies and practices
Experience in impact analysis, implementation planning and implementation of technology or suite specific patches, maintenance packs and releases, and technology stack patch sets and releases
Experience in technical design, planning and implementation of specific technology or suite
Experience with database administration and working with vendors

Must Haves:
Extensive hands on experience in Azure SQL Database experience, proficiency in T-SQL, understanding of SQL maintenance and audit, user and permissions management, performance management and tuning
Hands on experience with the following technologies, certifications are an asset: Azure Data Factories, Databricks, Azure Synapse, Azure SQL, Cosmos DB, Oracle DBMS, along with Big Data/Data Lake/Hadoop experience
Oracle experience is an asset

  • Sr. Data Architect/Modeler

    4 weeks ago

    Toronto, Canada Global Pharma Tek Full time

    Position: Sr. Data Architect/Modeler 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,...

  • Data Modeler

    5 days ago

    Toronto, Canada spruceinfotech Full time

    Job 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 time

    General 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

    2 weeks ago

    Toronto, Canada Trinity Infotech Inc. Full time

    Position: 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 time

    Position: 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 time

    Position: 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 time

    Position: 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 time

    Position: 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 time

    Data 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 time

    Position: 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 time

    Position: 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 time

    Role 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 time

    Job 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

    2 weeks ago

    Toronto, Canada Trinity Infotech Inc. Full time

    Position: 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

    3 days ago

    Toronto, Canada Trinity Infotech Inc. Full time

    Position: 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 time

    Position: 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 time

    Position: 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

    1 week ago

    Toronto, Ontario, Ontario, Canada Trinity Infotech Inc. Full time

    Position: 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, ON, Canada Trinity Infotech Inc. Full time

    Position: 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. ...