Data Architect

3 weeks ago

Mississauga, Ontario, Canada Apex Systems Full time

Data Architect

Apex Systems is a global IT services provider, and our staffing practice has an opening for a 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 with bonus, benefits and work perks.

Location: 3 days hybrid, Mississauga, ON

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.

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.

Click here to Register for our Talent Network

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 .

  • Data Architect

    6 days ago

    Mississauga, Ontario, Canada Apex Systems Full time

    Direct message the job poster from Apex SystemsAccount Manager @ Apex Systems | Sales Management, Account ManagementData ArchitectApex Systems is a global IT services provider, and our staffing practice has an opening for a Data Architect with 5+ years' experience as a DBA/ ETL Developer and or Data Architect with a focus on data modelling, with strong...

  • Data Architect

    2 weeks ago

    Mississauga, Ontario, Canada Zenotis Group Full time

    Role : Enterprise Data Architect/ Data Solution ArchitectLocation: Winnipeg, Manitoba (Onsite for first 8-10 weeks then hybrid at Mississauga ON)Contract JobRoles and Responsibilities• Solutions and Assuranceo Create solutions and design for projects to meet Client's standards for technology and ensure they meet our ambitions for availability, security,...

  • Senior Architect, Data

    4 weeks ago

    Mississauga, Ontario, Canada Element Fleet Management Full time

    Senior Data Architect Job DescriptionAt Element, 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 work and innovation, and we need more like-minded individuals on our team.What We NeedWe are seeking a Senior Data Architect to join our team. As the...

  • Senior Architect, Data

    4 weeks ago

    Mississauga, Ontario, Canada CEI Fleet Collision and Safety 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 work and innovation, and we need more like-minded people on our team.What We...

  • System Architect

    6 days ago

    Mississauga, Ontario, Canada Cpus Engineering Staffing Solutions Inc. Full time

    We are seeking a highly skilled System Architect - Data Management to join our team. In this role, you will be responsible for architecting and implementing data management solutions using SAP Business Warehouse (BW).Responsibilities:Data Architecture:Design and implement data architecture for SAP BW systems.System Integration:Integrate SAP BW systems with...

  • Senior Python Data Architect

    1 day ago

    Mississauga, Ontario, Canada Presto Recruiting Solutions Full time

    We are seeking a seasoned Senior Python Data Architect to join our dynamic team at Presto Recruiting Solutions. As a key leader in our data organization, you will be responsible for driving the development and maintenance of our advanced data infrastructure. This includes designing, building, and optimizing data pipelines that provide actionable insights...

  • Big Data Architect

    23 hours ago

    Mississauga, Ontario, Canada Open Systems Technologies Full time

    Join our team as a Big Data Architect and take on the challenge of designing and implementing large-scale data architectures using Java Spark.In this role, you'll lead the design and development of data pipelines for risk calculations and trade analytics, as well as oversee the implementation of distributed computing solutions for risk modeling and...

  • Enterprise Data Solutions Architect

    3 days ago

    Mississauga, Ontario, Canada Texada Software Full time

    About the Role:We are seeking a talented Enterprise Data Solutions Architect to join our team in Greater Toronto Area, ON. As an Enterprise Data Solutions Architect, you will play a critical role in designing and implementing robust data integration solutions between our systems and external vendors.Key Responsibilities:Designing and implementing data...

  • Trading Systems Data Architect

    3 days ago

    Mississauga, Ontario, Canada Citigroup Inc. Full time

    Citigroup Inc. is seeking an experienced Trading Systems Data Architect to join our team in the Markets Division. In this critical role, you will be responsible for designing and implementing data quality solutions to ensure the accuracy, consistency, and reliability of data across trading, risk management, regulatory reporting, and financial analytics...

  • Salesforce Data Cloud Architect

    4 weeks ago

    Mississauga, Ontario, Canada Cognizant Full time

    As a Data Cloud Architect you will play a crucial role in designing, developing, building, and implementing Salesforce Data Cloud instances in conjunction with Salesforce Sales/Service cloud. You will be a valued member of our Salesforce Practice which is part of Cognizant's Enterprise Platform Services (EPS)In this role, you will- Drive end-to-end project...

  • Salesforce Data Cloud Architect

    4 weeks ago

    Mississauga, Ontario, Canada Cognizant Full time

    As a Data Cloud Architect you will play a crucial role in designing, developing, building, and implementing Salesforce Data Cloud instances in conjunction with Salesforce Sales/Service cloud. You will be a valued member of our Salesforce Practice which is part of Cognizant's Enterprise Platform Services (EPS)In this role, you willDrive end-to-end project...

  • Cloud Solutions Architect

    5 days ago

    Mississauga, Ontario, Canada KUBRA Data Transfer Ltd Full time

    We are seeking a seasoned engineering leader to join our dynamic team as Cloud Solutions Architect.In this role, you will play a crucial part in enhancing the stability and reliability of our product portfolio. As part of a small cross-functional team of engineers, you will work closely with our Product Manager to plan and execute the development of...

  • Cloud Security Architect

    17 hours ago

    Mississauga, Ontario, Canada KUBRA Data Transfer Ltd Full time

    Job DescriptionWe are seeking a highly skilled Cloud Security Architect to join our team at KUBRA Data Transfer Ltd. As a key member of our security team, you will be responsible for designing and implementing secure cloud-based solutions for our customers.The successful candidate will have prior experience in designing, implementing, and operating public...

  • Cloud Security Architect

    3 days ago

    Mississauga, Ontario, Canada KUBRA Data Transfer Ltd Full time

    KUBRA Data Transfer Ltd is a fast-growing company that delivers customer communications solutions to some of the largest utility, insurance, and government entities across North America. Our team is looking for an experienced Cloud Security Architect to join our growing organization.">">The ideal candidate will have experience designing, implementing, and...

  • Senior Architect- Cloud Data Architecture

    5 days ago

    Mississauga, Ontario, Canada Fuze HR Solutions Full time

    This role involves designing, integrating, leading, and maintaining the end-to-end architecture of a portfolio of Advanced Analytics (AA) and Artificial Intelligence (AI) platforms and frameworks. Contribute to strategic planning by establishing a technology roadmap that aligns business and IT strategies, enabling a portfolio to support both current and...

  • Enterprise Architect

    4 weeks ago

    Mississauga, Ontario, Canada PointClickCare Full time

    For more than 20 years, PointClickCare has been the backbone of senior care. We've amassed the richest senior care dataset, making our market density untouchable and our connections to the healthcare ecosystem exponentially more powerful than those of any other platform.With Collective Medical & Audacious Inquiry, we've become the most expansive,...

  • Java Architect

    2 weeks ago

    Mississauga, Ontario, Canada Bestinfo Systems LLC Full time

    Java Architect_Mississauga, ON_Full-Time Job Title: Java Architect Location– Mississauga, ON Mode- Full-Time Job Description: Skills and Responsibilities: Banking/Financial/Trade/experience is a plus 15 years' relevant experience Strong in coding Expertise in developing architecture vision and strategic solutions Experience with modernizing and...

  • Java Architect

    3 weeks ago

    Mississauga, Ontario, Canada Bestinfo Systems LLC Full time

    Java Architect_Mississauga, ON_Full-Time Job Title: Java Architect Location– Mississauga, ON Mode- Full-Time Job Description: Skills and Responsibilities: Banking/Financial/Trade/experience is a plus 15 years' relevant experience Strong in coding Expertise in developing architecture vision and strategic solutions Experience with modernizing and...

  • Senior Architect- Cloud Data Architecture

    1 hour ago

    Mississauga, Ontario, Canada Pyramid Consulting, Inc Full time

    Immediate need for a talented Senior AI Architect. This is a 12+ months contract opportunity with long-term potential and is located in Mississauga, ON (Hybrid). Please review the job description below and contact me ASAP if you are interested. CAD 65 - CAD 70/hour. Employee benefits include, but are not limited to, health insurance (medical, dental,...

  • Enterprise Architect

    1 day ago

    Mississauga, Ontario, Canada Groupe SII Full time

    As Enterprise Architect you will:Play a key role in the strategic planning on domain, product line and product level by establishing a technology and information strategy and roadmap that enables a portfolio to support current and future business capabilities connecting the business and IT strategy.You are a Lean Portfolio Governance member and provide...