Jobs
>
Mississauga

    Senior Data Architect - Mississauga, Canada - Apex Systems

    Apex Systems
    Apex Systems Mississauga, Canada

    1 week ago

    Default job background
    Description

    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 Ashley at Please reference Data Architect

    Responsibilities:

    • Perform Data Architecture support for projects and enhancements.
    • Craft and execute data management, architecture, integration, and governance strategies
    • Provide technical leadership for architecture, design, documentation, and maintenance of databases and related systems; creates database storage structures, resolves database issues, and maintains system security
    • Support development and implementation of business applications that optimize statistical efficiency and data quality
    • Identify, analyze, and interpret trends or patterns in complex data sets
    • Review and approval of daily operational changes where required
    • Monitor daily operations of data loads and identify data discrepancies, data quality issues, and work to ensure data consistency and integrity
    • Participate in project and enhancement estimation exercises and project team meetings
    • Provide required input, status on tasks, identification of risks and corresponding mitigations as well as issue management
    • Collaborate 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 needs
    • Design relational databases to support business enterprise applications and physical data modeling according to project requirements for data acquisition and security
    • Collaborate 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 timelines
    • Review changes to databases to ensure no performance or functionality impacts
    • Develop architectural strategies for data modeling, design, and implementation to meet stated requirements for metadata management, operational data stores and Extract Transform Load environments
    • Collaborate with the Application Development team to analyze, identify, design, and implement processes for sourcing new data
    • Generate DDL scripts from data modelling tool and to ensure the script's proper function
    • Create and test physical data models for a variety of business data, applications, database structures and metadata tables to meet operational goals for performance and efficiency
    • Support database administrators, network designers and IT personnel to create effective and secure methods for data safeguarding
    • Review 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 executives
    • Research 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 field
    • At least five years of DBA/data development and data architecture experience (combined)
    • Proficient with PostgreSQL, Talend ETL, and Snowflake
    • Proficient in the use of data modeling tools, and producing/maintaining logical and physical designs
    • Strong ETL development knowledge (SSIS, ADF (Azure Data Factory), Boomi or equivalent) and data warehouse architecture techniques
    • Team experience, including working closely with business professionals as well as technical resources and acting as a bridge between the two groups including liaison with vendors
    • Experience in optimizing, loading, and processing large datasets from different data sources and formats
    • Demonstrates careful attention to quality and accuracy of data and ETL processes
    • Creative problem-solver with strong communication skills
    • Collect business requirements and develop as well as document data models to satisfy those requirements
    • Adept at query development, report writing, and presenting findings

    Nice to Have:

    • Familiar with fundamental Data Governance and security concepts and processes
    • Experience in the Fleet Management business is preferred
    • PostgreSQL/Snowpro (for Snowflake) certifications preferred

    Interview Process: We are working directly with the hiring manager on this position. Interviews will take place the week of 04/29.

    This a great opportunity to join a large enterprise insurance firm, who has been recognized as a top employer and join a value led organization where you can bring your passion and ambition to the forefront.

    EEO Employer

    Apex is an Equal Employment Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, age, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by law. Apex will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable law. If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation in using our website for a search or application, please contact our Employee Services Department at or

  • goeasy Ltd.

    Data Architect

    4 days ago

    goeasy Ltd. Mississauga, Canada

    Embark on a journey with one of Canada's fastest growing companies – welcome to goeasy We have been honored with recognitions such as Waterstone Canada's Most Admired Corporate Cultures , the 2022 Report on Business Women Lead Here , Report on Business for Canada's Top Growing ...

  • goeasy

    Data Architect

    5 days ago

    goeasy Mississauga, Canada Full time

    Embark on a journey with one of Canada's fastest growing companies – welcome to goeasy We have been honored with recognitions such as Waterstone Canada's Most Admired Corporate Cultures, the 2022 Report on Business Women Lead Here, Report on Business for Canada's Top Growing Comp ...

  • Mattel

    Data Solution Architect

    4 days ago

    Mattel Mississauga, Canada

    Key Responsibilities: · Data Architecture, Engineering, and Machine Learning: · Support existing Informatica PC and IICS flows and retransformation on PowerCenter and IICS · Establish and encode Patterns on GCP and associated data infrastructure for ETL/ELT, AIML · Develop data ...

  • Element Fleet Management

    Senior Architect, Data

    2 days ago

    Element Fleet Management Mississauga, Canada Full time

    Get started on an exciting career at Element · Element employees make a difference in the lives of others every day. We are re-defining the fleet management industry to be people first, then business – delivering on our promise of a superior client experience. This takes hard wor ...

  • 0000050007 Royal Bank of Canada

    Lead Data Architect

    4 days ago

    0000050007 Royal Bank of Canada Mississauga, Canada Full time

    Job Description · WHAT IS THE OPPORTUNITY?The RBC Insurance Team is currently undertaking a multiyear journey of modernization and transformation of the core Insurance applications. As part of this transformation there will be multiple initiatives working with leading edge techn ...

  • Royal Bank of Canada>

    Lead Data Architect

    4 days ago

    Royal Bank of Canada> Mississauga, Canada Full time

    Job Summary · Job Description · WHAT IS THE OPPORTUNITY? · The RBC Insurance Team is currently undertaking a multiyear journey of modernization and transformation of the core Insurance applications. As part of this transformation there will be multiple initiatives working with le ...

  • Maarut Inc

    Cloud Data Solutions Architect

    2 days ago

    Maarut Inc Toronto, Canada

    Resource Profile · This requirement is for a cloud data solution architect with proven experience designing, and implementing complex large scale Data Warehouse, Data Lake, and Lakehouse and supporting Data Migration and Conversion initiatives in a fast-paced environment. · This ...

  • Tata Consultancy Services

    GCP Data Engineer Solution Architect

    5 days ago

    Tata Consultancy Services Mississauga, Canada

    TCS is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity ...

  • Loblaw Companies Ltd - Head Office

    Data Architect

    6 days ago

    Loblaw Companies Ltd - Head Office Brampton, ON, Canada

    Toutes les références de candidats doivent d'abord être soumises dans Workday par un collègue de Loblaw actuel. · Venez faire votre différence dans les communautés à travers le Canada, où l'authenticité, la confiance et l'établissement de liens sont valorisés - alors que nous fa ...

  • Tata Consultancy Services

    GCP Data Engineer Solution Architect

    3 days ago

    Tata Consultancy Services Mississauga, Canada

    TCS is an equal opportunity employer, and embraces diversity in race, nationality, ethnicity, gender, age, physical ability, neurodiversity, and sexual orientation, to create a workforce that reflects the societies we operate in. Our continued commitment to Culture and Diversity ...

  • Quantum World Technologies Inc.

    Data Architect

    1 week ago

    Quantum World Technologies Inc. Toronto, Canada

    Relevant experience: Overall 10+ years of experience in SAP data management, data quality assurance, data extraction from legacy systems. · Job Description: · 1. Hands-on Data Architect - to provide guidance to the team - does design, coding or configuring tools as required. Also ...

  • Tech Mahindra

    Data Architect

    1 hour ago

    Tech Mahindra Toronto, Canada

    Job Title : Data Architect · Location : Toronto, ON, Canada · Job Type : Permanent · Data Architect - Data Architect / Visualization Prime - Responsible for analysis of data, linkage across tables, and developing complex queries to model customer requirements. · Strong understan ...

  • Project X Ltd.

    Data Architect

    6 days ago

    Project X Ltd. Toronto, Canada Full time

    Role Summary · As 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 add ...

  • Société Financière Manuvie

    Lead data architect

    1 week ago

    Société Financière Manuvie Toronto, ON, Canada

    Nous sommes un fournisseur de services financiers qui s'emploie à faciliter les décisions de nos clients et de nos collègues partout dans le monde et à les aider à vivre mieux. De nos initiatives environnementales à nos investissements dans la collectivité, nous montrons la voie ...

  • Trinity Infotech Inc.

    Data Architect

    5 days ago

    Trinity Infotech Inc. Toronto, Canada

    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 dat ...

  • Kumaran Systems

    Data Architect

    1 week ago

    Kumaran Systems Toronto, Canada

    We are looking for a Data Architect to build, optimize and maintain conceptual and logical database models. · Must Have · 10+ years with data warehouses (working in the data space) · 2+ years working with Apache Spark / Scala. · 2+ Years working experience on Azure DataBricks, Da ...

  • Net2Source Inc.

    Data Architect

    1 week ago

    Net2Source Inc. Toronto, Canada

    Job Title: Data Architect · Location: Toronto, ON (Hybrid onsite from day 1) · Type: Contract · PRIMARY 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 m ...

  • Altis Technology

    Data Architect

    5 days ago

    Altis Technology Ontario, Canada

    Client: Altis Technology & Recruitment (Internal) · Duration: Permanent Full Time · Salary: $130 – 160K annually · Location: Remote-by-choice with offices located in Ottawa, Toronto, & Vancouver · The successful candidate will take on a pivotal role, responsible for seamlessly ...

  • Project X Ltd.

    Data Architect

    6 days ago

    Project X Ltd. Toronto, Canada Full time

    Role Summary · As a Data Architect at Project X Ltd., you will be providing 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 ...

  • Randstad Digital

    Data Architect

    5 days ago

    Randstad Digital Toronto, Canada

    Data Solution Architect (Contract Position) · Number of Positions: 1 Duration: 7 months initial contract · Location: Toronto, ON, CA · Must be eligible to work in Canada · Hybrid position, 2-3days /week onsite in Toronto · Roles and responsibilities: · Be part of a high-profile t ...