w
will_phillips87

William P

@will_phillips87

Senior SQL, Azure Data Engineer, ADF, ETL, Data Warehousing, Power BI

Großbritannien
Englisch
Einige Informationen werden in englischer Sprache angezeigt.
Über mich
I’m a UK-based Senior BI Developer and SQL-focused Azure Data Engineer with 13 years’ experience turning messy data into fast, reliable reporting systems. I specialise in Azure Data Factory, SQL Server, and dimensional data warehousing (Kimball), with experience in performance tuning, automation using Python and PowerShell, and building Power BI reporting on clean data models. I’ve modernised legacy systems, integrated old and new platforms, and built automated pipelines from SQL, CSV, JSON, Excel, SFTP, and cloud storage. If your data is slow or unreliable, I can help.... Mehr lesen

Kompetenzen

w
will_phillips87
William P
offline • 
Durchschnittliche Antwortzeit: 1 Stunde

Meine Dienstleistungen

Daten-ETLs
I will build or fix azure data factory pipelines for reliable etl
Ab95 $ / ProjektWeitere Details
SQL- und NoSQL-Abfragen
I will write, optimise, and fix complex sql queries and stored procedures
Ab80 $ / ProjektWeitere Details

Arbeitserfahrung

Senior BI Developer | Azure Data Engineer

Suffolk Building Scoeity • Vollzeit

Dec 2019 - Present • 6 yrs 5 mos

Design, build, and maintain enterprise-grade data solutions supporting reporting and analytics across the organisation. • Develop and optimise complex SQL queries, views, and stored procedures • Design dimensional data warehouse models (Kimball), including Slowly Changing Dimensions • Build and maintain Azure Data Factory pipelines, using Python and PowerShell for data transformation, automation, and scheduled processing • Integrate data from SQL databases, flat files, JSON, REST APIs, and legacy systems • Optimise Power BI semantic models and write efficient DAX for business reporting • Improve data quality, performance, and reliability across reporting platforms • Support system migrations and modernisation of legacy reporting solutions