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.
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.
Where You’ll Work
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:
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.
