224 Data Solution Designer jobs in Canada

Job Description

Salary:

At OpsGuru, we're a people-first, customer-obsessed company motivated by our passion for empowering organizations of all sizes to embrace the power of Cloud technology through impactful, reliable and scalable consultancy services.

Our team is made up of technical experts, creatives, salespeople, and many more. We work together to drive our mission forward and raise the bar for our customers daily, bringing their vision to life. We strive to be a workplace of inspired minds by fostering an environment that encourages innovative thinking, where everyone can grow and contribute to achieving their goals.

Our long-term vision is to continue being an innovative and inspiring company that our customers and employees admire, and we invite you to join us!

About the role:

OpsGuru's value to our customers centres around our ability to provide deep technical guidance based on their business needs. We achieve this by assigning small, virtual teams of highly skilled individuals to each client.

Within these teams, the Data Solutions Architect is responsible for providing technical expertise and leadership to Data Engineers, while also maintaining a systems view that is able to reconcile technical decisions with broader project goals.

Data Solutions Architects work alongside our Principal Consultants to ensure our project deliverables meet stakeholders' needs while upholding OpsGuru's quality and operational maturity standards.

What you'll be doing:

Project Delivery

• Provide deep technical expertise and leadership across a range of cloud data technologies. You will be the go-to person for driving tool selection, resolving complex engineering issues, and guiding best practices during engagements.

• Lead the design and implementation of data platforms to meet customers' business requirements.

• Lead whiteboard design sessions with internal and external team members.

• Identify and communicate technical risks as they emerge over the course of a project.

• Work closely with Principal Consultants to extract project requirements during technical discovery sessions, define deliverables to meet those requirements, and break down those deliverables into a technical roadmap.

• Lead teams of data engineers to execute project roadmaps. Provide guidance on technical tasks, priorities, and technical assistance when needed.

• Manage scope within customer engagements. Identify changing requirements as they arise, determine their impact on scope, and ensure all stakeholders are aware and agree with the changes.

• Maintain a close working relationship with the customer, as a "Trusted Advisor". Set clear expectations, challenge assumptions, solicit feedback, and take ownership of project deliverables.

• Establishing credibility and building impactful relationships with our customers

Design and Delivery

• Complex ETL/ELT processes, large-scale batch and real-time stream processing solutions, and optimizing data and schemas

• Data Lakes using native cloud tools or leveraging 3rd party platforms (for example Snowflake or Databricks)

• AI-based solutions for NLP, speech and video recognition, anomaly and fraud detection, chatbots, etc.
  

