Power BI Snowflake Developer
Mississauga - Canada
Job Summary
Role: Power BI Snowflake Developer (Finance Technology)
Location: Montreal (Hybrid 3 days onsite)
Duration: 6 Months
Note: Local candidates only Face-to-face required Background check mandatory
Seeking an experienced Power BI Snowflake Developer to build and optimize data pipelines in Snowflake and develop high-quality Power BI semantic models reports and dashboards for business decision-making.
Key ResponsibilitiesSnowflake & Data Engineering
- Design and maintain dimensional models (star/snowflake schemas)
- Develop and optimize complex SQL views and stored procedures
- Build and manage ELT/ETL pipelines
- Implement data quality validation and reconciliation processes
- Manage Snowflake objects and optimize query performance
Power BI Development
- Build semantic models datasets and dashboards
- Develop DAX measures and use Power Query (M)
- Optimize performance (aggregations incremental refresh)
- Implement Row-Level Security (RLS)
Collaboration
- Gather requirements and translate into data solutions
- Document models and reports
- Train users and support self-service BI
- Participate in Agile processes
- 5 years in data warehousing and dimensional modeling
- 5 years with Power BI (DAX Power Query)
- Strong SQL and Snowflake experience
- Experience with ETL/ELT pipelines
- Strong analytical and communication skills
- Snowflake advanced features (Time Travel Cloning etc.)
- Experience with orchestration tools (e.g. Airflow)
- Git/version control experience