Data Architect and Engineer

3 days ago


Toronto, Ontario, Canada Maarut Inc Full time
Job Description:

We are seeking a highly skilled Data Architect and Engineer to join our team at Maarut Inc. As a key member of our data management team, you will be responsible for designing and implementing scalable, secure, and high-performance data architectures on cloud platforms.

About the Role:

  • Design and implement data pipelines using Microsoft Azure technologies such as Azure Data Factory, Azure Databricks, and Azure Synapse Analytics
  • Collaborate with cross-functional teams to develop and maintain data governance policies and procedures
  • Work closely with stakeholders to understand business requirements and develop solutions that meet their needs
  • Implement data security measures to protect sensitive data in transit and at rest
  • Analyze and optimize data processing workflows to improve performance and efficiency
  • Develop and maintain technical documentation to support data architecture designs and implementation
  • Prioritize and manage multiple projects simultaneously to meet tight deadlines

Requirements:

Skill Set Requirements:
  • Cloud DataOps:
    • Expert experience with Microsoft Azure technologies, including Azure Data Factory, Azure Databricks, Azure Synapse Analytics, Azure Storage, Azure Security, and Azure Monitoring
    • Experience with cloud data platforms, data management, and data exchange tools and technologies
    • Experience with data pipeline and workflow development, orchestration, deployment, and automation
    • Experience in DataOps principles, best practices, and implementation and Agile project development and deployment
    • Experience in Continuous Integration/Continuous Development/Deployment (CI/CD) and data provisioning automation
    • Experience with digital product, data analysis, data exchange, data provisioning, and data security
    • Experience with structured, semi-structured, unstructured data collection, ingestion, provisioning, and exchange technological development
    • Experience with DataOps performance monitoring and tuning
    Database Management:
    • Expert data/database administration experience, e.g., Microsoft Azure SQL Database and Synapse Database, Oracle, IMS, DB2, etc.
    • Extensive experience with SQL Server Stored Procedure, Oracle PL/SQL, PL/1 development, and performance tuning
    Data Replication Pipelines:
    • Experience with Azure SQL, Oracle, IMS/DB2 data replication

Deliverables:

  • Participate in the review of project, work request, and maintenance release artifacts - use case, system requirement specification, etc.
  • Deliver detailed system design documents and any other supporting documentation conforming to Ministry standards.
  • Design, develop, and optimize data/database CI/CD pipelines.
  • Design logical and physical data models using Sybase Power Designer.
  • Prepare database change in DACPAC and develop Azure CI/CD release pipeline to promote DACPAC.
  • Promote database changes through Development, Integration Testing, QA, UAT, Production environments.
  • Provision data in cloud environment according to requirements.
  • Design, develop data loading, data conversion, data migration program.
  • Design, develop, and implement data conversation of VLD (Very Large Data) of Online Analytical Processing (OLAP) and Online Transaction Processing (OLTP) environments to Cloud Software-as-a-service (SaaS), Platform-as-a-service (PaaS), and Infrastructure-as-a-service (IaaS) environments.
  • Design, develop, and implement fact/dimension model, data mapping, data warehouse, data lake, and data lakehouse.
  • Plan, configure, maintain, administer, tune performance of Oracle, Microsoft Azure SQL Database, and Synapse Database.
  • Support cloud-based heterogeneous data replication solution.
  • Develop complex Oracle PL/SQL program, SQL Server stored procedure to fulfill project, work request, maintenance requirements.
  • Optimize performance of PL/SQL program, SQL Server stored procedure.
  • Monitor and analyze incident, provide timely resolution.
  • Perform reference data administration as required.
  • Build and test database backup/recovery scripts.
  • Build and test database automation scripts.
  • Perform database administration, including patching/upgrade, monitoring, performance tuning, partitioning, capacity planning, OEM upgrade/enhancement, achieving, etc.
  • Document and resolve any database problems/issues.
  • Provide effective knowledge transfer to Ministry staff at all stages of this assignment.

