Data Analytics Engineer

Full Timemid

Edmonton, Alberta, CAPosted 9 weeks ago

Resume Keywords to Include

Make sure these keywords appear in your resume to improve ATS scoring

PythonSQLSnowflakeBigQueryGitAirflowdbtCI/CD

Title: Data Analytics Engineer

Duration: Long term

Location: Remote/Canada

Design and implement robust dimensional and relational data models.
Build and maintain scalable dbt transformation pipelines.
Own transformation and modeling of curated (Silver/Gold) datasets.
Collaborate with analysts, product analytics, data scientists, and stakeholders.
Implement data quality tests, monitoring, SLAs, and alerting.
Partner with Data Engineers to define and enforce data contracts.
Follow analytics engineering best practices (version control, testing, documentation).
Empower self-service analytics with intuitive, well-documented data marts.

5+ years in analytics engineering, data modeling, or similar roles.
Expert-level SQL skills (optimization & performance tuning).
Extensive dbt experience (testing, documentation, package management).
Strong Python programming skills.
Deep understanding of dimensional modeling (star schemas, one big table).
Experience with cloud data warehouses (Snowflake, BigQuery, Redshift, Databricks).
Familiarity with Airflow and orchestration frameworks.
Experience with Git and CI/CD for analytics code.
Strong business acumen and ability to translate requirements into data models.
Knowledge of data governance, privacy, compliance (GDPR, CCPA, SOX).
Familiarity with BI tools (Tableau, Looker, Mode).
Strong ownership mindset and communication skills.
Dedication to data quality, documentation, and enabling self-service analytics.
Bachelor's Degree in a technical field, or equivalent experience.