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.
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/.
Please submit your most recent resume to: [email protected]
View All Jobs online at: https://www.symbioticgroup.com/view-jobs/
Similar Jobs
Blockchain • Fintech • Mobile • Payments • Software • Financial Services
Leads strategic finance for Commerce go-to-market, partnering with revenue leaders on annual planning, forecasting, performance management, investment analysis, resource allocation, and commercial strategy. Builds driver-based financial models connecting sales and operational metrics to financial outcomes, evaluates investments across commercial functions, prepares executive materials, and manages finance team members.
Top Skills:
AIPythonSQL
Big Data • Fintech • Mobile • Payments • Financial Services
Build and launch full-stack customer-facing features and backend services for Affirm Card. Collaborate with product, design, analytics, and engineering teams; design scalable APIs, support distributed systems, monitor service reliability, participate in on-call operations, review code, and contribute to technical planning and team development.
Top Skills:
AWSKotlinKubernetesMySQLPythonReactVue
eCommerce • Healthtech • Kids + Family • Retail • Social Media
Own and evolve Babylist’s AWS infrastructure, Kubernetes platform, Terraform IaC, CI/CD systems, observability, and developer tooling. Build secure infrastructure defaults, automate operational workflows, improve reliability and recovery readiness, define SLOs, support incident response, and lead cross-team platform initiatives. The role also mentors engineers and provides hands-on support across local, staging, and production environments.
Top Skills:
Amazon EksAmazon RdsAWSCdnCi/CdCircleCICloud NetworkingCronitorDatadogDnsGithub ActionsInfrastructure As CodeKubernetesLoad BalancersMySQLPagerdutyRedisRubyRuby On RailsSentrySidekiqTerraform
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
