Senior Software Developer, Data Warehouse

Summary

Join Syndio, a Series C technology company, and become an experienced data warehouse developer. You will expand and optimize data architecture, optimize data flow and collection, and model data from various sources. You will build a unified data foundation supporting R&D, reporting, and analytics needs, contributing to Syndio’s next-generation data platform. Design, construct, and maintain data pipelines, ensuring scalability and reliability. Shape the future of the data warehouse by building foundational models and standards. Collaborate with backend developers and data scientists to implement and maintain data infrastructure and deliver high-quality data. Syndio offers competitive compensation, equity, paid time off, pension contributions, and a remote-first work environment.

Requirements

• Experience with data architecture and a strong background in data warehousing, pipeline development, and delivering high-quality, scalable data products
• Proficient in modern data transformation tools (e.g., dbt, SQLMesh, Dataform) with advanced SQL skills, including expertise in relational database design and data modeling
• Strong understanding of data governance, privacy, and international data regulations (e.g., GDPR, CCPA)
• Experience working with BigQuery or other data warehouses, and managing data workflows using orchestration tools like Airflow, Prefect, or Dagster

Responsibilities

• Design, construct, and maintain our data pipelines, ensuring scalability, reliability, and efficiency to support our expanding data needs
• Shape the future of our data warehouse by building its foundational models, standards, and structure from the ground up
• Work with backend developers to implement and maintain the next evolution of our data infrastructure, including our data lake / warehouse
• Participate in building the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources
• Work with data scientists and product managers to design and deliver high-quality, usable data that fulfill R&D, product, operational and reporting needs throughout the company
• Assist other developers in determining and implementing best practices for data management and data hygiene
• Participate in architecture design and discussions
• Provide logical and physical data design, and database modeling
• Solve complex data issues around data integration, unusable data elements, unstructured data sets, and other data processing incidents

Preferred Qualifications

• You have excellent communication skills that enable you to interface with both technical and non-technical teams
• You excel in a collaborative environment, supported by a strong team of data scientists, product, and development resources
• You are ready to work with teams across the organization to ensure data security and maintainability
• You are an experienced problem solver, who can root out issues and find thoughtful solutions
• You are passionate about our mission to close pay gaps and create fairness in the workplace
• You are excited to own and drive initiatives within Syndio that leverage and build your skills and interests

Benefits

• Competitive Compensation. For this role our base salary is targeted at $140-160k CAD. Final offer amounts are determined by factors such as experience and expertise
• Syndio Equity. So you can share in Syndio’s success
• 20 days annually. We encourage our team to recharge when they need to, plus paid sick & safe time, compassion leave, and voting leave
• Pension Contribution
• Remote-First (within commuting distance of Calgary) #LI-Remote