BI & SQL Developer — Power BI & Data Warehousing

Carrington Blake Recruitment; Wokingham; On-site; GBP 40,000 - 60,000; Full time

Job summary

Carrington Blake Recruitment is seeking an experienced Report Writer / Developer to support reporting and BI across Children’s Social Care. The role requires strong SQL, Power BI, data warehousing and data transformation skills to deliver accurate reports and dashboards.

You will work with stakeholders to translate requirements, develop technical solutions, validate data and maintain governance, with collaboration across DBAs and Data Engineers.

Qualifications

• Extensive experience in report development, BI or data development.
• Advanced SQL/T-SQL skills with complex queries and procedures.
• Strong hands-on Power BI dashboard and report development.
• Experience with SQL Server and data warehouses.
• Understanding of data transformation and modelling.
• Experience with ETL and integrating multi-source data.
• Data validation, QA and discrepancy investigation.
• Ability to troubleshoot reporting and performance issues.
• Strong stakeholder management and requirements gathering.
• Ability to create technical docs and governance.

Responsibilities

• Translate reporting requirements into technical specs with stakeholders.
• Write, optimise and troubleshoot SQL/T-SQL queries, procedures, and views.
• Design, develop and maintain Power BI reports and dashboards.
• Validate data and perform QA to ensure accuracy and reliability.
• Create and maintain a centralised report catalogue.
• Document report definitions, data sources, business logic and data dictionaries.
• Investigate complex reporting issues and data discrepancies.
• Transform and cleanse data from multiple systems for analysis.
• Undertake light ETL activities as needed.
• Manage reporting permissions and security roles.
• Collaborate with DBAs and Data Engineers to improve data models.
• Identify opportunities to improve reporting processes and performance.
• Mentor colleagues on reporting, Power BI and data development.

Skills

SQL/T-SQL

Power BI

Data modelling

Data transformation

ETL processes

SQL Server

Query optimisation

Stakeholder mgmt

Documentation

Tools

SSIS

SSRS

SSAS

Job description

Carrington Blake Recruitment is seeking an experienced Report Writer / Developer to support reporting and BI across Children’s Social Care. The role requires strong SQL, Power BI, data warehousing and data transformation skills to deliver accurate reports and dashboards.

You will work with stakeholders to translate requirements, develop technical solutions, validate data and maintain governance, with collaboration across DBAs and Data Engineers.