Report Developer

Junior/Mid-Level Position

1. Report and Dashboard Development: Independently design and create interactive and visually compelling reports and dashboards using Power BI Desktop. Implement advanced features like bookmarks, drill-through actions, custom themes, and custom visuals.
2. Data Governance and Security: Implement data governance practices, including data access controls, role-level security, and data lineage documentation. Ensure compliance with data protection regulations.
3. Collaboration and Solution Design: Collaborate closely with technical business analysts, senior report developers and the delivery manager to refine solutions for reports and dashboards.
4. Data Extraction and Preparation: Assist in extracting data from various sources, such as databases, spreadsheets, or APIs. Help clean and transform data using Power Query to ensure it's ready for analysis.
5. Data Modeling: Support the development of data models by creating or maintaining simple data relationships and hierarchies.
6. Performance Optimization: Optimize report and dashboard performance by improving data queries, data model efficiency, and report rendering speed. Identify and address bottlenecks and resource constraints.
7. Documentation: Maintain documentation for reports, data sources, and data transformation processes.

Senior Position (responsibilities in addition to the above)
8. Collaboration, Requirements and Solution Design: Attend refinement sessions with Portfolio Manager, Technical Business Analysts and key stakeholders to analyse and distil requirements into recommendations for solution design and build.
9. Data Modeling and Integration: Develop and maintain data models, including establishing relationships, hierarchies, and calculated columns. Manage data integration tasks, including data source connections and data transformation processes.
10. Advanced Data Analysis: Perform data analysis tasks using DAX (Data Analysis Expressions) functions to create calculated measures and solve intricate business problems. Develop advanced DAX calculations for financial, statistical, or performance analysis.
11. Data Transformation and ETL: Handle more complex data transformation and ETL (Extract, Transform, Load) processes, including handling data from multiple sources and dealing with complex data structures.
12. Team Leadership and Mentoring: Provide leadership to Power BI development teams, guiding junior/mid-level professionals in best practices, design principles, and troubleshooting. Foster a culture of continuous learning and development within the team

• Expertise in using Microsoft Power BI, including Power BI Desktop, Power Query, Power Pivot, and Power BI Service (cloud-based platform).
• Strong knowledge of DAX (Data Analysis Expressions) for creating complex calculations, measures, and calculated columns in Power BI.
• Proficiency in SQL for data querying and manipulation, especially when dealing with relational databases.
• Experience with data integration, ETL (Extract, Transform, Load) processes, and data cleansing using Power Query.
• Familiarity withdata visualisation best practices and the ability to create visually appealing and insightful reports and dashboards.
• Knowledge of advanced Power BI features such as custom visuals, themes, bookmarks, drill-through actions, and custom report distribution.
• Understanding of data warehousing concepts, data modeling, and data architecture.
• Ability to work with various data sources, including databases (SQL, Azure, etc.), Excel, SharePoint, APIs, and web services.
• Experience with data source connectionand data refresh schedules.
• Knowledge of data security best practices and the ability to implement role-level security, row-level security, and data encryption in Power BI.
• Awareness of data privacy and compliance regulations relevant to the organization
• Storytelling with reporting

Experience and Skills

• Experience of working with remote teams
• Strong communicator
• Practical, direct experience of using Azure DevOps ideally within an Agile framework.

Eligibility Requirements
- Education: Bachelor's degree in computer science, Information Technology, Business Intelligence, Data Science, or a related field

• Master's degree is preferred

• MS Power BI certification preferred but not required

• Minimum of 5 years experience in similar role for Senior position

• Minimum of 3 years' experience in similar role for Mid-level position