Senior Analytics Engineer (hybrid)

Company Description

Rewind is a service that protects the critical data that powers businesses of all sizes. Our focus is on backing up data that lives in the cloud - in apps like Jira, GitHub, Confluence and Shopify. We are backed by Insight Partners, Inovia, Bessemer and Atlassian Ventures and are proud to be recognized as one of Canada's 50 fastest growing technology companies (2023 Deloitte Fast 50). We invite you to read our startup story to learn where we came from and where we’re going.

Read about our mission, story and values here.
To find out more about our perks, click here.
Some of our Blogs might help you get a better understanding of what we do here. You can find them all here.

Thriving at Rewind:

We embrace the fast-paced, ever-changing nature of startup life. If you love working with speed, agility, and creativity, you’ll feel right at home here. Here's what it takes to succeed with us:

• Team-First Mentality: We put teamwork at the core of everything we do, believing that we are better when we are together. Success is shared, and when the team wins, we all win.
• Performance-Driven Mindset: We are proactive, goal-oriented, and focused on delivering tangible, high-quality results. We go beyond meeting expectations - we aim to exceed them.
• Flexible Work-Life Approach: We encourage balance and understand the need to recharge. While we stay agile for urgent needs, we make sure there's time to recover and enjoy life.
• Customer Centricity: Our commitment to customers shapes everything we do. We listen, build relationships, and innovate - from our dedicated customer support team to our engineers, everyone at our company is focused on solving problems that matter most to our users.
• Taking Initiative: We value ownership and proactive problem-solving. We encourage team members to think creatively, take ownership, and lead improvements. Your ideas and actions drive our success.
• We Make Time for Fun: We work hard and make time to enjoy the journey. It’s not just about hitting milestones—it’s about making the experience rewarding along the way.

Job Description

As the Senior Analytics Engineer, you will be responsible for managing data at Rewind, assuming a leadership role in designing and maintaining robust data models, ensuring data accessibility, and fostering collaboration with stakeholders to deliver impactful data-driven insights. Your proficiency in SQL, dbt, BigQuery, and expertise in database structures will be paramount in optimizing our data infrastructure. You will be instrumental in advancing our self-service data product, ensuring data parity between systems, understanding business needs, and translating them into valuable features and capabilities.
As a Senior Analytics Engineer, your role in fortifying our data infrastructure and promoting a data-driven culture will be instrumental in shaping our organization's success through informed decision-making.

Your role will include:

Data Modeling and Transformation:

• Design, build, and maintain advanced data models utilizing SQL, dbt, and BigQuery to support comprehensive data analytics and reporting requirements.

• Develop resilient fact and dimension tables and data marts, transforming raw data into structured datasets to ensure integrity and efficiency.

• Enhance the self-service data product, improving user-friendliness, and empowering teams to independently retrieve data.

Tech Stack Expertise:

• Utilize expert SQL knowledge to optimize data queries and enhance overall performance.

• Extensive Salesforce and/or Hubspot experience through Reverse ETL tooling (Hightouch)

• Navigate complex data sources, including Stripe, Intercom, and Shopify.

Collaboration and Communication:

• Serve as the primary point of contact for key data models, offering guidance and support to analysts and team members.

• Ensure the GTM teams at Rewind have the data needed to drive strategic and actionable insights.

• Engage with cross-functional teams (e.g. Product, Finance, Marketing) to comprehend their data needs and translate them into actionable features.

• Provide mentorship and coaching to junior team members, define and delegate work, and collaborate with cross-functional stakeholders.

Data Governance and Quality Assurance:

• Ensure adherence to best practices, data governance standards, and optimal database structures and schemas.

• Develop and execute comprehensive data validation and testing procedures to ensure the accuracy and reliability of data outputs.

• Meticulously document the data sources, models, and pipeline with best practices in mind and ensure no barriers to this information.

Stakeholder Education and Training:

• Educate stakeholders on data best practices, usage guidelines, and the significance of maintaining data confidence.

Qualifications

We are looking for candidates who have at least 3 years of experience in data transformation using dbt and working with CRM (e.g. Salesforce, HubSpot). You have an expert knowledge of SQL and are proficient in cloud data warehousing (e.g., BigQuery, Snowflake, Databricks).

You also have:

• Solid understanding of database structures, schemas, and data modelling techniques.

• Familiarity with Modern Data Stack tools (e.g., Fivetran, dbt, Hightouch, Census).

• Experience with BI tools like Metabase for data visualization and reporting.

• Strong analytical and problem-solving skills.

• Excellent communication and interpersonal skills.

• Ability to mentor and coach junior team members.

• Familiarity with data governance principles and data quality assurance.

• Experience working in the SaaS industry.

Additional Information

Where You’ll Work
Our organization follows a hybrid work structure where employees work from the office three days/week. This role will be based out of our Ottawa office.

How Rewind Will Support You
We know that enjoying the journey is just as important as reaching our goals. We work hard to create a positive, inclusive environment where fun and laughter are part of our everyday routine. We also offer a variety of benefits to support your success both at work and in your personal life which includes but is not limited to: 

• Flexible work hours
• Employee stock options
• Health benefits
• 3 weeks vacation
• 7 life leave days
• 2 Level Up days for professional development
• 1 volunteer day
• Summer hours (off every other Friday from June - September) and office closed during the holiday break in December
• 4 week sabbatical after 4 years with us
• Paid parental leave
• $5000/year professional development allowance (you can take courses, buy books, attend conferences, cover certifications, etc)
• $1000/year wellness/home office allowance

Rewind is committed to building an inclusive, supportive place for you to do the best and most rewarding work of your career. We value how each new hire is an opportunity for us to bring in a different perspective, and we are always eager to further diversify our company. We strongly encourage candidates of all different backgrounds and identities to apply.