The Role
Design and build Power BI reports, datasets and data models. Extract, profile, clean and load data using Power Query and SQL Server. Partner with stakeholders to capture requirements, ensure IT standards, support testing/UAT, and perform knowledge transfer. Perform performance tuning, refresh management and deliver documentation and visualizations for varied audiences.
Summary Generated by Built In
Deliverables:
- Create Power BI report(s), data models
- Undertake special assignments/sub-projects as assigned
- Conduct, assess, evaluate and document stakeholder interests
and business needs
- Ensure alignment and adherence to IT processes and standards
- Support the testing team during system and UAT testing
- Participate in Knowledge transfer
Skills and Knowledge:
- Proven experience as a Microsoft Power BI developer,
building Business Intelligence reports and dashboards
- Demonstrated experience with M, DAX and Power Query
- Demonstrated knowledge and experience with Microsoft Azure
ecosystem, Power BI service, Azure Datafactory, SQL Server
- Proven experience with SQL Server and other database
technologies
- Proven, demonstratable experience in data modeling and data
visualization; working with different data schemas and BI implementation
methodologies
- Knowledge of data analysis, data management
- Proven ability to partner with internal/external
stakeholders and liaise with technical experts and non-technical colleagues
- Experience in understanding, capturing, and analyzing
complex and sometimes competing business requirements to develop Power BI and
Business Intelligence products
- Excellent verbal and written communication skills,
interpersonal and facilitation skills
- Strong written, presentation and interpersonal communication
skills with special attention to correct use of tense, grammar/spelling and
terminology
- Demonstrated effective time management and organizational
skills, including the ability to plan and prioritize workload, ensuring
timelines are met and respond to demands of a dynamic environment
- Mandatory Requirements: At least 5 years of experience
- All roles procured are required to be cleared through the
Contractor Security Clearance Process of the OPS.
- Security Clearance process, levels, roles etc. are subject
to change without prior notice. Candidates may be required to undergo
revised/new process (or levels) any time prior or during the term of the
contract.
Requirements
Experience and Skill Set Requirements:
Must Haves:
- Proven work experience as a Power BI Report Developer
- Demonstrated experience with M, DAX and Power Query
- Knowledge of Microsoft Azure ecosystem and the Power
Platform
- Proven experience with SQL Server and Power BI Datasets
- Proven, demonstratable experience in data modeling and data
visualizations for Power BI; working with different data schemas and BI
implementation methodologies
Skill Set Requirements:
Mandatory Requirements:
- Use Power Query to extract data from different data sources
and choose a storage mode and connectivity type.
- Profile, clean, and load data into Power BI
- Design data models that are intuitive, high-performing, and
simple to maintain
- Create compelling Power BI report designs and report
formatting, including report navigation for all audience types (executive,
operational)
- Examine, sort and present data using Power BI in a cohesive
manner
- Connect Power BI reports to data sources
Technical Skills:
- Proven work experience as a Power BI Report Developer
- Demonstrated experience with M, DAX and Power Query
- Demonstrated knowledge of Microsoft Azure ecosystem and the
Power Platform, including Azure Data Factory
- Proven experience with SQL Server and Power BI Datasets
- Proven, demonstratable experience in data modeling and data
visualizations for Power BI; working with different data schemas and BI
implementation methodologies
- Knowledge of data analysis, data management
- Experience in understanding, capturing, and analyzing
complex and sometimes competing business requirements to develop Power BI and
Business Intelligence products
- Demonstrated experience with performance tuning in Power BI
including measures, relationships and visuals
- Demonstrated experience with data sources for Power BI
including DirectQuery, Import and appropriate Considerations and limitations
- Demonstrated experience with Power BI datasets
- Demonstrated experience with Power BI refresh
Documentation, Collaboration & Communication Skills:
- Ability to partner with internal/external stakeholders and
liaise with technical experts and non-technical colleagues, regarding project
deliverables
- Proven experience in developing documentation
- Demonstrated experience collaborating with Developers,
Testers and Program Managers
- Proven experience in producing diagrams, videos, and other
visual content
- Experience analyzing customer feedback and responding to it
to improve the customer experience
- Experience in bringing clarity to complex business
challenges and conflicting articulation of business issues through techniques
that result in common understanding of the issues, as well as agreement on
business process requirements vs technology requirements to solve the issues.
- Experience in understanding, capturing, and analyzing
complex and sometimes competing business requirements to develop Business
Intelligence products
- Excellent verbal and written communication skills,
interpersonal and negotiation skills
- Facilitation skills, Interpersonal and consultative skills
- Stakeholder management skills. Demonstrated strong
problem-solving and organizational skills
- A team player with a track record for meeting
deadlines.
- Working knowledge and experience developing reports for use
by a wide spectrum of stakeholders
- Strong written, presentation and interpersonal communication
skills with special attention to correct use of tense, grammar/spelling and
terminology.
- Demonstrated effective time management and organizational
skills, including the ability to plan and prioritize workload, ensuring
timelines are met and respond to demands of a dynamic environment
Skills Required
- At least 5 years of relevant experience
- Proven work experience as a Power BI Report Developer
- Demonstrated experience with M (Power Query), DAX and Power Query
- Knowledge of Microsoft Azure ecosystem and the Power Platform (including Azure Data Factory and Power BI Service)
- Proven experience with SQL Server and Power BI Datasets
- Proven experience in data modeling and data visualizations for Power BI
- Experience with Power BI performance tuning (measures, relationships, visuals)
- Experience with Power BI data connectivity modes including DirectQuery and Import and associated considerations
- Experience with Power BI refresh management
- Use Power Query to extract, profile, clean, load data and select storage mode/connectivity
- Design intuitive, high-performing, maintainable data models
- Create compelling Power BI report designs and navigation for executive and operational audiences
- Ability to partner with stakeholders and liaise with technical and non-technical colleagues
- Excellent verbal and written communication, documentation and presentation skills
- Demonstrated time management, organizational and stakeholder management skills
- Must be cleared through the Contractor Security Clearance Process of the OPS (security clearance required)
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Maarut Inc. is a Canadian company specializing in IT services, technology staffing, and software development, dedicated to assisting businesses with digital transformation and solving business challenges through technology.
.png)







