Role: Power BI Snowflake Developer (Finance Technology)
Work location: Montreal/ Hybrid / FACE TO FACE REQUIRED / LOCAL CANDIDATES ONLY
Duration: 09+ Months
Pay Rate: $50/hr. Inc and $38/hr. T4
JOB DESCRIPTION:Role Name: Power BI Snowflake Developer (Finance Technology)
Location: Montreal/ Hybrid / FACE TO FACE REQUIRED / LOCAL CANDIDATES ONLY
Job DescriptionWe are seeking an experienced Power BI Snowflake Developer to join our data analytics team This role bridges data warehouse development and business intelligence requiring a professional who can build and optimize data pipelines in Snowflake and design compelling Power BI semantic models and reports that drive business decisionmaking.
ResponsibilitiesData Warehouse Snowflake Development- Design develop and maintain dimensional models star and snowflake schemas within Snowflake to support enterprise reporting and analytics
- Write and optimize complex SQL for data transformations stored procedures and views in Snowflake
- Push calculations and transformations upstream into Snowflake eg computed columns aggregations business logic to reduce complexity in Power BI semantic models and maximize reusability across consumers
- Build and maintain ELTETL pipelines that ingest cleanse and transform data from multiple source systems into Snowflake
- Implement and enforce data quality checks validation rules and reconciliation processes to ensure data integrity
- Manage Snowflake objects including databases schemas warehouses stages tasks and streams
- Monitor and improve query performance in Snowflake using query profiling warehouse sizing clustering keys and resource optimization techniques
Power BI Semantic Modeling Reporting- Design and build Power BI semantic models using dimensional modeling best practices including welldefined measures hierarchies and relationships
- Develop DAX measures for presentationlayer KPIs calculations and business metrics that complement the transformations maintained in Snowflake
- Use Power Query M for lightweight data shaping and connectivity within semantic models keeping heavy transformations in Snowflake
- Design develop and publish interactive Power BI reports and dashboards that provide clear actionable insights to stakeholders
- Optimize semantic model performance through aggregations query reduction and incremental refresh strategies
- Establish and maintain rowlevel security RLS and data governance standards within Power BI
Collaboration Support- Partner with business stakeholders to gather requirements and translate them into technical data models and visualizations
- Document data models semantic model designs data lineage and report specifications for ongoing maintenance
- Train endusers on dashboards and selfservice reporting capabilities
- Participate in agile ceremonies and contribute to sprint planning backlog grooming and retrospectives
Requirements- Bachelors degree in Computer Science Information Systems or a related field
- 5 years of experience in dimensional modeling and data warehouse concepts star schema snowflake schema slowly changing dimensions surrogate keys
- 5 years of experience building Power BI semantic models Power Pivot datasets with DAX and Power Query M
- Handson experience writing advanced SQL and managing data warehouse objects in Snowflake
- Proven ability to design Power BI reports and dashboards that balance visual clarity with analytical depth grounded in strong data visualization principles
- Experience with ELTETL processes and data pipeline development
- Strong analytical and problemsolving skills with a keen eye for detail
- Ability to learn and understand business processes in order to effectively engage with clients and stakeholders translate their needs into technical requirements and deliver solutions aligned with business objectives
- Ability to thrive in an agile fastpaced environment where testing accuracy and data validation are essential
- Ability to work independently as well as collaboratively within a global team environment
- Excellent communication and interpersonal skills
Preferred Qualifications- Experience with advanced Snowflake features such as time travel zerocopy cloning data sharing and materialized views
- Experience with Apache Airflow or similar tools for data pipeline orchestration
- Experience with Gitbased version control for SQL and Power BI projects
We offerAn engaging and collaborative working environment where team knowledge is shared ideas are welcomed and where colleagues are friendly helpful and support one another
Enriching challenges that provide opportunity for constant learning
Team profileThis position sits within the Finance Technology Super Department You will interface with team members and team leads located in Montreal NY Budapest Mumbai and Bangalore The team works in an agile environment delivering current projects as well as prioritized and backlog items
Join our team