Symbiotic Group Inc. Logo

Symbiotic Group Inc.

Data Integration Architect

Posted Yesterday
Be an Early Applicant
In-Office or Remote
Hiring Remotely in Deer Park, ON, CAN
Expert/Leader
In-Office or Remote
Hiring Remotely in Deer Park, ON, CAN
Expert/Leader
Designs and implements enterprise data architecture solutions, including logical and physical data models, source-to-target mappings, data flows, and database strategies. Reviews source systems, validates data using advanced SQL, governs models against enterprise standards, and collaborates with business, architecture, and development teams. The role requires extensive data modeling, RDBMS, SQL, analysis, and enterprise architecture experience, with Python, Azure Data Lakehouse, Parquet, Delta Lake, and CASE tool experience preferred.
The summary above was generated by AI

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:

  1. Digital Experts: IT Consulting expertise. Bright Minds That Produce Proven Results
  2. 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/.

Please submit your most recent resume to: [email protected]

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

 



Similar Jobs

3 Hours Ago
Remote
Canada
Senior level
Senior level
Cloud • Information Technology • Productivity • Security • Software • App development • Automation
Leads the technical direction and implementation of large-scale product features. Builds secure, reliable, maintainable, and well-tested full-stack software; evaluates technical trade-offs; collaborates with product and design teams; resolves production issues; contributes to reviews and documentation; and mentors junior engineers.
Top Skills: AngularjsChaiCSSCypressGraphQLHTML5JavaJavascript (Es6)JestMochaNode.jsReactRest ApisSQLVue
5 Hours Ago
In-Office or Remote
CA
Senior level
Senior level
Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
Leads architecture and scaling of Block’s finance technology stack across Oracle Fusion, accounting, tax, treasury, procurement, and FP&A. Designs financial data models, builds SQL/PL/SQL and REST/SOAP integrations, automates workflows, and translates accounting requirements into scalable technical solutions. Partners with finance, product, data engineering, and integration teams while applying AI-assisted development to improve delivery speed and financial operations.
Top Skills: ClaudeCursorData LakesEnterprise LlmsFccsGithub CopilotGoJavaJSONOracle BipOracle FahOracle FusionOracle GlOracle SlaPl/SqlPythonRelational DatabasesRestSoapSQLXML
5 Hours Ago
In-Office or Remote
6 Locations
Senior level
Senior level
Agriculture
Leads sales growth across Ontario, Quebec, and Atlantic Canada by developing regional strategies, growing key accounts, managing channel partners, identifying new opportunities, and delivering revenue targets. Responsibilities include forecasting, pipeline management, tenders, market analysis, solution selling, customer relationship management, and coaching regional team members. The role requires strong security technology knowledge, channel development experience, commercial acumen, and fluency in English and French.
Top Skills: CRMSecurity Systems

What you need to know about the Ottawa Tech Scene

The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account