Role Purpose
We are seeking a highly skilled and experienced
Senior Power BI Developer
to join our team. The ideal candidate will possess deep
expertise in Power Query, DAX, and data modelling
, and will be responsible for
designing, developing, and implementing Power BI solutions
. As a Senior Power BI Developer, you will
collaborate
with
cross-functional teams, including business analysts, data engineers and stakeholders to create visually appealing and insightful reports and dashboards.
ROLE And RESPONSIBILITIES
Power BI Solution Development
: Develop and design end-to-end Power BI solutions, including data acquisition, transformation, data modelling, and report/dashboard creation, to meet business requirements and deliver actionable insights.
Data Modelling and Transformation
: Create complex data models using Power Query, ensuring accurate data integration from various sources. Implement data transformation and cleansing processes to optimize data quality and improve performance.
DAX Calculation Development
: Utilize DAX (Data Analysis Expressions) to create advanced calculations, measures, and calculated columns for Power BI reports and dashboards, enabling sophisticated data analysis and visualization.
Report and Dashboard Development
: Design and build visually compelling and interactive reports and dashboards in Power BI, using best practices for data visualization, layout, and user experience. Incorporate custom visuals and drill-down functionality to enhance data exploration.
Data Integration
: Collaborate with data engineers to integrate and prepare data from multiple sources, ensuring consistency, accuracy, and reliability. Develop ETL processes using Power Query to extract, transform, and load data into Power BI.
Performance Optimization
: Identify and address performance bottlenecks in Power BI reports and dashboards. Optimize data models, DAX calculations, and queries to improve responsiveness and user experience.
Documentation and Knowledge Sharing
: Create comprehensive documentation, including data dictionaries, technical specifications, and user guides, to facilitate the understanding and maintenance of Power BI solutions. Share expertise and provide guidance to junior developers.
Quality Assurance
: Conduct thorough testing and validation of Power BI solutions to ensure accuracy, functionality, and adherence to business requirements. Troubleshoot and resolve issues and provide support during deployment and post-production phases.
Stay Up to Date with Industry Trends
: Continuously expand knowledge of Power BI capabilities, features, and updates. Stay informed about emerging technologies and trends in data visualization and analytics.
Essential Skills And Experience
- Bachelor’s or master’s degree in computer science, Information Systems, or a related field.
- Minimum of 5 years of professional experience as a Power BI Developer or similar role.
- Extensive expertise in Power Query, DAX, and all aspects of data modelling in Power BI.
- Strong understanding of Data integration, ETL processes, and Data Warehousing concepts.
- Proficiency in SQL and experience with relational databases (e.g., SQL Server, Oracle).
- Demonstrated ability to create visually appealing and interactive reports and dashboards.
- Solid understanding of data visualization best practices and user experience principles.
- Excellent critical thinking skills and the ability to analyze complex data requirements.
- Effective communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams.
- Experience with Azure, SSIS will be beneficial.
- Familiarity with scripting and programming.
- Experience with Power Automate and Power Apps is a plus.
- Power BI certification(s) is highly desirable.
Additional Preferred Skills
- API Integration: Experience working with APIs to integrate data from external systems, such as educational platforms, student information systems, or learning management systems, into Power BI solutions. Ability to retrieve and transform data using RESTful APIs or other integration methods.
- Educational Sector Experience: Familiarity with the educational sector, including understanding of educational data sets, reporting requirements, and data privacy regulations specific to the industry. Experience developing Power BI solutions for educational institutions or organizations is a plus.
Key Result Areas
- Ensure reports have a high level of data accuracy.
- Engage with report stakeholders to proactively seek continuous improvement.
- Maintain data security and integrity to the highest level.
