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.
Skills Required
- 3-6+ years building end-to-end Power BI solutions
- 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
What We Do
AIM is a specialized company providing a wide range of API management solutions and services to ensure optimal performance and security for businesses. Key offerings include API Health Check, which addresses vulnerabilities and potential improvements; Managed Support Services for active API management software maintenance; and Dedicated API Expert Support for personalized assistance. AIM also offers Certified Trainers for API strategy, design, and management, as well as Custom Approach to Training tailored to specific business needs. To maximize ROI, AIM provides Upgrade Service, assisting teams in transitioning to the latest product versions with training and knowledge transfer. With a proactive approach, AIM offers 24/7 infrastructure monitoring and operational support during business hours. Other services include Native Monitoring with a log analyzer for security threats, Threat and Risk Assessments (TRA) for enterprise-wide and system-specific evaluations, Technical Vulnerability Assessment and Penetration Testing for network infrastructure, computing layer, and application layer assessments, and Information Security Health Check for evaluating critical security elements and providing improvement recommendations. By offering a comprehensive suite of services tailored to the unique needs of businesses relying on API management solutions, AIM helps organizations stay competitive and secure in the fast-paced digital economy.
