Power BI Consultant

Confidential

Any, Any Hybrid part_time

Posted: March 17, 2026

Quick Summary

We are looking for a Power BI Consultant to join our team and help modernize our data visualization capabilities. The ideal candidate should have strong analytical and technical skills, with experience in Power BI and data analysis. The successful candidate will be responsible for developing and implementing data visualization solutions that meet business requirements.

Required Skills

Job Description

Power BI Consultant

Location: Remote

Job Type: Contract

About AIM

AIM is a Canadian technology company that helps organizations modernize their systems through advanced API management, cloud engineering, security solutions, and full-stack software development. Our teams work across North America and globally, delivering stable, scalable, and secure digital platforms for enterprise clients.

We take pride in being hands-on, collaborative, and focused on delivering real results for our clients. As we grow, we are expanding our marketing team to strengthen our brand presence and support our next stage of growth.

Role Summary

We’re looking for a hands‑on Power BI Consultant to design, model, and deliver high‑performance BI solutions. You will translate business requirements into robust semantic models, efficient DAX measures, and impactful dashboards, while ensuring governance, performance, and security in Power BI Service.

Key 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.

Required Qualifications

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.

Nice to Have

Microsoft Fabric (Lakehouse, Warehouse, Dataflows Gen2) or Azure (Synapse, Data Lake, Databricks, ADF).

Tabular modeling tools (Tabular Editor, TOM/TMSL, calculation groups).

CI/CD for BI (Git, Azure DevOps, Deployment Pipelines).

Python/R for analytics; Power Automate integration.

Certification: PL‑300 (or equivalent).

Tools & Stack

Power BI Desktop & Service, DAX Studio, Tabular Editor, SQL Server/Azure SQL, Power Query (M), Fabric/Synapse (nice‑to‑have), Git/DevOps, Excel (Power Pivot).

Work Schedule

Ability to wrk on Eastern Time Zone, Remotely.

Equal Opportunity

We value diversity and provide equal opportunities without regard to religion, gender, age, disability, or national origin.

Why Apply Through MisuJob?

AI-Powered Job Matching: MisuJob uses advanced artificial intelligence to analyze your skills, experience, and career goals. Our matching algorithm compares your profile against thousands of job requirements to find positions where you have the highest chance of success. This saves you hours of manual job searching and ensures you only see relevant opportunities.

One-Click Applications: Once you create your profile, applying to jobs is effortless. Your resume and cover letter are automatically tailored to highlight the most relevant experience for each position. You can apply to multiple jobs in minutes, not hours.

Career Intelligence: Beyond job matching, MisuJob provides valuable career insights. See how your skills compare to market demands, identify skill gaps to address, and understand salary benchmarks for your experience level. Make data-driven decisions about your career path.

Frequently Asked Questions

How do I apply for this position?

Click the "Register to Apply" button above to create a free MisuJob account. Once registered, you can apply with one click and track your application status in your dashboard.

Is MisuJob free for job seekers?

Yes, MisuJob is completely free for job seekers. Create your profile, get matched with jobs, and apply without any cost. We help you find your dream job without any hidden fees.

How does AI matching work?

Our AI analyzes your resume, skills, and experience to understand your professional profile. It then compares this against job requirements using natural language processing to calculate a match percentage. Higher matches mean better fit for the role.

Can I apply to jobs in other countries?

Absolutely. MisuJob features jobs from companies worldwide, including remote positions. Filter by location or look for remote opportunities to find jobs that match your preferences.

Ready to Apply?

Join thousands of job seekers using MisuJob's AI to find and apply to their dream jobs automatically.

Interested in this position?