Data Integration Architect

Position: Data Integration Architect

Location: Toronto, ON (Hybrid)

Job ID#: RQ11485

Duration: 6 Months

Role Overview

We are seeking an experienced Data Integration Architect/ Data Architect / Data Modeller to support complex enterprise data initiatives within a large-scale environment. The successful candidate will be responsible for designing and implementing data architecture solutions, developing logical and physical data models, analyzing source systems, and supporting the delivery of high-quality data solutions aligned with enterprise standards.

This is a hybrid position requiring onsite attendance three (3) days per week and remote work two (2) days per week.

Key Responsibilities

• Develop and implement data architecture solutions for application development within complex and distributed environments.

• Determine data flow, distribution strategies, database locations, and data access methods.

• Review existing source application data models and databases.

• Analyze and design logical data model specifications for target systems.

• Collaborate with business stakeholders to ensure data requirements are fully addressed.

• Support development teams in creating technical artifacts and data-related deliverables.

• Conduct research and analysis to produce effective data model designs.

• Align data models and initiatives with enterprise data modeling standards and requirements.

• Analyze source data structures and develop source-to-target data mappings.

• Validate and confirm data through advanced SQL-based analysis.

• Collaborate with cross-functional teams, including Business Analysts, Subject Matter Experts, Developers, and Architects.

• Communicate data modeling outputs and recommendations to technical and business stakeholders.

• Conduct research to align deliverables with industry best practices and current technology trends.

• Utilize data modeling tools to create, maintain, and govern data models.

• Support information sharing with business, information, solution, and technology architects.

• Ensure alignment with organizational policies, standards, and industry best practices.

• Develop and manage logical and physical data models.

• Required Qualifications

• Core Skills and Experience (8+ Years)

• Demonstrated experience reviewing and analyzing business requirements for existing IT applications and associated data.

• Experience designing target-state data models.

• Strong data analysis, research, and data modeling expertise.

• Experience aligning initiatives with enterprise data modeling standards.

• Advanced analytical skills and experience understanding source systems and developing data mappings.

• Strong RDBMS knowledge and advanced SQL capabilities.

• Experience working within multidisciplinary project teams.

• Ability to understand business domains and translate requirements into effective data models.

• Ability to work independently with minimal supervision.

• Strong research and problem-solving skills.

• Expert-level experience with data modeling tools.

• Experience supporting enterprise architecture disciplines.

• Knowledge of logical and physical data modeling techniques.

• Nice-to-Have Skills

• Experience supporting environmental, compliance, inspection, enforcement, or waste management systems.

• Experience using Computer-Aided Software Engineering (CASE) tools.

• Experience using Python for data processing activities.

• Understanding of Information Management principles and practices.

• Knowledge of Parquet and Delta Lake data formats.

• Experience with Azure Data Lakehouse environments.

• Knowledge of Star Schema and Snowflake modeling concepts.

• About Symbiotic Digital

Symbiotic Digital provides the IT Experts you need that solve problems and get things done. See what the top 2% in their field can do for you. (Symbiotic Digital is a division of Symbiotic Group Inc.) We serve customers in two ways, we provide:

• Digital Experts: IT Consulting expertise. Bright Minds That Produce Proven Results

• Recruitment: Find The Right People You Need

• Serving IT & Business leaders, Symbiotic Digital provides a business system that enable us to provide the Expert Technical staff needed to solve challenging business and IT problems. IT leaders in the most reputable organizations in Canada have relied on Symbiotic Digital to help them staff difficult assignments with proven Experts uniquely evaluated by our proven QMS- Quality Management System Staff Development Model. We are a 100% Indigenous owned company.

• Learn more online at https://www.symbioticgroup.com/home-sd/.

• View All Jobs online at: https://www.symbioticgroup.com/view-jobs/