Data & BI Specialist transforming raw data into business insights for marketing and commercial areas. Collaborating on data analysis and automating processes in SQL and Google Sheets.
About the role
- Power BI Consultant at a Canadian technology company delivering high-performance BI solutions. Engage stakeholders, design models, and collaborate with data engineering.
Responsibilities
- Engage stakeholders to capture requirements and convert them into BI specifications and data models.
- Design star/snowflake models with conformed dimensions and surrogate keys.
- Build optimized DAX (time intelligence, iterator patterns, context transition) and reusable calculation logic.
- Develop ETL/ELT using Power Query (M), Dataflows, and SQL; implement incremental refresh and partitions.
- Choose and justify Import vs. DirectQuery vs. Composite based on latency, volume, and SLA.
- Publish and manage content in Power BI Service (Workspaces, Apps, Dataflows, Gateways, Deployment Pipelines).
- Implement Row‑Level Security (RLS) / Object‑Level Security (OLS) and workspace governance.
- Optimize models and reports (cardinality reduction, aggregations, query folding, Performance Analyzer, DAX Studio).
- Create executive and operational dashboards with drill‑through, tooltips, bookmarks, and KPI storytelling.
- Partner with data engineering (SQL/Azure/Fabric) on pipelines, Lakehouse/Warehouse, and data quality.
- Maintain documentation: data dictionary, lineage, refresh SLAs, and runbooks.
- Support production, monitor refreshes/capacity, and drive continuous improvement and user enablement.
Requirements
- 3–6+ years building end‑to‑end Power BI solutions (modeling, DAX, visuals, deployment).
- Strong SQL (CTEs, window functions, query tuning).
- Advanced DAX (CALCULATE, filter context, iterators, time intelligence).
- Solid Power Query (M) with understanding of query folding.
- Proven experience with RLS/OLS, incremental refresh, DirectQuery/Composite models.
- Proficiency with Power BI Service (Workspaces, Apps, Dataflows, Gateways, Deployment Pipelines).
- Performance tuning using Performance Analyzer and DAX Studio / VertiPaq Analyzer.
- Clear communication and stakeholder management skills.
Benefits
- Equal Opportunity
- Hybrid work arrangement
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
No Education Requirement
Tech skills
Location requirements
Data Analytics Engineer supporting development and maintenance of Exasol's data infrastructure and reporting solutions. Collaborating across teams to transform data into actionable insights.
Junior PowerBI Developer responsible for creating advanced data solutions. Joining SDG Group, a global leader in Data & Analytics consulting.
Power BI Engineer contributing to the development of reports and dashboards. Supporting testing activities for a global mining client with a focus on data science and AI.
Senior Business Intelligence Analyst supporting client insights and delivering high - impact analysis at Cox Automotive. Collaborating across teams to drive client success through actionable insights.
Senior BI Developer creating data - driven insights and services for sonnen's clean energy solutions. Collaborating with cross - functional teams to enhance product offerings through data visualization.
DWH / BI Consultant focusing on ETL processes at GPI Consulting GmbH. Responsible for developing ETL structures, data modeling, and optimizing data marts in a hybrid work environment.
Power BI Developer at Bridge Specialty Group creating advanced dashboards and reports with performance optimization. Collaborating with stakeholders to provide insightful analytics solutions.
Qlik BI Engineer for the healthcare market, focusing on data solutions and dashboards. Collaborating within the engineering team to turn complex data into valuable insights and reports.
Join NORRIQ as a Junior BI Consultant to develop data insights via Microsoft tools. Engage with clients to enhance their data - driven decision - making processes in a hybrid role.