OSI Digital
Data Engineer / BI Developer – GCP, dbt & Power BI
- Compensation
- Not disclosed
- Location
- Vancouver, BC
- Work setup
- Not specified
- Seniority
- Not specified
- Employment
- Full time
- Experience
- 2+ years
- Category
- Data engineering
- Posted
Skills
Must have
- 2–4 years of experience in Data Engineering, Business Intelligence, or Analytics Engineering.
- Strong hands-on experience with Google BigQuery.
- Hands-on experience developing and maintaining Apache Airflow DAGs.
- Good experience with dbt Core or dbt Cloud.
- Strong knowledge of SQL and query optimization.
- Hands-on experience with Power BI.
- Good understanding of: Power Query DAX Data modeling Power BI Service Dataset / semantic model refresh Row-Level Security (RLS)
- Understanding of ETL/ELT architecture and data warehousing concepts.
- Experience working with fact and dimension models and star-schema-based reporting solutions.
- Knowledge of data validation, reconciliation, and troubleshooting techniques.
- Experience using Git or similar version-control tools.
Nice to have
- Snowflake and Databricks
- Primary Technology Stack:
- Additional Advantage:
Full description
Job Title: Data Engineer / BI Developer – GCP, dbt & Power BIExperience: 3–5 Years
Employment Type: Full-Time
Location: Vancouver, BC Canada
Job Summary
We are looking for a Data Engineer / BI Developer with 2–4 years of experience in building cloud-based data pipelines, transformation frameworks, and analytical reporting solutions.
The ideal candidate should have hands-on experience with Google BigQuery, Apache Airflow, dbt, SQL, and Power BI, along with a good understanding of data warehousing, ETL/ELT processes, data modeling, and dashboard development.
Key Responsibilities
- Design, develop, and maintain scalable data pipelines using Apache Airflow.
- Develop and optimize data warehouse solutions using Google BigQuery.
- Build reusable and maintainable transformation models using dbt.
- Develop interactive reports and dashboards using Power BI.
- Write complex and optimized SQL queries for extraction, transformation, validation, and reporting.
- Create and maintain dimensional models, fact tables, views, and reporting datasets.
- Develop dbt models, tests, documentation, macros, and incremental processing logic.
- Monitor Airflow DAGs and troubleshoot pipeline and data-quality issues.
- Optimize BigQuery queries for performance and cost efficiency.
- Build Power BI semantic models, relationships, measures, calculated columns, and DAX calculations.
- Perform source-to-target validation and data reconciliation.
- Implement data-quality checks to ensure reliable and consistent reporting.
- Participate in code reviews, deployments, testing, and production support.
- Maintain technical documentation for pipelines, transformations, datasets, and dashboards.
Required Skills
- 2–4 years of experience in Data Engineering, Business Intelligence, or Analytics Engineering.
- Strong hands-on experience with Google BigQuery.
- Hands-on experience developing and maintaining Apache Airflow DAGs.
- Good experience with dbt Core or dbt Cloud.
- Strong knowledge of SQL and query optimization.
- Hands-on experience with Power BI.
- Good understanding of:
- Power Query
- DAX
- Data modeling
- Power BI Service
- Dataset / semantic model refresh