Power BI Analyst

Job Description

Level 2

We are seeking a talented and detail-oriented Power BI Analyst to join our team on a temporary contract.
The successful candidate will be responsible for developing insightful reports and dashboards using Power BI.
This role will support decision-making by analyzing data, creating meaningful reports, and ensuring data integrity and accuracy.

Key Responsibilities:
– Report and Dashboard Development: Design, build, and deploy Power BI reports and dashboards based on business needs. Create interactive visualizations and reports using Power BI that provide insights into KPIs and KRIs.
– Data Modeling: Create and maintain complex data models that drive report insights. Integrate data from various sources including APIs, databases, Excel/CSV files, into Power BI for report generation.
– Data Analysis: Perform in-depth data analysis using Power BI and other tools to support strategic business decisions. Collaborate with various teams to define and gather report requirements.
– Stakeholder Collaboration: Work closely with business stakeholders to understand their data and reporting needs. Provide support to users on Power BI tools, ensuring they can maximize the use of reports and dashboards.
– Data Quality and Governance: Ensure data quality and accuracy by identifying data discrepancies and implementing solutions to improve data integrity. Collaborate with IT and data governance teams to maintain data security and best practices.
– Optimization: Monitor and optimize Power BI performance and resolve issues related to report generation or data accessibility.

Required Skills & Qualifications:
• 3-5 years hands-on experience working with Power BI in a business intelligence or data analyst role
• Strong understanding of Power BI desktop, Power BI service, and Power Query
• Proficiency in data modeling, DAX Expressions, and visualization best practices
• Experience with RLS and automated report refresh schedules in Power BI
• Experience with Excel and VBA
• Experience in working with large datasets from various data sources
• Experience with Python an asset
• Experience with Unix and Windows terminal an asset
• Independent self-starter
• Excellent communication skills

Desired skills:
– Experience in working with large datasets from various data sources.
– Familiarity with cloud platforms (e.g., Azure, AWS, Google Cloud) for data integration.
– Knowledge of Agile or Scrum methodologies.