BI Developer - Bristol

at  DAC Beachcroft

Job Introduction
DACBeachcroft is seeking an experienced BI Developer to join our IT Business Solutions team on a full-time, permanent, hybrid basis in our Bristol office.
This role would ideally suit someone with proven Power BI experience, looking for a fresh challenge in their career. The ideal candidate will also have a strong background in SQL, SSRS, and SSIS, with the additional capability of leveraging Azure data platforms and MS Purview. Experience in migrating from SSRS to Power BI is highly desirable.
Reporting into the BI Manager, the BI Developer plays a crucial role in developing and maintaining Business Intelligence (BI) solutions to support the data-driven needs of DACB. This includes the creation of Power BI dashboards, paginated reports, and collaboration with cross-functional teams to understand their reporting requirements. The ideal candidate will have a strong background in SQL, SSRS, and SSIS, with the additional capability of leveraging Azure data platforms and MS Purview. Experience in migrating from SSRS to Power BI is highly desirable.
We are a Disability Confident employer and guarantee to interview anyone with a disability, long term health condition or neurodiversity whose application meets the essential criteria for the role as set out in this advert. If this applies to you contact disabilityconfident@dacbeachcroft.com in confidence, quoting the reference number for this vacancy in the subject box of your email, and a member of the team will be in touch.
We are happy to talk flexible working and have in place a Flex-forward working scheme. We would encourage you to talk to us about our approach to flexible working during the hiring process if you would like to explore this further.

Main Responsibilities

• Power BI Development: Design, develop, and maintain interactive Power BI dashboards and reports to meet business needs.
• Paginated Reporting: Create and manage paginated reports using SSRS and Power BI Report Builder.
• Data Analysis: Work closely with stakeholders to understand data requirements, providing analytical insights and developing custom reports.
• T-SQL Development: Write efficient T-SQL queries for data extraction, transformation, and reporting purposes.
• SSRS and SSIS: Develop and maintain SSRS reports, and create data integration workflows using SSIS.
• Data Migration: Participate in the migration of reports and data sources from SSRS to Power BI.
• Collaboration: Liaise with legal colleagues, IT, and other departments to ensure the delivery of high-quality BI solutions.
• Data Governance: Assist in implementing data governance practices using tools like MS Purview.
• Documentation: Maintain comprehensive documentation for BI solutions, including data sources, data models, and report structures.
• Is also willing to take ownership on any other tasks and responsibilities as required

The Ideal Candidate

KEY EXPERIENCE:

• BI Development: Proven experience in developing BI solutions, especially with Power BI.
• SQL Proficiency: Strong T-SQL skills for creating and managing complex queries.
• SSRS and SSIS Experience: Experience with SQL Server Reporting Services and SQL Server Integration Services.
• Data Analysis: Demonstrated ability to analyse data and generate actionable insights.
• Data Migration: Experience in migrating reports and data sources from SSRS to Power BI is a plus.
• Azure Platforms: Familiarity with Azure data platforms and MS Purview is desirable.
• Industry Knowledge: Understanding of legal terminology and processes is beneficial but not required.

Main Responsibilities

• Power BI Development: Design, develop, and maintain interactive Power BI dashboards and reports to meet business needs.
• Paginated Reporting: Create and manage paginated reports using SSRS and Power BI Report Builder.
• Data Analysis: Work closely with stakeholders to understand data requirements, providing analytical insights and developing custom reports.
• T-SQL Development: Write efficient T-SQL queries for data extraction, transformation, and reporting purposes.
• SSRS and SSIS: Develop and maintain SSRS reports, and create data integration workflows using SSIS.
• Data Migration: Participate in the migration of reports and data sources from SSRS to Power BI.
• Collaboration: Liaise with legal colleagues, IT, and other departments to ensure the delivery of high-quality BI solutions.
• Data Governance: Assist in implementing data governance practices using tools like MS Purview.
• Documentation: Maintain comprehensive documentation for BI solutions, including data sources, data models, and report structures.
• Is also willing to take ownership on any other tasks and responsibilities as require