Sql jobs in Canada

ODAIA is a remote first organization; all positions are WFH with frequent company and team based socials, events and meetings in-person and virtually. ODAIA works with pharma commercial teams to grow their brands and engage with the right healthcare professionals (HCPs) at the right time. ODAIA's SaaS AI platform turns complex data into personalized insights, enabling commercial teams to understand their customers (HCPs), predict prescribing behaviors and make informed decisions that bring therapies to patients faster. ODAIAans (what we call ourselves) are inspired to reinvent the future of how non-technical people leverage data in their day-to-day lives. We are passionate about solving complex problems in data, AI, engineering, design, and product, so our customers don\'t have to. We live by the notion that “simplicity is the ultimate sophistication;” and making simplicity scalable is an even bigger challenge. That’s why we have a crazy talented team led by serial entrepreneurs, tech veterans, and life sciences experts.

To learn more visit odaia.ai.

OUR MISSION

Reducing patients’ time to therapy by facilitating meaningful interactions with healthcare providers, through human-centric software powered by AI.

We’re also on a mission to build an innovative, diverse, and ego-free business, where trust, innovation and ownership are valued. You’re on a mission too? We’re here for it. We put an emphasis on career development for our employees, and the opportunities to grow are extensive.

Reporting to the Director, Data Management and as a member of the Data Management team, the Data Engineer is passionate, curious and motivated to design and implement scalable solutions end-to-end. This high-impact position focuses on key aspects of data management including fast and efficient data onboarding, and the initial bring up of customer data into our system.

• Build scalable data infrastructure to support customer onboarding and implementation, enabling fast and efficient ingestion of customer data into ODAIA’s platform
• Design and develop automation tools that streamline how implementation consultants configure and ingest new customer datasets
• Solve complex data challenges by defining, prototyping, and implementing end-to-end data solutions in agile startup environment
• Serve as a subject matter expert to internal teams and customers on data integration, architecture, and management best practices
• Implement scalable ingestion pipelines leveraging AWS tools and services to manage high-volume customer data
• Develop integrations with Veeva/Salesforce and other third-party data sources; contribute to proof-of-concept builds and internal applications
• Design APIs and data models that enable internal data access and cross-system interoperability
• Explore and onboard new data sources, designing warehouse schemas that improve analytics and product capabilities
• Collaborate cross-functionally with product and engineering teams to align data systems with strategic objectives

• 3+ years in data engineering, building production grade data pipelines
• Strong experience with AWS (ECS, S3, Lambda, DynamoDB, API Gateway, etc.) and Snowflake
• Experience with Dagster or Airflow for orchestration and workflow management
• Strong programming proficiency in Python
• Experience building and optimizing complex data models utilizing DBT with a strong understanding of ETL processes
• Solid understanding of data structures, algorithms, and database design, with expertise in performant SQL schema and query development
• Familiarity with CI/CD and Test Driven Development in a production environment
• Experience integrating with CRM systems (Veeva, Salesforce) and handling healthcare, pharmaceutical, or pharmacy-related datasets is a strong asset
• Solid, demonstrated experience in AWS stack or an equivalent cloud platform
• Background in modernizing data environments, migrating from legacy systems to cloud-native architectures
• Collaborative and self-directed, able to manage projects independently, prioritize effectively, and adapt quickly to changing business needs
• Excellent communication skills, capable of translating complex technical concepts for both technical and non-technical stakeholders

• A strong, positive values based culture, we Ignite Innovation, Own It and Stand Together
• Medical & dental benefits - with immediate enrollment for full-time, permanent employees
• Flexible working hours, focusing on what we achieve and not the number of hours we clock
• Flexible time off policies
• Stock option grants

We are a remote first company with employees in both Canada and the US. Our office hub is located downtown Toronto. Team building, communication and social connectivity are important and we support this with virtual and in-person collaborative work sessions, team meetings and socials.

Any conditional offer of employment made to a successful candidate will be subject to the full satisfaction with the results of any background and reference checks.

ODAIA does not use artificial intelligence (AI) to review applications, filter or analyze resumes. Our recruitment team may use an AI-powered meeting assistant to record and transcribe interviews for note-taking purposes only. This tool helps our recruiters to be fully present during conversations with candidates who provide consent to this tool being used during an interview. This tool is used in compliance with privacy and employment laws across Canada and the U.S.

We respect the time candidates invest into participating in our recruitment process. ODAIA is committed to providing timely status updates on hiring decisions to all candidates following their final interview, in accordance with applicable employment laws.

The anticipated base salary for this position ranges from $100,000 to $130,000 CAD. This range represents ODAIA\'s good-faith estimate based on current market data and internal equity. Final compensation is determined through a comprehensive review of the successful candidate’s unique skill set, specialized experience, and relevant certifications. As such, the final offer may vary based on these specific factors. Salary expectations will be discussed collaboratively early in the process to ensure alignment. This role is also eligible for health benefits, stock options, and flexible time off policies as mentioned above.

This posting is for a new/existing vacancy.

ODAIA is an equal opportunity employer. We are committed to building an environment where everyone feels included, valued, respected and heard. We are committed to creating a diverse workplace, free from discrimination on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, parental status, veteran status, disability status or any other characteristics protected by local laws, regulations or ordinances.

Accommodations are available upon request. If you need assistance or accommodation due to a disability or special need at any stage of the recruitment process, please contact us at hr@odaia.ai.