Estimated Salary: $120,000 - $180,000 per year, depending on qualifications and experience.


  • Data Architect

    2 months ago


    Toronto, Ontario, Canada Scotiabank Full time

    Job DescriptionRequisition ID: 205977Key Team Member, committed to results, in an inclusive and high-performing culture.The Global Wealth Engineering (GWE) team within Scotiabank is seeking an experienced Data Engineer with deep expertise in Google Cloud Platform (GCP) to join our growing team.In this role, you will be responsible for designing, building,...

  • Data Engineer

    3 days ago


    Toronto, Ontario, Canada Tata Consultancy Services Full time

    About Tata Consultancy ServicesTata Consultancy Services is a leading IT services company with over 55 years of experience in partnering with top businesses worldwide. Our consulting-led, cognitive-powered portfolio includes business, technology, and engineering services that are delivered through our unique Location Independent Agile model.With a workforce...


  • Toronto, Ontario, Canada Atlan Full time

    At Atlan, we are on a mission to revolutionize the way data teams work together. We believe that by providing a seamless and intuitive platform for data discovery and collaboration, we can help organizations unlock the full potential of their data.We are seeking a highly skilled Strategic Data Architect to join our team. As a Strategic Data Architect, you...


  • Toronto, Ontario, Canada CorGTA Full time

    Job Title: Senior Cloud Data ArchitectAbout the Role:We are seeking an experienced Senior Cloud Data Architect to join our team at CorGTA, a Fortune 1000 company based in Toronto. As a key member of our data engineering team, you will be responsible for designing and implementing scalable cloud-based data solutions using GCP Google Cloud Platform. The ideal...


  • Toronto, Ontario, Canada S.i. Systèmes Full time

    About the RoleWe are seeking a highly skilled Data Architect to join our team at S.i. Systèmes. As a Data Architect, you will play a crucial role in designing and implementing effective ETL (Extract, Transform, Load) visualizations of solutions using Python, Power BI, and ETL tools.Key ResponsibilitiesDesign and implement data pipelines to ensure efficient...


  • Toronto, Ontario, Canada Scotiabank Full time

    Cloud Data Engineer PositionWe are seeking a highly skilled Data Engineer to join our team at Scotiabank. This is a hybrid role that requires both technical expertise and collaboration with stakeholders.About the RoleThe successful candidate will design, build, and maintain scalable data architectures that support our data-driven initiatives using Google...

  • Data Architect Lead

    20 hours ago


    Toronto, Ontario, Canada Personal Branding Full time

    We are seeking a seasoned Data Architect Lead to join our team in Toronto, ON. The ideal candidate will have 10+ years of experience in data engineering and a strong background in Java, big data tools, and relational SQL databases.The salary for this role is approximately $175,000 per annum, based on industry standards and the cost of living in Toronto.In...


  • Toronto, Ontario, Canada Quantum World Technologies Inc. Full time

    Job Title: Senior Cloud Data ArchitectAbout the Role:We are seeking a highly experienced Senior Cloud Data Architect to join our team at Quantum World Technologies Inc. As a key member of our data engineering team, you will be responsible for designing, implementing, and maintaining large-scale cloud-based data platforms.Key Responsibilities:Design and...


  • Toronto, Ontario, Canada Royal Bank of Canada Full time

    Royal Bank of Canada seeks a highly skilled Data Platform Architect to join their dynamic team. As a key member of the data engineering team, you will play a crucial role in designing and implementing robust data infrastructure to support the organization's data needs.Job DescriptionThis is an opportunity within the Data & Analytics team at RBC Global Asset...


  • Toronto, Ontario, Canada Saragossa Full time

    Saragossa is at the forefront of technology and data analytics, driving innovation in the financial sector. As a Data Platform Architect, you will be part of their data & analytics team where you will work with cutting-edge tools and platforms.You will play a crucial role in the development and implementation of their data platform. In this role, you will...


  • Toronto, Ontario, Canada Tata Consultancy Services Full time

    Tata Consultancy Services: A Leader in IT ServicesWe are seeking a Senior Cloud Data Architect to join our team at Tata Consultancy Services. This is an exceptional opportunity for a highly skilled professional to work on cutting-edge projects and contribute to the growth of our organization.About Us:Tata Consultancy Services is a leading global IT services,...


  • Toronto, Ontario, Canada Intact Full time

    Unlock a dynamic career with Intact as an Enterprise Data Solutions Architect. About UsWe're a leading insurance provider dedicated to helping people, businesses, and society prosper in good times and be resilient in bad times.Job DescriptionOur Enterprise Architecture team is seeking a highly skilled Senior Data Solution Architect to lead the design and...


  • Toronto, Ontario, Canada CorGTA Full time

    **Job Overview:**We are seeking a highly experienced Senior Cloud Data Architect to join our team at CorGTA. This is a contract position working with one of our Fortune 1000 clients in Toronto, ON.**Salary Estimate:** CAD $140,000 - $180,000 per year (based on industry standards and the cost of living in Toronto).Key Responsibilities:The successful candidate...


  • Greater Toronto Area, Canada, Ontario OpsGuru Full time

    OpsGuru is a global engineering and consulting group. We are experts in the container ecosystem, data processing and analytics, and cloud-native technologies. Our team is formed by network, data, security, DevOps specialists, and application developers. OpsGuru empowers customers with technology to solve their business problems and provides the tools to...


  • Toronto, Ontario, Canada Scotiabank Full time

    Job OverviewWe are seeking an experienced Senior Cloud Data Engineering Lead to join our team at Scotiabank in Toronto, Canada.Salary: $175,000 - $225,000 per yearAbout the RoleThis is a leadership position that requires strong technical expertise and business acumen. As a Senior Cloud Data Engineering Lead, you will be responsible for designing, building,...

  • Chief Data Architect

    2 weeks ago


    Toronto, Ontario, Canada Rubicon Path Full time

    Rubicon Path is seeking a skilled Information Architect to join our team. This role will involve designing and developing data models to support corporate architecture requirements, enhancing business information/data model to align with business/system requirements for OASIS, and providing professional information architecture expertise.About the RoleThis...


  • Toronto, Ontario, Canada Hire IT People, Inc Full time

    About UsHire IT People, Inc is a leading provider of innovative technology solutions for the banking industry.Job SummaryWe are seeking an experienced Senior Data Architect to design and develop data pipelines, catalogues, and ETL processes for our Banking client. The ideal candidate will have a strong background in data engineering, experience with ETL...

  • Data Architect

    6 days ago


    Toronto, Ontario, C6A, Ontario, Canada Lorven Technologies Inc. Full time

    We are currently looking for a strong Data Architect for our client in Toronto (Hybrid). Please find the detail description below. Kindly let me know your interest. Job Title: Data Architect Location: Toronto (Hybrid) Duration: Long term ResponsibilitiesManage timelines/deliverables within the team towards the successful delivery of projects.Design software...


  • Toronto, Ontario, Canada NearSource Full time

    About UsNearSource Technologies is a multinational Fortune 500 company based in Canada, driving innovation and upholding high technological standards.Salary RangeThe estimated annual salary for this position is $120,000 - $180,000 CAD, depending on experience.Job DescriptionWe are seeking a Senior Analytics Developer to join our dynamic team. As a key member...


  • Toronto, Ontario, Canada Tata Consultancy Services Full time

    About Tata Consultancy ServicesTata Consultancy Services is a global leader in IT services, consulting, and business solutions. With over 55 years of experience, we have partnered with many of the world's largest businesses in their transformation journeys.Our consulting-led, cognitive-powered portfolio of business, technology, and engineering services and...