Opens an external site
- Employment type
- Full-time
- Experience level
- Mid-level · 3+ years
- Posting language
- English
- Working hours
- 40 hours per week
- Office presence
- 3 days per week
Job summary
You will develop and maintain data warehouse modeling and build robust, scalable data pipelines to transform raw data into curated datasets. Additionally, you will implement observability for data quality and collaborate with cross-functional teams to translate business requirements into effective data products.
Job details
Your role as Data Developer We are seeking a product-oriented Data developer to help us deliver more value with our growing data product catalogue. In particular, we’re interested in candidates with experience working on structured data mart modelling in a cloud-based data warehouse. In this role, you will collaborate closely with data analysts, full stack developers, product/project managers and software developers to understand business requirements and translate them into robust and scalable data product features. You will work within an agile framework, emphasizing rapid iteration and deployment while maintaining high standards of code quality and data integrity. What you'll be doing * Develop and maintain our data warehouse modelling, optimizing it for utility, extensibility, and performance across staging, intermediate, and mart layers, transforming raw source data into curated, well-documented datasets ready for external client reporting and statement of work reporting using dbt and Snowflake * Implement robust observability for data pipelines—structured logging, data quality checks, freshness monitoring, and alerting—to ensure shared data is accurate and trustworthy * Develop and own batch and event-driven data pipelines (Snowpipe, EventBridge) that power eligibility management, engagement reporting, and care reimbursement. * Participate in code reviews and technical design discussions to ensure high-quality maintainable data products * Champion data governance and privacy practices, including anonymization standards and access controls. We'd love to hear from you if you have * At least 3 years of meaningful experience in a data or engineering role, with a strong interest in all things data * Have experience with data modeling techniques (dimensional modeling, slowly changing dimensions, star schema) and building well-structured transformation layers in dbt and Snowflake . * Familiarity with BI as code tools and Product-oriented thinking with the ability to understand business requirements and translate them into data models ready for consumption in BI tools * Interest in team collaboration and knowledge sharing. You enjoy contributing to a culture of continuous improvement * Strong communication skills and the ability to explain technical concepts and ideas to your colleagues * Understand data governance, anonymization techniques, and the sensitivity required when handling health data in a regulated environment. * Care about reliability and correctness as much as velocity, and enjoy building systems that are simple, maintainable, and measurable. At Dialogue, your well-being is our priority Taking care of others also means taking care of our team! Depending on your role and employment status, you could have access to the following benefits: * Access to the Dialogue app and virtual mental health support for you and your family * Fully funded insurance, a health spending account, dental coverage, and fitness reimbursement * 4 weeks vacation, 9 wellness days, and 1 volunteer day * Hybrid work: 3 days/week in our Montreal or Toronto offices, excluding remote roles * Work abroad up to 4 weeks/year * Incentive plans, referral bonuses & RRSP matching * Learning via Coursera, external training budget & mentorship * Optional parental leave top-up
What you’ll do
You will develop and maintain data warehouse modeling and build robust, scalable data pipelines to transform raw data into curated datasets. Additionally, you will implement observability for data quality and collaborate with cross-functional teams to translate business requirements into effective data products.
Requirements
Candidates must have at least 3 years of experience in a data or engineering role with strong proficiency in dimensional modeling and dbt. You should also possess excellent communication skills and a solid understanding of data governance and privacy practices in a regulated environment.
Benefits
- Virtual mental health support
- Health insurance
- Health spending account
- Dental coverage
- Fitness reimbursement
- Paid vacation
- Wellness days
- Volunteer day
- Incentive plans
- Referral bonuses
- RRSP matching
- Learning budget
- Mentorship
- Parental leave top-up
Listed skills
- SQL · Preferred
- Communication Skills · Preferred
Other relevant skills
Identified from the job description. Confirm important requirements above.
- Data modeling
- Dimensional modeling
- Star schema
- dbt
- Snowflake
- Data warehousing
- Data pipelines
- Snowpipe
- EventBridge
- Data governance
- Data quality
- Observability
- Business intelligence
- SQL
- Communication skills
- Slowly Changing Dimensions
- Inventory Staging
- Full Stack Development
- Data Recording
- Snowflake (Data Warehouse)
- Schema Markup
- Technical Design
- Agile Methodology
- Software Development
- Mental Health
- Business Intelligence
- Management
- Business Requirements
- Code Review
- Communication
- Continuous Improvement Process
- Data Governance
- Data Integrity
- Data Modeling
- Data Sharing
- Data Warehousing
- Dimensional Modeling
- Event-Driven Programming
- Scalability
- Project Management
- Mentorship
- Software Quality (SQA/SQC)
- Reliability
- Trustworthiness
- Star Schema
- Data Pipelines
Job areas
- Data & Analytics
- Technology
- Software
- Engineering
- Healthcare
- Data Developer
- Software Developer / Engineer
- Software Developers
More jobs from Dialogue
Senior Software Developer, Full-Stack (Client experience)
- Hybrid
- Montréal, QC
- Posted Oct 30, 2026
Critical Incident Specialist
- Hybrid
- Posted Oct 28, 2026
Director, Enterprise Account Management
- Hybrid
- Toronto, ON
- Posted Oct 17, 2026
Mental Health Intake Agent, Temporary
- Remote
- Canada
- Posted Oct 17, 2026
