About the Role
As a Business Intelligence Developer at Techedia, you will play a pivotal role in turning data into strategic insights for both internal stakeholders and external clients. This position combines technical expertise with client-focused service, allowing you to develop data solutions that support critical business functions and meet client-specific needs. You will manage the full lifecycle of BI solutions, from requirements gathering and data integration to report creation and client support.
Key Responsibilities
- Client Engagement and Requirement Gathering: Collaborate closely with clients to understand their unique business needs and data challenges. Facilitate requirements-gathering sessions to ensure BI solutions align with client objectives.
- Report and Dashboard Development: Design and deliver client-specific reports and dashboards using Power BI, tailoring visualisations and metrics to meet each client’s operational needs.
- Client Service and Support: Act as a trusted advisor for clients, ensuring prompt and effective communication throughout project phases. Manage change requests with a focus on continuous improvement.
- Data Integration and Source Management: Integrate multiple data sources, including SQL databases, Excel, and APIs, to create a consolidated data view for client reporting. Ensure data accuracy, reliability, and security in all client-facing solutions.
- Performance Optimisation: Regularly monitor report performance and make necessary improvements using DAX optimisation, query folding, and indexing strategies to deliver a seamless client experience.
- Collaboration and Mentorship: Work collaboratively with BI team members, sharing best practices and mentoring apprentices. Guide team members in building client-centric solutions and upholding Techedia’s standards of client service.
- Knowledge Base Maintenance: Build and maintain a knowledge base on Azure DevOps Wiki, with a special focus on client project documentation and procedural guides to support team efficiency and knowledge continuity.
Tools & Technologies
Desirable
- BI and Reporting Tools: Power BI
- Data Processing and Management: SQL Server, Azure SQL Database, MySQL
- Data Analysis and Optimisation: SQL, DAX (Data Analysis Expressions), M Query
- Management and Documentation: Azure DevOps for documentation and project tracking
Preferable
- Data Integration and API Usage: Knowledge of RESTful APIs for data integration, JSON for data formatting, and experience with API tools like Postman.
Skills & Qualifications
- Proven experience as a BI Developer, with strong expertise in Power BI, SQL, and data integration tools.
- Excellent client service skills, with a proactive approach to understanding client requirements, providing tailored solutions, and delivering effective training and documentation.
- Proficiency in DAX and M Query for customisation, performance tuning, and optimising both DirectQuery and Import mode solutions.
- Experience in developing BI standards and documentation procedures to maintain team-wide consistency and quality.
- Ability to work with diverse data sources, ensuring data accuracy and relevancy in all client-facing reports.
- Familiarity with Python or R for advanced data analysis and automation is an advantage.
Salary, Hours, Benefits & Annual Leave
- Salary – dependant on experience
- Monday to Friday, 9AM to 5:30pm
- 21 days’ holiday + Bank Holidays
- Gain additional holidays & sick pay after 2nd year of service
- Regular staff events
- Discount at Mikhail Group attractions/restaurants
- Paid lunch provided once per month
- Annual salary reviews