Analytics Engineer
Description For Analytics Engineer
Named #4 startup in Canada for 2024, Hiive is a fintech/marketplace startup connecting buyers and sellers of stock in venture-backed pre-IPO companies. As an Analytics Engineer at Hiive, you will help expand data capabilities to empower informed decision-making and enhance operational efficiency. You'll collaborate with data team leadership and business stakeholders to educate and enable teams to leverage data effectively. Your responsibilities will include working across the entire lifecycle of data, collaborating with cross-functional teams, enforcing data governance policies, completing code reviews, building BI solutions, maintaining data transformation layers, and promoting a data-driven culture.
Required Skills:
- 2+ years of experience as an analytics/data engineer or similar role
- Experience with SQL, cloud-based data warehouses, dbt, ETL tools, code-based BI tools, and Kimball data modelling
- Experience with Snowflake and dbt
- Experience with query optimization and tuning
- Experience executing data management policies
- Experience with marketing, financial, product, and operational data reporting
Preferred Skills:
- Ability to work in Python and support data orchestration with tools like Airflow or Dagster
- Experience with Postgres, Fivetran, Hightouch, and Metabase, or similar tools
- Experience in marketplaces and highly regulated industries
Hiive offers competitive compensation, benefits, and perks, including stock options, comprehensive health coverage, a dedicated workspace in Vancouver, BC, commuter benefits, social events, and opportunities for growth. The company is committed to fostering an inclusive workplace and offers sponsorship, immigration, and relocation for exceptional candidates.
Responsibilities For Analytics Engineer
- Work across the entire lifecycle of data at Hiive from data source to serving use cases
- Collaborate with cross-functional business teams to gather data needs and efficiently deliver on tasks
- Enforce data governance policies and best practices
- Complete code reviews to maintain best practices and production quality data pipelines
- Build BI solutions that help to deliver insights across every aspect of the business
- Maintain a high quality data transformation layer in dbt
- Build and maintain highly flexible and performant data models
- Promote a culture of data-driven decision-making and innovation
Requirements For Analytics Engineer
- 2+ years of experience as an analytics/data engineer or similar role
- Experience with SQL, cloud-based data warehouses, dbt, ETL tools, code-based BI tools and Kimball data modelling
- Experience with core tools in our data stack being Snowflake and dbt
- Experience with query optimization and tuning
- Experience executing on data management policies for ensuring data integrity and data governance
- Experience with marketing, financial, product and operational data reporting
Benefits For Analytics Engineer
- Competitive salary
- Employee stock option plan
- 100% employer-paid health and dental premiums
- Health and personal spending account
- Dedicated desk in Vancouver HQ
- Commuter benefit
- Social events and team building
- Growth opportunities
- Sponsorship, immigration, and relocation for exceptional candidates
