Role: Power BI Snowflake Developer (Finance Technology)Work location: Montreal/ Hybrid / FACE TO FACE REQUIRED / LOCAL CANDIDATES ONLYDuration: 09+ MonthsPay Rate: $50/hr. Inc and $38/hr. T4JOB DESCRIPTION:Role Name: Power BI Snowflake Developer (Finance Technology)Location: Montreal/ Hybrid / FACE TO FACE REQUIRED / LOCAL CANDIDATES ONLYJob 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 qualified who can build and optimize data pipelines in Snowflake and design compelling Power BI semantic models and reports that drive business decisionmakingResponsibilitiesData Warehouse Snowflake Development1 Design develop and maintain dimensional models star and snowflake schemas within Snowflake to support enterprise reporting and analytics2 Write and optimize complex SQL for data transformations stored procedures and views in Snowflake3 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 consumers4 Build and maintain ELTETL pipelines that ingest cleanse and transform data from multiple source systems into Snowflake5 Implement and enforce data quality checks validation rules and reconciliation processes to ensure data integrity6 Manage Snowflake objects including databases schemas warehouses stages tasks and streams7 Monitor and improve query performance in Snowflake using query profiling warehouse sizing clustering keys and resource optimization techniquesPower BI Semantic Modeling Reporting8 Design and build Power BI semantic models using dimensional modeling best practices including welldefined measures hierarchies and relationships9 Develop DAX measures for presentationlayer KPIs calculations and business metrics that complement the transformations maintained in Snowflake10 Use Power Query M for lightweight data shaping and connectivity within semantic models keeping heavy transformations in Snowflake11 Design develop and publish interactive Power BI reports and dashboards that provide clear actionable insights to stakeholders12 Optimize semantic model performance through aggregations query reduction and incremental refresh strategies13 Establish and maintain rowlevel security RLS and data governance standards within Power BICollaboration Support14 Partner with business stakeholders to gather requirements and translate them into technical data models and visualizations15 Document data models semantic model designs data lineage and report specifications for ongoing maintenance16 Train endusers on dashboards and selfservice reporting capabilities17 Participate in agile ceremonies and contribute to sprint planning backlog grooming and retrospectivesRequirements1 Bachelors degree in Computer Science Information Systems or a related field2 5 years of experience in dimensional modeling and data warehouse concepts star schema snowflake schema slowly changing dimensions surrogate keys3 5 years of experience building Power BI semantic models Power Pivot datasets with DAX and Power Query M4 Handson experience writing advanced SQL and managing data warehouse objects in Snowflake5 Proven ability to design Power BI reports and dashboards that balance visual clarity with analytical depth grounded in strong data visualization principles6 Experience with ELTETL processes and data pipeline development7 Strong analytical and problemsolving skills with a keen eye for detail8 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 objectives9 Ability to thrive in an agile fastpaced environment where testing accuracy and data validation are essential10 Ability to work independently as well as collaboratively within a global team environment11 Excellent communication and interpersonal skillsPreferred Qualifications1 Experience with advanced Snowflake features such as time travel zerocopy cloning data sharing and materialized views2 Experience with Apache Airflow or similar tools for data pipeline orchestration3 Experience with Gitbased version control for SQL and Power BI projectsWe offerAn engaging and collaborative working environment where team knowledge is shared ideas are welcomed and where colleagues are friendly helpful and support one anotherEnriching challenges that provide opportunity for constant learningTeam 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 itemsJoin our team and play a pivotal role connecting Snowflake data engineering with Power BI analytics to deliver trusted highimpact reporting across the organization "

📌 Senior Business Intelligence Developer - $50 An Hour (Cambridge)
🏢 eTeam
📍 Cambridge