The role of the Power BI Developer involves designing, developing, and maintaining Power BI reports and dashboards, ensuring they meet the data visualization needs of our organization. The ideal candidate will possess strong analytical skills, a keen eye for detail, and a passion for creating impactful data visualizations. This position is crucial for supporting data-driven decision-making across various departments.
Responsibilities
- Report and Dashboard Development:
- Design, develop, and maintain Power BI reports, dashboards, and paginated reports to meet business requirements.
- Create visually compelling and interactive data visualizations.
- Data Modeling:
- Develop and maintain data models to support Power BI reporting.
- Ensure data accuracy, consistency, and integrity in the Power BI environment.
- Query Optimization:
- Optimize Power BI queries to enhance report performance.
- Identify and resolve performance issues in collaboration with data engineers and database administrators.
- Data Integration:
- Collaborate with ETL developers to integrate Power BI reports with data from various sources.
- Ensure seamless data flow between ETL processes and Power BI.
- User Training and Support:
- Provide training sessions for end-users on navigating and utilizing Power BI reports and dashboards.
- Offer support to users, addressing queries and troubleshooting issues related to Power BI.
- Collaboration:
- Collaborate with business analysts, analysts, and other stakeholders to understand reporting requirements.
- Work closely with the IT team to integrate Power BI into the overall data architecture.
- Documentation:
- Document Power BI report specifications, data models, and other relevant information.
- Maintain up-to-date documentation for ongoing and future development.
Qualifications
- Bachelor's degree in Computer Science, Information Technology, or a related field
- Power BI certification desirable
- Five years of work experience in data and analytics with exposure to SQL Server.
- Three years of experience with Power BI modelling, architecture, and design which includes Tabular Editor, DAX Studio, REST API.
- Five years of exposure to IT architecture and solutioning, for data flows among system and applications.
- Proven experience as a Power BI Developer or in a similar role.
- Strong understanding of data modelling concepts and best practices.
- Proficiency in DAX (Data Analysis Expressions) and M Query language.
- Knowledge of ETL processes and data integration.
- Familiarity with business intelligence and data visualisation principles.
- MS SQL Server T-SQL (Stored procedures, functions, CTEs, error handling).
- Excellent problem-solving and troubleshooting skills.
- Strong communication and collaboration skills.
- Power BI certification