Sr Data Architect

1 week ago


Mississauga ON, Canada Apex Systems Full time

Sr Data Architect Apex Systems is a global IT services provider, and our staffing practice has an opening for a Sr Data Architect with 5+ years’ experience as a DBA/ ETL Developer and or Data Architect with a focus on data modelling, with strong knowledge with PostgreSQL, Snowflake, and data warehousing skills, to place at our client an Enterprise Fleet Management company. Client: Enterprise Fleet Management Company Terms: Permanent Location: 3 days hybrid, Mississauga, ON Application Process: It is best to apply via the medium on which you are seeing this posting. If you encounter technical difficulties submitting your resume, please send a Word version of your resume to dyba@apexsystems.com . Please reference Data Architect Responsibilities:Perform Data Architecture support for projects and enhancements.Craft and execute data management, architecture, integration, and governance strategiesProvide technical leadership for architecture, design, documentation, and maintenance of databases and related systems; creates database storage structures, resolves database issues, and maintains system securitySupport development and implementation of business applications that optimize statistical efficiency and data qualityIdentify, analyze, and interpret trends or patterns in complex data setsReview and approval of daily operational changes where requiredMonitor daily operations of data loads and identify data discrepancies, data quality issues, and work to ensure data consistency and integrityParticipate in project and enhancement estimation exercises and project team meetingsProvide required input, status on tasks, identification of risks and corresponding mitigations as well as issue managementCollaborate with business partners to transform business requirements into environment specific ETL, reporting, and data validation designs; work closely with management to prioritize business and information needsDesign relational databases to support business enterprise applications and physical data modeling according to project requirements for data acquisition and securityCollaborate with internal and external personnel, including system architects, software developers, database administrators, design analysts and information modeling experts to determine project requirements and capabilities, and strategize development and implementation timelinesReview changes to databases to ensure no performance or functionality impactsDevelop architectural strategies for data modeling, design, and implementation to meet stated requirements for metadata management, operational data stores and Extract Transform Load environmentsCollaborate with the Application Development team to analyze, identify, design, and implement processes for sourcing new dataGenerate DDL scripts from data modelling tool and to ensure the script’s proper functionCreate and test physical data models for a variety of business data, applications, database structures and metadata tables to meet operational goals for performance and efficiencySupport database administrators, network designers and IT personnel to create effective and secure methods for data safeguardingReview existing data architectures to determine overall effectiveness and compliance with original objectives, develop comprehensive strategies for improving or replacing underperforming areas and present these plans to managers and executivesResearch new technologies, data modeling methods and information management systems to determine which ones should be incorporated into company data architectures, and develop implementation timelines and milestones Key Qualifications:Bachelor’s degree in data architecture, information management or similar fieldAt least five years of DBA/data development and data architecture experience (combined)Proficient with PostgreSQL, Talend ETL, and SnowflakeProficient in the use of data modeling tools, and producing/maintaining logical and physical designsStrong ETL development knowledge (SSIS, ADF (Azure Data Factory), Boomi or equivalent) and data warehouse architecture techniquesTeam experience, including working closely with business professionals as well as technical resources and acting as a bridge between the two groups including liaison with vendorsExperience in optimizing, loading, and processing large datasets from different data sources and formatsDemonstrates careful attention to quality and accuracy of data and ETL processesCreative problem-solver with strong communication skillsCollect business requirements and develop as well as document data models to satisfy those requirementsAdept at query development, report writing, and presenting findingsNice to Have:Familiar with fundamental Data Governance and security concepts and processesExperience in the Fleet Management business is preferredPostgreSQL/Snowpro (for Snowflake) certifications preferred


  • Sr Data Architect

    2 months ago


    Mississauga, Canada Apex Systems Full time

    Sr Data Architect Apex Systems is a global IT services provider, and our staffing practice has an opening for a Sr Data Architect with 5+ years’ experience as a DBA/ ETL Developer and or Data Architect with a focus on data modelling, with strong knowledge with PostgreSQL, Snowflake, and data wareh

  • Sr Data Architect

    1 week ago


    Mississauga, Canada Apex Systems Full time

    Sr Data Architect Apex Systems is a global IT services provider, and our staffing practice has an opening for a Sr Data Architect with 5+ years’ experience as a DBA/ ETL Developer and or Data Architect with a focus on data modelling, with strong knowledge with PostgreSQL, Snowflake, and data warehousing skills, to place at our client an Enterprise Fleet...

  • Sr Data Architect

    1 week ago


    Mississauga, Canada Apex Systems Full time

    Sr Data Architect Apex Systems is a global IT services provider, and our staffing practice has an opening for a Sr Data Architect with 5+ years’ experience as a DBA/ ETL Developer and or Data Architect with a focus on data modelling, with strong knowledge with PostgreSQL, Snowflake, and data warehousing skills, to place at our client an Enterprise Fleet...

  • Sr Data Architect

    2 months ago


    Mississauga, Canada Apex Systems Full time

    Sr Data Architect Apex Systems is a global IT services provider, and our staffing practice has an opening for a Sr Data Architect with 5+ years’ experience as a DBA/ ETL Developer and or Data Architect with a focus on data modelling, with strong knowledge with PostgreSQL, Snowflake, and data warehousing skills, to place at our client an Enterprise Fleet...

  • Sr Data Architect

    1 week ago


    Mississauga, Canada Apex Systems Full time

    Sr Data Architect Apex Systems is a global IT services provider, and our staffing practice has an opening for a Sr Data Architect with 5+ years’ experience as a DBA/ ETL Developer and or Data Architect with a focus on data modelling, with strong knowledge with PostgreSQL, Snowflake, and data warehousing skills, to place at our client an Enterprise Fleet...

  • Sr Data Architect

    2 weeks ago


    Mississauga, Canada Apex Systems Full time

    Job#: 2035801Job Description:Sr Data ArchitectApex Systems is a global IT services provider, and our staffing practice has an opening for a Sr Data Architect with 5+ years’ experience as a DBA/ ETL Developer and or Data Architect with a focus on data modelling, with strong knowledge with PostgreSQL, Snowflake, and data warehousing skills, to place at our...

  • Sr Data Architect

    2 weeks ago


    Mississauga, Canada Apex Systems Full time

    Job#: 2035801Job Description:Sr Data ArchitectApex Systems is a global IT services provider, and our staffing practice has an opening for a Sr Data Architect with 5+ years’ experience as a DBA/ ETL Developer and or Data Architect with a focus on data modelling, with strong knowledge with PostgreSQL, Snowflake, and data warehousing skills, to place at our...

  • Sr Data Architect

    2 months ago


    Mississauga, Canada Apex Systems Full time

    Job#: 2035801Job Description:Sr Data ArchitectApex Systems is a global IT services provider, and our staffing practice has an opening for a Sr Data Architect with 5+ years’ experience as a DBA/ ETL Developer and or Data Architect with a focus on data modelling, with strong knowledge with PostgreSQL, Snowflake, and data warehousing skills, to place at our...

  • Sr Data Architect

    2 months ago


    Mississauga, Canada Apex Systems Full time

    Job#: 2035801Job Description:Sr Data ArchitectApex Systems is a global IT services provider, and our staffing practice has an opening for a Sr Data Architect with 5+ years’ experience as a DBA/ ETL Developer and or Data Architect with a focus on data modelling, with strong knowledge with PostgreSQL, Snowflake, and data warehousing skills, to place at our...


  • Mississauga, Canada Apex Systems Full time

    Sr Data Architect Apex Systems is a global IT services provider, and our staffing practice has an opening for a Sr Data Architect with 5+ years’ experience as a DBA/ ETL Developer and or Data Architect with a focus on data modelling, with strong knowledge with PostgreSQL, Snowflake, and data ware


  • Mississauga, Canada Apex Systems Full time

    Senior Data Architect Apex Systems is a global IT services provider, and our staffing practice has an opening for a Sr Data Architect with 5+ years’ experience as a DBA/ ETL Developer and or Data Architect with a focus on data modelling, with strong knowledge with PostgreSQL, Snowflake, and data w


  • Mississauga, ON, Canada Apex Systems Full time

    Sr Data Architect Apex Systems is a global IT services provider, and our staffing practice has an opening for a Sr Data Architect with 5+ years’ experience as a DBA/ ETL Developer and or Data Architect with a focus on data modelling, with strong knowledge with PostgreSQL, Snowflake, and data warehousing skills, to place at our client an Enterprise...


  • Toronto, ON, Canada Hays Full time

    Sr Enterprise Architect Client: InsuranceRole: Sr Enterprise ArchitectJob Type: Contract (6 months), may extendLocation: GTA (Hybrid on need basis)Your New CompanyOur client, a very well-known insurance industry client looking to hire a Seasoned Enterprise Architect.Your New Role: We are seeking a seasoned Enterprise Architect to join our Enterprise...


  • Toronto, ON, Canada Pacific Data Integrators Full time

    The Data Engineer will support the client's OCM Self-serve platform. They will be a part of a team with Tech Lead, Business Analyst and a Data Engineer. Technical Operationalizing and maintaining data pipelines deployed to the Client's investment entities and cultivate a business relationship that assists in meeting business demands Deploying ETL/ELT...

  • Senior Data Architect

    2 weeks ago


    Mississauga, Canada Apex Systems Full time

    Senior Data ArchitectApex Systems is a global IT services provider, and our staffing practice has an opening for a Sr Data Architect with 5+ years’ experience as a DBA/ ETL Developer and or Data Architect with a focus on data modelling, with strong knowledge with PostgreSQL, Snowflake, and data warehousing skills, to place at our client an Enterprise Fleet...

  • Senior Data Architect

    2 weeks ago


    Mississauga, Canada Apex Systems Full time

    Senior Data ArchitectApex Systems is a global IT services provider, and our staffing practice has an opening for a Sr Data Architect with 5+ years’ experience as a DBA/ ETL Developer and or Data Architect with a focus on data modelling, with strong knowledge with PostgreSQL, Snowflake, and data warehousing skills, to place at our client an Enterprise Fleet...

  • Senior Data Architect

    2 weeks ago


    Mississauga, Canada Apex Systems Full time

    Senior Data Architect Apex Systems is a global IT services provider, and our staffing practice has an opening for a Sr Data Architect with 5+ years’ experience as a DBA/ ETL Developer and or Data Architect with a focus on data modelling, with strong knowledge with PostgreSQL, Snowflake, and data warehousing skills, to place at our client an Enterprise...

  • IT Data Architect

    2 weeks ago


    Mississauga, ON, Canada Ornge Full time

    DATA ARCHITECT Reference #: 2024-73 Each day, we connect communities with critical care across Ontario, Canada. In the air and by land, our teams deliver equity in emergency response, uplifting the lives of those in our care. We’re excited to onboard individuals who bring energy, enthusiasm, and professionalism to our growing group of...

  • Data Architect

    2 weeks ago


    Mississauga, ON, Canada Ornge Full time

    DATA ARCHITECT Reference #: 2024-73 Strong. Proud. Uplifting. At Ornge, we believe that ordinary people can do extraordinary things. Each day, we connect communities with critical care across Ontario, Canada. In the air and by land, our teams deliver equity in emergency response, uplifting the lives of those in our care. We’re excited to onboard...

  • Architect DevOps Data

    2 weeks ago


    Mississauga, Canada KUBRA Data Transfer Ltd Full time

    p>KUBRA is looking for a Senior Security Architect to join our Information Security team!As a Senior Security Architect, you will be responsible for providing technical guidance and consultation in designing, optimizing & maintaining a secure computing environment, as it relates to application and cloud security. This role will be critical for ensuring that...