• End-to-end data solutions from ingestion pipelines, cataloging, analysis, and sharing insights (for example reports, dashboards, ML forecasts/predictions, etc.

• Migrations and transformations of data services such as relational databases, NoSQL databases, and Data Warehouses (heterogeneous and homogeneous)

• Designing, building, training, and optimizing AI/ML solutions

• Designing and integrating MLOps solutions to support model lifecycle automation

Other Technical:

• Developing code using Python, Java, and Scala languages

• Architect and operationalize solutions following best practices including data governance, privacy, lifecycle management, and cost optimization

• Maintain relevant certifications on cloud and data technologies and stay informed of key industry trends

Your skills & experience:

Technical:

• 5+ years of experience in public cloud environments (AWS preferred).

• 5+ years of developing code using Python, Java, or Scala languages

• Experience building complex data engineering pipelines and ETL/ELT tasks

• Experience with relational databases (for example Oracle, SQL Server, MySQL, Postgres, MariaDB) or managed cloud RDBMS services (such as Amazon Aurora)

• Experience with NoSQL databases such as MongoDB, Cassandra, CouchDB, ElasticSearch, Neo4j, DynamoDB, BigTable, etc.

• Experience building batch processing and real-time processing systems.

• Experience building Data Warehouses and Data Lakes

• Experience with 3+ of the following:

- Building real-time streaming solutions leveraging technologies such as: Kafka, Kinesis, Pub/Sub messaging, event buses, or Spark Streaming

- Designing and implementing analytics and BI solutions such as MicroStrategy, Tibco, Qlikview, or Tableau

- Building AI/ML solutions, including operations such as ongoing training, optimizations, and model deployments.

- Designing, implementing, training, and optimizing ML and AI models

- Building solutions leveraging caching systems (for example Redis) and object stores (for example Amazon S3, Amazon Glacier, etc.)

Consulting:

• Proven ability to discuss and design solutions using concepts such as data lineage, data quality gates, data anonymization, data governance, data security, data replication, data caching, data lifecycle management, data catalogs, and networking

• Understanding of requirements and impacts from compliance frameworks such as HIPAA, PCI, GDPR, PIPEDA, etc.

• Strong communication and presentation skills, written and verbal

• Experience writing technical documentation

• Experience in technical mentoring

• Experience working in a customer-facing delivery role in a consulting or professional services environment

What's in it for you:

Compensation & Perks

• Competitive compensation package

• Retirement Savings Matching Program (RRSP)

• Access to the latest tech

• Partnership with Perkopolis Discounts

Flexibility & Time Off

• Remote first work environment

• Flexible work hours & location

• Paid parental leave options

Health & Wellness

• Employer paid health & dental premiums

• Partnership with GreenShield+ Counselling Mental Health provider

• $500 in Health Care Spending Account annually

Growth & Development

• Training reimbursement (e.g courses on Udemy, Coursera,a-cloud-guru etc.)
  

• Peer recognition rewards

At OpsGuru, a Carbon60 Company, we believe in bringing our whole, authentic selves to work. By embracing and sharing our unique backgrounds, experiences, and perspectives, we learn from one another, spark innovation, and foster a dynamic environment where everyone can thrive and do their best work.

We are committed to cultivating a culture where every team member feels a strong sense of belonging, safety, and respect. Your unique voice is not only heardits valued. At OpsGuru, you have meaningful opportunities to contribute to decision-making and the growth of our organization.

We also understand the importance of balance between career and personal life. Our culture reflects this ethos, offering flexible work hours, health and wellness incentives, and moments of fun along the way. We seek individuals who thrive in a culture of accountability and are comfortable navigating ambiguity as we continue to adapt and grow.

OpsGuru is an equal opportunity employer. We welcome and encourage applications from individuals of all abilities. Accommodations are available upon request for candidates participating in any stage of the selection process. If you require support, please contact us at

We appreciate the interest of all applicants in this exciting opportunity. Please note that only candidates who meet the qualifications will be contacted for an interview.

Amilia is transforming the recreation and activities market with its innovative, purpose-built SaaS platform. Designed for municipalities, community centers, nonprofits, businesses, and recreation organizations, Amilia SmartRec™ streamlines operations, optimizes facility management, and simplifies program and membership management. 

Since 2009, Amilia has been on a mission to revolutionize how communities connect and participate in activities. By combining cutting-edge technology with deep industry expertise, the software empowers organizations to manage registrations, memberships, facilities, and finances more efficiently while enhancing community engagement. 

Over 1,500 organizations across 6,600 locations in North America rely on Amilia to serve 4.5 million participants and process $750M in transactions annually. 

Caring is at the core of Amilia’s culture: for customers, tailored products, and colleagues alike. Driven by an entrepreneurial spirit and a passion for innovation, this mindset shapes everything we do. 

As a Data Solutions Consultant, you’ll be at the heart of our client onboarding experience. You’ll lead the charge in migrating complex datasets from legacy systems to SmartRec, while also designing custom data solutions that help our clients make smarter decisions. You’ll collaborate with cross-functional teams and act as a trusted advisor, solving real-world data challenges with creativity and precision. 

This is a unique opportunity to shape a growing team, build scalable processes, and make a direct impact on our clients’ success. 

Data Migration & Onboarding  

• Scope and propose migration strategies during the sales cycle 

• Lead end-to-end data migration efforts (users, activities, payments) 

• Document and refine repeatable migration processes 

• Partner with Implementation Consultants to ensure smooth transitions 

Customer-Centric Data Solutions  

• Solve data-related business challenges with tailored solutions 

• Build custom reports and dashboards using tools like Power BI, API connectivity, automation tools  

• Support integrations with third-party applications 

• Advise clients on SmartRec’s data structures and best practices 

Process Improvement & Collaboration  

• Identify opportunities to improve and scale migration workflows 

• Maintain internal knowledge bases and integration guides 

• Collaborate with Product and Engineering to enhance platform features 

• Contribute to new service offerings that meet evolving client needs

Job Description

Salary:

Pre-Sales Data Center Solutions Architect

Who We Are:

Quadbridge is a fast-growing North American IT solutions provider, empowering businesses to navigate complex challenges daily, through strong partnerships with leading technology providers and close collaboration with our team and customers. With locations in Kitchener, Montreal and Vancouver, we strive to create an energetic, fun workplace where ambitious, like-minded teammates collaborate, innovate, and thrive as we continue to grow our national footprint.

We are Quadbridge. See how were building tomorrows solutions, together.

This Role:

We are looking for an experienced and business-savvyPre-Sales Data Center Solutions Architectto join our team in Montreal or Kitchener and support sales engagements across mid-market and enterprise clients. This role will focus on designing secure, scalable, and high-performance data centers and hybrid IT solutions leveraging a robust portfolio that includesDell, HPE, Lenovo, Cisco, Sophos, Microsoft, Palo Alto, and Fortinet technologies.

Key Responsabilities:

• Partner with account executives to qualify, shape, and scope data center and hybrid infrastructure opportunities.
• Lead client discovery workshops to assess current environments, gather technical requirements, and map business needs to solution architecture.
• Design integrated infrastructure and security solutions using technologies that include and not limited to Dell, HPE, Lenovo, Cisco, Microsoft (Azure), Palo Alto, Fortinet, and Sophos.
• Deliver solution presentations, technical demos, and architecture briefings tailored to stakeholder personas (technical and non-technical).
• Build and validate solution configurations (BOMs), develop high-level and detailed design documents, and contribute to SOW development.
• Collaborate with OEMs and distributors to stay up to date on roadmaps, certifications, programs, and incentives.
• Support responses to RFPs/RFIs including solution narratives, diagrams, and cost models.
• Contribute to knowledge-sharing and enablement activities internally across the sales and services teams.

Qualifications:

The ideal candidate will have a strong blend of technical acumen, customer-facing experience, and the ability to architect solutions across computing, storage, networking, virtualization, security, and hybrid cloud environments.

• 5+ years in a pre-sale, solution architecture, or consulting role with a focus on infrastructure and security.
• Proficient in designing and integrating solutions across:
  • Compute & Storage:Dell PowerEdge/PowerStore, HPE ProLiant/Alletra, Lenovo ThinkSystem, SAN/NAS
  • Networking:Cisco Catalyst/Nexus/Meraki
  • Virtualization & Cloud:VMware vSphere, Microsoft Hyper-V, Azure IaaS/PaaS, Windows Server, Citrix
  • Security:Palo Alto firewalls, Fortinet FortiGate/FortiManager, Sophos XGS, Microsoft Defender
• Strong understanding of high availability, disaster recovery, backup/restore, and multi-site architectures.
• Excellent communication, documentation, and stakeholder engagement skills. Bi-lingual is an asset
• Familiar with assessment and sizing tools (e.g., Dell Live Optics, HPE CloudPhysics).
• Experience creating Visio/Lucidchart diagrams, proposal content, and SOWs.

Preferred Certifications

• Dell Technologies Proven Professional (e.g., DCA, DCS)
• HPE ASE and Aruba Certified
• Cisco CCNA/CCNP (Enterprise or Data Center)
• Microsoft Azure Solutions Architect Associate

Why Quadbridge:
Invest in Your Future
Benefit from our RRSP program to help you plan ahead.

Grow With Us Take advantage of ongoing professional training and development opportunities.

Comprehensive Coverage A complete health, dental, life and LTD insurance plan

Top-Tier Equipment We provide everything you need to do your best work.

A Vibrant Workplace Join us for monthly social and team building events.

Perks Youll Love In our Montreal office, enjoy an onsite chef and gym.

Stay Connected Receive a phone allowance to keep you plugged in.

Bring Your Best Friend Our offices are pet-friendly!

Quadbridge is an equal opportunity employer, committed to diversity and inclusion in compliance with the Canadian Human Rights Act and Employment Equity Act. If you require accommodations under the applicable Canadian laws during the interview process, please inform us, and we will ensure your needs are met.

#LI-SS1

Job Description

Hybrid Hadoop Engineer and Hadoop Infrastructure Administrator to build and maintain a scalable and resilient Big Data framework to support Data Scientists. As an administrator, your responsibility will be to deploy and maintain Hadoop clusters, add and remove nodes using cluster management and monitoring tools like Cloudera Manager, and support performance and scalability requirements, in support of our Data scientist's needs. Some Relational Database administrator experience will also be desirable to support the general administration of Relational Databases.

Design, build, and maintain Big Data workflows/pipelines to process a continuous stream of data with experience in end-to-end design and build process of Near-Real-Time and Batch Data Pipelines.

Demonstrated work experience in the following with Big Data and distributed programming models and technologies
Knowledge of database structures, theories, principles, and practices (both SQL and NoSQL).
Active development of ETL processes using Spark or other highly parallel technologies, and implementing ETL/data pipelines
Experience with Data technologies and Big Data tools, like Spark, Kafka, Hive
Understanding of Map Reduce and other Data Query and Processing and aggregation models
Understanding of challenges of transforming data across distributed clustered environment
Experience with techniques for consuming, holding, and aging out continuous data streams
Ability to provide quick ingestion tools and corresponding access APIs for continuously changing data schema, working closely with Data Engineers around specific transformation and access needs

Preferred:

Experience as a Database administrator (DBA) will be responsible for keeping critical tools database up and running
Building and managing high-availability environments for databases and HDFS systems
Familiarity with transaction recovery techniques and DB Backup

Skills and Attributes:

Ability to have effective working relationships with all functional units of the organization
Excellent written, verbal, and presentation skills
Excellent interpersonal skills
Ability to work as part of a cross-cultural team
Self-starter and Self-motivated
Ability to work without lots of supervision
Works under pressure and is able to manage competing priorities.

Hide

Job Description

Salary:

Forum Asset Management Data Engineer

Location: 181 Bay Street, Toronto

In Office:5 days per week

Overview of Forum:

Join us in deliveringExtraordinary Outcomesthrough investment.

Forum is an investor, developer and asset manager operating across North America for over 28 years, focusing on real estate, private equity and infrastructure, with a strategic concentration in housing.

Our AUM exceeds $3 billion. We are committed to sustainability, responsible investing and creating value that benefits our stakeholders and the communities in which we invest, what we call our Extraordinary Outcomes.

In 2024, Forum completed thelargest real estate transaction in Canadawith theAlignvest acquisition,making us thelargest owner of Purpose-Built Student Accommodation (PBSA) in Canada through our $.5B open ended Real Estate Income and Impact Fund (REIIF).Ournational development pipeline now exceeds 3.5 billion,positioning Forum as thelargest developer of PBSA in Canada, operating from coast to coast.

The Forum team is adaptable, agile, and dynamic, committed to sustainable and responsible investing. Our people bring diverse cultural backgrounds and professional experiences, fostering innovation and thought leadership.We uphold integrity, trust, and transparency as core values, knowing that to achieveExtraordinary Outcomes,we need to support and develop anExtraordinary team.

Position Overview:

Were looking for aData Engineer to own the architecture, build, and evolution of Forums enterprise data platform using the Microsoft Fabric technology stack (or a suitable alternative). This is a rare greenfield opportunity to architect the full data lifecyclefrom ingestion and transformation to analytics and AI enablementwhile directly impacting Forums investment, real estate, and operational strategies.

This is a hands-on, in-office role with high visibility. Youll act as a trusted advisor and technical authority, collaborating with investment professionals, business leaders, analysts, and software developers to design enterprise-grade systems and AI-powered workflows that drive measurable business value. Your work will lay the foundation for our long-term data strategy and the future of decision-making at Forum.

Key Duties and Responsibilities:

• Own the end-to-end design and evolution of Forums Lakehouse architecture Microsoft Fabric, Azure Data Factory, Synapse, ADLS, and related Azure services
• Define and enforce data engineering standards, governance frameworks, and lifecycle management practices
• Lead large-scale data initiatives, migrations, and integrations across diverse internal and external systems
  
• Design and optimize enterprise-grade ETL/ELT pipelines for high-volume, high-complexity data
• Implement structured data workflows (e.g., Medallion Architecture) to deliver reliable, business-ready data
• Develop AI/ML-powered workflows using tools like Azure OpenAI, Document Intelligence, and Azure ML
• Create internal APIs and tools to enable self-serve analytics and data access across departments
• Partner with business teams across real estate, private equity, and operations to identify data opportunities and implement tailored solutions
• Develop and evolve our Power BI dashboards and reporting layer, ensuring reliable data access and visualization
• Promote best practices in data governance, automation, and AI application across Forums technology ecosystem
• Partner with internal teams and external technology vendors to drive the rollout of the platform

Candidate Profile:

• 6-7 years of progressive experience in data engineering, with a proven track record of architecting and delivering enterprise-scale data solutions
• Expert-level experience with the Microsoft Azure ecosystem: Microsoft Fabric, Azure Data Factory (ADF), Synapse, ADLS Gen2, and Power BI
• Proficiency in Python for data engineering, automation, and API development
• Deep understanding of data modeling, ELT/ETL design, and data warehouse best practices
• Track record architecting enterprise-scale data platforms in high-growth or regulated industries
• Proven success deploying AI/ML solutions into production at scale
• Experience integrating Azure OpenAI, LLMs, and document intelligence into real business processes
• Ability to evaluate, pilot, and operationalize emerging AI technologies for measurable business impact
• Demonstrated ability to work directly with executives, investors, and analysts to shape data strategy
• Strong communication skills and an entrepreneurial mindset: capable of turning ambiguity into working solutions
• Experience working with financial data models, capital tables, investment reports, or property management systems
• Background in private equity, real estate, asset management, or related sectors preferred
  

At Forum, we encourage diversity. We are committed to an inclusive workplace that reflects our belief that diversity is central to building a high-performing team. Forum is an equal-opportunity employer. We are committed to providing accessible employment practices. Should you require an accommodation during any phase of the recruitment process, please let the recruitment team know at

Job Description

Salary: $90,000 - $110,000

We are seeking a motivated Data Engineer with 2-3 years of experience to join our innovative team. In this role, you will design, build, and optimize data pipelines and analytics workflows using modern cloud data platforms and tools. You will collaborate with cross-functional teams to transform raw data into actionable insights that power intelligent product features, ML models, and strategic decision-making.

Responsibilities

• Design and implement robust ETL pipelines using Apache Airflow
• Build and maintain data warehouses in Snowflake to support scalable data ingestion and transformation
• Develop ETL workflows for structured and semi-structured data from various sources using AWS services
• Collaborate with data scientists and ML engineers to prepare and transform data for AI/ML model training and inference
• Build interactive data applications using Streamlit
• Design and implement data models to support machine learning workflows and analytics
• Integrate data from APIs, databases, and cloud storage using Python
• Implement data quality checks and monitoring systems to ensure data integrity
• Document data models and pipeline architectures
• Stay updated on advancements in Airflow, AWS, Snowflake, Streamlit, and AI/ML technologies

Requirements

• 2-3 years of professional experience in data engineering or a related field
• Hands-on experience with Apache Airflow for building and orchestrating ETL pipelines
• Practical experience with AWS services
• Experience working with Snowflake for data warehousing workloads
• Strong Python programming skills for data processing and automation
• Experience with Streamlit for building data applications
• Solid understanding of data modeling concepts
• Familiarity with AI/ML workflows, including data preparation for model training
• Bachelor's degree in Computer Science, Data Engineering, or a related technical field (or equivalent experience)

Preferred Qualifications

• Advanced experience with AWS data services
• Deep expertise in Snowflake optimization and performance tuning
• Experience building complex Streamlit applications
• Advanced Python skills for data wrangling and automation
• Experience with AI/ML model deployment and data modeling for machine learning
• Knowledge of Airflow best practices for ETL pipeline design

Job Description

Title: Data Engineer - P2

Location: Remote Canada

Reports To: Senior Principal, Data Engineer

The Role:

As part of the data engineering team, the Data Engineer is responsible for designing and optimizing data structure, developing ETL processes, preparing and maintaining related documents, and automating and implementing data processes for different data projects and products.

Responsibilities:

• Work closely with project teams in different kinds of data related projects, design and implement data structure/models, develop automated data programs with optimized performance.
• As part of the Enterprise Data Hub implementation team, design, develop and maintain related ETL processes and data objects.
• Perform and provide complete tests, validation and documentation for all development tasks as required.
• Perform business analytics and visualization in support of product teams in an iterated fashion during product development

Qualifications:

• Bachelor's degree or master's degree in a quantitative or engineering field such as Computer Science and Information Systems, Database Management, Big Data, Data Engineering, Data Science, Applied Math, or other related area.
• Proficient and advanced knowledge of SQL and Python programming is a must. 1+ years of professional experiences with heavy usage of SQL and Python in daily development work.
• Familiar with ETL methodologies and Data Warehousing principles, approaches, technologies, and architectures including the concepts, designs, and usage of data warehouses and data marts.
• Familiar with python environment management tool (e.g., conda), experienced in using Git and the related tools (Github, Gitlab, etc.) during programming process.
• Experiences of cloud platform and products (such as Google Clouds, BigQuery, etc.) is a plus.
• Experience with automotive data helpful.
• Good communication skills.

The Career Opportunity:

You will have the opportunity to work with industry experts, learn the different auto industry data assets and how these data and solutions are helping our clients in their daily operations and strategic planning. You will also have the opportunity to strengthen your data design, data engineering and analytic skills by daily exposure to senior data science and data engineer staff at J.D. Power.

The Team / The Business:

Data Science has global responsibility for the research design, analyses planning and execution of all advanced analytics for survey research at J.D. Power. Additionally, Data Engineering team within Data Science is responsible for linking and optimizing datasets from all kinds of sources. You will report directly to Data Engineering Team Sr. Principal and join a team of highly educated and enthusiastic data scientists and data engineers that collaborate regularly with each other and with other teams across the firm.

Our Hiring Manager says:

I'm looking for someone who can work as part of a broader engagement team and can design and implement the linking of our data assets and also perform analyses for new product development and insights. If you're right for this role, you are a self-starter who is able to develop creative solutions to problems, not be afraid to ask questions as you learn our company's culture and do it all with enthusiasm.

J.D. Power is a global leader in consumer insights, advisory services and data and analytics. A pioneer in the use of big data, artificial intelligence (AI) and algorithmic modeling capabilities to understand consumer behavior, J.D. Power has been delivering incisive industry intelligence on customer interactions with brands and products for more than 50 years. The world's leading businesses across major industries rely on J.D. Power to guide their customer-facing strategies. 

The Way We Work:

• Leader Led
• Remote First
• Foster Flexibility
• Reward Performance
• Time Off Matters

Company Mission  

J.D. Power is clear about what we do to ensure our success into the future. We unite industry leading data and insights with world-class technology to solve our clients' toughest challenges.  

Our Values  

At J.D. Power, we strive to be Truth Finders, Change Makers and Team Driven - the distinct behaviors that, together, define our unique culture. 

J.D. Power is committed to employing a diverse workforce. Qualified applicants will receive consideration without regard to race, color, religion, sex, national origin, age, sexual orientation, gender identity, gender expression, veteran status, or disability.

J.D. Power is an equal-opportunity employer and compliant with AODA/ADA legislation. Should you require accommodations during the recruitment and selection process, please reach out to

To all recruitment agencies: J.D. Power does not accept unsolicited agency resumes and we are not responsible for any fees related to unsolicited resumes.