Working with project teams to ensure successful release of Business Intelligence reporting using Power BI, the candidate will be responsible for:
- 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
- Use M and DAX language to create measures
- Ensure high performance of Power Query data retrieval tasks
- Create Power BI report designs and report formatting, including report navigation
- Examine, sort and present data using Power BI in a cohesive manner.
- Leverage statistical summaries of data and facilitate export of data from Power BI when required.
- Apply and perform advanced analytics on reports for deeper and more meaningful data insights.
- Leverage workspaces in the Power BI service.
- Deploy Power BI artifacts to workspaces and enable sharing to users.
- Connect Power BI reports to on-premise data sources.
- Configure automatic refresh for Power BI datasets.
- Enable Row-level security
- Understand the report users needs and their requirements
- Develop reports all the way into production.
- Work with the project team in completing all relevant and required documentation in alignment with policies/standards.
What you need:
- Proven experience as a Microsoft Power BI developer, building Business Intelligence reports and dashboards
- Demonstrated experience with M, DAX and Power Query
- Knowledge of Microsoft Azure ecosystem
- 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