Job Title: Power BI Developer

Location: Avnet House, Rutherford Cl, Stevenage SG1 2EF

Trust: East and North Hertfordshire NHS Trust

Job Type/Shift Patterns: Full time, Monday – Friday, 8am-4pm or 9am-5pm, 37.5 hours a week (Hybrid, 2-3 days working on-site, rest days Working from Home)

JOB DESCRIPTION:

Summary:

The post holder will work closely on migrating data from QlikView to Microsoft Fabric, leveraging their expertise in advanced Power BI, SQL, and data transformation techniques. They will ensure accurate data integration and optimization, providing robust analytical solutions and maintaining high data quality throughout the process.

Responsibilities:

* Design and optimize advanced Power BI data models to enhance data visualization and analysis.

* Execute complex SQL query optimization and manage SQL incremental loads and NET changes for data consistency.

* Author DAX measures to provide granular dataset filtering and grouping in Power BI reports and visuals.

* Develop and run T-SQL scripts to generate correction journals and reconcile source data with reports.

* Perform ETL processes using Power Query M code in Excel and Power BI to transform and integrate data.

* Create SQL tables and scripts to reconcile source data, ensuring alignment with authored reports.

* Leverage Microsoft Fabric's data integration capabilities, including SQL Analytics endpoint and OneLake Data Warehouse, to support comprehensive data analysis and seamless migration from QlikView.

Required Experience:

Must have previous experience:

* Advanced Power BI data modelling.

* Advanced level of SQL query optimisation.

* Advanced knowledge in SQL incremental loads and NET change.

* Providing Dataset granularity for Power BI contextual filtering and grouping by authoring DAX Measures for context filtering on Matrix tables or Visuals.

* Generating correction Journals with T-SQL scripts made of thousands of rows.

* ETL in Excel and Power BI with Power Query M code.

* Developing scripts for creating SQL tables to help reconcile source data with authored reports.

* Demonstrated Microsoft Fabric Capacity for data analysis leveraged with ‘SQL Analytics endpoint’ on integrated Daaflows and OneLake Data Warehouse.

* Regrouped multilayered categories for Power BI Balance Sheet and P&L report with GRNI reconciliation ‘Drill through’s to Accounts Payable, WIP and Freight.

* ETL Production ERP source data with Power Query Merging tables to map GL accounts and departments to reflect familiar Excel reports leveraging Power BI contexts and DAX Measures.

* Programmed Date table for DAX Measures to calculate Actuals and Budget variances to prior month, year and quarter on Power BI Matrix visuals.

* Split Deferred Revenue releases “by customer, by month, and by product” generated correction Journals that reversed Nominal Ledger entries and re-posted at required granularity for uploading to Sage Intacct

* Advanced functionality in Power Query and T-SQL to re-calculate disparate data source files.

* Provided granularity for data synchs with Tableau producing trend analysis and CRM triggers.

* Experience in an information role within the NHS is highly desirable.

Technical Stack:

* Data Lakes, Power Query, Power BI, Advanced Python, Power Pivot, Data Analysis Expressions (DAX), T-SQL and advanced SQL.

As a member of NHS Professionals, you have fantastic benefits:

Putting People in Places to Care – be part of the NHSP community, by joining the bank and caring for patients with a team of people from all walks of life.

Weekly pay to give you access to your wages more quickly.

First choice of shifts/placements at the Trust of your choice over agencies.

Our team is always happy to help - access our support line any time.

Working options to suit your lifestyle – being on the bank gives you the flexibility to work the shifts you want or choose fixed term placements.

Training and development opportunities via the Trust and NHSP’s own academy.

Explore different wards, keep your skills up to date whilst gaining vital experience.

Being part of the NHSP Community means you’ll get access to member activities such as member of the month, member appreciation week, key date giveaways, webinar series and much more.

Who are NHS Professionals?

We specialise in putting people in place to care. Every year we help thousands of dedicated candidates and highly skilled NHS workers enjoy better career opportunities, access to more shifts and a healthier work-life balance, giving more choice and control to our members.

As an equal opportunities’ organisation, NHSP is committed to the equal treatment of all current and prospective Bank members and does not condone discrimination on the basis of age, disability, sex, sexual orientation, pregnancy and maternity, race or ethnicity, religion or belief, gender reassignment, or marriage and civil partnership. We believe there is a strong case for the Equality, Diversity and inclusion agenda and we strongly encourage suitably qualified applicants form a range of backgrounds to apply.

Apply Today

By joining us you can look forward to a choice of flexible Bank shifts across any of our client Trusts in England, as well as the ability to develop professionally and gain experience in several wards or areas.

Disclaimer

Please note, you will be contacted by email throughout the recruitment process, so please check your emails, including your junk/spam regularly. We regret we cannot contact everyone who is not selected for an interview, therefore if you do not hear from us within 21 days after submitting your application, please assume you have not been successful on this occasion.

NHS Professionals manage your data, please see our Privacy Notice on our website