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
Edtech • Fintech • Sports
Drive territory growth by developing and executing sales plans, prospecting schools and youth organizations, managing the sales pipeline, conducting discovery calls and presentations, representing Snap! Mobile at events, maintaining customer records in HubSpot, and closing new business. The role includes cultivating relationships with athletic directors, coaches, administrators, and organizations while achieving sales targets and improving customer acquisition, saturation, and retention.
Top Skills:
CRMHubspot
Automotive • Big Data • Information Technology • Robotics • Software • Transportation • Manufacturing
Defines and governs the end-to-end architecture for GM’s scalable co-simulation and virtual integration ecosystem. Responsibilities include establishing interfaces, packaging, execution, configuration, traceability, observability, quality standards, supplier requirements, and technical roadmaps across virtual ECUs, models, software, networks, and test environments. The role leads cross-functional architecture decisions, supports issue resolution, mentors engineers, and aligns global teams while partnering with specialized pipeline, toolchain, quality, and program organizations.
Top Skills:
AutosarCC++Ci/CdFmiFmuHilMatlabModelicaPythonRobot FrameworkSilSimulinkSsp
Cloud • Security • Software • Cybersecurity • Automation
Leads Growth Marketing operating rhythms, strategic cross-functional initiatives, budget tradeoffs, executive preparation, pipeline reviews, and leadership commitments. Acts as a strategic partner and delegate to the VP of Growth Marketing, influencing ten functions without direct authority. Requires extensive B2B software marketing leadership, broad marketing expertise, business and financial fluency, executive communication, hands-on AI use, and familiarity with developer or DevOps audiences.
Top Skills:
AIDevsecopsGitlab
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
