Senior Software Developer, Data Warehouse (Calgary, Canada)

PennyJar Capital; Calgary; Remote; CAD 140,000 - 160,000; Full time

Job summary

Join a forward-thinking company dedicated to creating equitable workplaces. As a Data Warehouse Developer, you'll tackle complex data challenges and optimize data architecture to empower teams across the organization. You'll design and maintain scalable data pipelines, collaborate with cross-functional teams, and shape the future of data infrastructure. This role not only allows you to leverage your technical skills but also contributes to a mission that aims to eradicate workplace inequities. Enjoy competitive compensation, equity options, and a remote-first work culture that values work-life balance and inclusivity.

Benefits

Competitive Compensation

Equity Options

20 Days Annual Leave

Pension Contribution

Remote-First Work Environment

Qualifications

• Strong background in data warehousing and pipeline development.
• Experience with data governance and international data regulations.

Responsibilities

• Design and maintain data pipelines ensuring scalability and efficiency.
• Model data from various sources to support R&D and reporting needs.

Skills

Data Architecture

Data Warehousing

Pipeline Development

SQL

Data Governance

Data Modeling

Communication Skills

Tools

BigQuery

Airflow

dbt

SQLMesh

Dataform

Job description

Do you want to empower organizations to build smarter compensation strategies while ensuring fair pay for all employees?

Syndio is a Series C technology company leveraging advanced technology and responsible AI to accelerate decision-making, streamline compliance, and democratize insights for consistent, equitable compensation practices at scale. Backed by $83M in investments from Bessemer Venture Partners, Voyager Capital, and Emerson Collective, we are expanding our team and products to help companies align their rewards strategies with their business goals.

Our customers are our greatest asset. Syndio partners with many of the world’s most recognized and respected enterprises, helping them implement leading-edge compensation solutions with expert guidance. We analyze pay for over 10 million employees across dozens of countries, ensuring fair, defensible rewards that drive better business outcomes.

Join us in our mission to eradicate workplace inequities and help companies create workplaces where every employee is valued for who they are and the impact they make.

About the role

We are looking for an experienced data warehouse developer who is excited to take on and solve data challenges at a fast-paced startup. You’ll be responsible for expanding and optimizing our data architecture, as well as optimizing data flow and collection for cross-functional teams. You will model data from various sources across the company to build a unified foundation that supports our R&D, reporting, and analytics needs. Not only that, but you will contribute heavily to the evolution of Syndio’s next-generation data platform, empowering our people and our ever-expanding set of products.

Why this job is exciting

• 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.

Basic 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.

About you

• 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

Why you'll love it here:

Check out our Employee Experience page for more information on our Mission & Values, Work-Life Balance, Pay Transparency, Diversity, Culture, and 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

Role Progression

• 30 Days - You will familiarize yourself with the data environment, meet internal stakeholders, and learn the tools and processes.
• 60 Days - You will have begun developing data models and enhancing our pipelines by introducing best practices drawn from your experience, while collaborating closely with cross-functional teams to validate your work.
• 90 Days - You will be leading end-to-end pipeline development and delivering data models used to impact internal decision-making.

The Interview Overview

Below you'll find an outline of the interview plan for our Senior Software Developer, Data Warehouse position. Please note that this is what we expect the process to look like; we may ask you for supplemental information or require an additional step before making a final decision.

1. 30 min phone call with a member of our Talent Team
2. 45 min Zoom interview with the Hiring Manager
3. Take-home assignment
4. Technical Deep-Dive - 60 min
5. 2-3 video interviews with cross-functional team members - 30-45 min each

At Syndio, we're building a diverse team that values candor, curiosity, and community. If you share these values and are interested in joining us, we'd love to talk with you even if you don't 100% meet the "about you" listed here. We don't expect anyone to have all the answers, as long as you're willing to learn and grow with us.

Employees joining the Syndio team at this early stage of growth will impact this critical social issue and support a growing customer base (including Nordstrom, General Mills, Match Group, and others) to take tangible action on workplace fairness.

Syndio is an Equal Opportunity Employer. We are building an inclusive and collaborative workplace as we grow, and we welcome team members regardless of gender/identity, sexual orientation, race or cultural background, religion, physical disability and age.