Data Analyst (Power BI)

Data Analyst (Power BI)

People Management: No

Travel Required: Minimal

Location: Markham, Ontario, Canada

Salary Range : CAD 110,000  – CAD 125,000

Join our Team:

DecisivEdge is a Company of talented consultants dedicated to identifying and addressing our Customer’s most pressing opportunities. We have offices in three geographies, Newark, Delaware, United States, Markham, Ontario Canada and Magarpatta, Pune, India. Our capabilities include optimizing operational business processes, application development, data management, analytics, and business intelligence which we leverage to enable digital transformations in financial services and healthcare. Our Company has developed and commercialized several solutions in a variety of industries including financial services, healthcare, and marine management.

We are looking for a talented and versatile Data Analyst to join our team and help us bring our vision to life. In this role, you will work in our Markham, Canada office as an integral member of our Technical Delivery team to ensure we increase our company’s success with our growing base of clients.

This role is based in our Markham, Ontario offices conveniently located near Highway 404 & 407. We are focused on team participation and commit to working a Full-Time schedule in our Markham office.

The Data Analyst will be part of a professional team that prioritizes its corporate culture focused on four foundational core values:

Put Integrity First

Think “We” not “Me”

Be Passionate

Execute Flawlessly 

Who We Need:

We are looking for a hands-on Data Analyst with strong Power BI expertise to help us turn raw data into clear, actionable insights for the business. In this role, you’ll be responsible for designing, building, and maintaining Power BI reports and dashboards, with a particular focus on Power BI embed capacity to support scalable, secure analytics experiences within our internal and customer-facing applications.
You will work closely with business stakeholders, data engineers, and other analysts to understand requirements, model data effectively, and deliver reporting solutions that are accurate, performant, and easy to use. This role is ideal for someone who enjoys both the technical side of BI development and the analytical side of interpreting results and telling the story behind the numbers.

What You’ll Do: 

• Design, develop, and maintain Power BI dashboards, reports, and datasets, ensuring they are visually clear, performant, and aligned with business needs.
• Configure and optimize Power BI embedded capacity, including workspace organization, capacity planning, performance tuning, and governance best practices.
• Work with stakeholders to understand their business (goals, objectives, processes) and operational systems, gather and refine business requirements, translating them into robust data models and reporting solutions.
• Develop and maintain SQL queries and scripts to extract, transform, and validate data from various source systems.
• Build and maintain relational data models (star/snowflake schemas, fact/dimension tables) to support scalable reporting and analytics.
• Perform exploratory data analysis to identify trends, anomalies, and opportunities, providing clear insights and recommendations to the business.
• Ensure data quality and consistency through validation checks, reconciliation, and collaboration with data engineering/IT teams.
• Document data sources, metrics definitions, report logic, and processes to support transparency and maintainability.
• Partner with cross-functional teams (e.g., Product, Finance, Operations, Technology) to drive data-informed decision-making.
• Stay current on Power BI features and best practices and share knowledge with the wider team.

What You’ll Need: 

• Bachelor’s Degree in Computer Science or related technical discipline; or equivalent combination of education, technical training, and work experience.
• Minimum three years of professional experience as a Data Analyst specializing in Advanced Power BI skills, including: Building complex dashboards, paginated reports (nice to have), and reusable datasets.
• Strong DAX knowledge for measures, calculated columns, and time-intelligence calculations.
• Experience with Power BI embed capacity (e.g., capacity planning, dedicated vs shared capacity, app workspaces, row-level security in embedded scenarios).
• Intermediate SQL proficiency, with the ability to: Write clean, optimized queries involving joins, subqueries, CTEs, aggregations, and window functions.
• Troubleshoot and improve inefficient queries.
• Solid understanding of relational database concepts and relational data modeling, including: Normalization/denormalization, Designing fact and dimension tables to support reporting.
• Demonstrated experience in data analysis, including: Translating business questions into analytical approaches, Interpreting data and presenting clear, concise insights and recommendations, Using data to validate hypotheses and measure the impact of initiatives.
• Strong attention to detail and commitment to data accuracy and integrity.
• Effective communication skills, able to explain technical concepts to non-technical stakeholders as well as being able to understand business concepts and translate them into robust technology solutions.

Nice-to-Have Skills

• Experience building dashboards and visualizations in Qlik Sense.
• Experience with Tableau for data visualization and reporting.
• Exposure to other Azure data services (e.g., Azure SQL Database, Synapse, Data Factory) or similar cloud platforms.
• Familiarity with version control (e.g., Git) for managing BI assets.
• Experience working in an Agile or iterative delivery environment.
• Experience working with Databricks 
• Experience working with Salesforce Administration

Location & Work Schedule

This role is primarily office-based. Remote or hybrid work arrangements may be approved in limited circumstances based on business needs, role requirements, client expectations, and provincial considerations.

Remote work arrangements are subject to ongoing business requirements and may be modified or discontinued in accordance with company policy. Employees working remotely must comply with all company policies related to confidentiality, data protection, information security, and occupational health and safety.

Equal Opportunity & Accessibility (AODA/ADA)

DecisiveEdge is an equal opportunity employer committed to diversity and inclusion. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation (including pansexuality and asexuality), gender identity, national origin, disability, genetic information, pregnancy, reproductive health decisions, or any other protected characteristic as outlined by federal, state, or provincial laws.

In accordance with the Accessibility for Ontarians with Disabilities Act, 2005 (AODA), and the Americans with Disabilities Act (ADA) DecisivEdge will provide reasonable accommodations throughout the recruitment, selection, and/or assessment process to applicants with disabilities. If selected to participate in the recruitment process, please inform our Human Resources team of any accommodation(s) that you may require.

What We Offer

• Mentorship and on-the-job training
• Exposure to real-world healthcare projects
• Career growth and professional development opportunities
• Collaborative, mission-driven work environment
• Competitive salary and benefits package