Power BI and SQL expertise define this on-site Data Analyst opportunity in Ottawa, supporting dashboards, reporting, and business insights.
This junior-to-mid-level Data Analyst designs and maintains analytical solutions for a complex operational environment. You will work with Microsoft Fabric, Azure Data Services, dimensional models, and Python/Pandas. Clear communication, listening, and stakeholder understanding are essential when translating requirements into useful reporting solutions.
Key Responsibilities:
- Design and maintain Power BI dashboards, reports, and performance metrics
- Develop SQL queries for extracting, transforming, and analyzing data
- Build dimensional and semantic models for reporting and analytics
- Translate stakeholder requirements into effective analytical solutions
- Communicate findings as clear, actionable business insights
Requirements:
- Three or more years in data analysis or business intelligence
- Three or more years developing Power BI reports and dashboards
- Strong SQL skills with large datasets
- Experience with Microsoft Fabric or comparable cloud analytics platforms
- Experience using Python/Pandas and dimensional data modelling
Bring Power BI, SQL, Microsoft Fabric, and stakeholder communication skills to Data Analyst work in Ottawa.
Power BI Data Analyst Ottawa employer: Myticas Consulting
At Myticas Consulting, we pride ourselves on fostering a collaborative and innovative work culture that empowers our employees to excel in their roles. As a Senior Security Testing Engineer, you will not only have the opportunity to lead critical security initiatives but also benefit from ongoing professional development and mentorship programs. Located in a vibrant tech hub, we offer competitive compensation, flexible work arrangements, and a commitment to work-life balance, making us an exceptional employer for those seeking meaningful and rewarding careers in cybersecurity.