$$$
{{ $t($store.state.user.experience_value_in_dollars) }}
Senior
{{ $t($store.state.user.experience_search_name) }}
0
jobs
Innovative, business-focused DW/BI Consultant with proven, in-depth Data Engineering and Business Intelligence skills and experience.
Richard Swinbank
,
BIRMINGHAM, United Kingdom
Experience
Other titles
Skills
I'm offering
Contract DW/BI Consultant with strong technical and communication skills.
• Microsoft SQL Server & Azure data platform
• Expert T-SQL for queries, analysis, administration and process engineering
• Configuration/metadata-driven dynamic T-SQL
• C# (including SQL CLR assemblies, SSIS script tasks/components, BimlScript), Java
• SSIS (including BIML & BimlScript), SSRS, SSAS
• DevOps toolchain components (git/svn, Azure Pipelines)
• Requirements-driven data modelling and warehouse development, Kimball methodology
• Effective communicator, able to convey complex technical issues to a range of audiences
• Articulate technical author, able to write proposals, designs, developer and user guides
• Data-driven, analytical problem solver
• Active member of Microsoft Data Platform community; speaker (SQLBits 2019, DataRelay 2018), volunteer; abreast of latest developments in Azure services
• Microsoft SQL Server & Azure data platform
• Expert T-SQL for queries, analysis, administration and process engineering
• Configuration/metadata-driven dynamic T-SQL
• C# (including SQL CLR assemblies, SSIS script tasks/components, BimlScript), Java
• SSIS (including BIML & BimlScript), SSRS, SSAS
• DevOps toolchain components (git/svn, Azure Pipelines)
• Requirements-driven data modelling and warehouse development, Kimball methodology
• Effective communicator, able to convey complex technical issues to a range of audiences
• Articulate technical author, able to write proposals, designs, developer and user guides
• Data-driven, analytical problem solver
• Active member of Microsoft Data Platform community; speaker (SQLBits 2019, DataRelay 2018), volunteer; abreast of latest developments in Azure services
Markets
United Kingdom
Links for more
Once you have created a company account and a job, you can access the profiles links.
Language
English
Fluently
Ready for
Larger project
Ongoing relation / part-time
Full time contractor
Available
My experience
2019 - 2020
job
Data Engineer
Oakbrook Finance.
Implementation of next-generation enterprise data platform in Microsoft Azure.
• Designed and built ETL process controller using Azure Durable Functions (C#), to manage execution of Azure Data Factory (ADF) pipelines and other processes
• Designed and built metadata transformation library, enabling ETL metadata to be both stored under version control as JSON, and imported to (and re-exported from) Azure SQL DB
• Built proof-of-concept Azure DevOps YAML pipelines to create disposable development environments in Azure using Terraform, SSDT deployments and metadata deserialisation
• Automated inference of normalised staging schemas from JSON source data in Azure blob storage
• Implemented extensive test suites for SQL objects (TSQL, tSQLt) and ETL process controller (C#, NUnit, Moq, FluentAssertions)
• Automated functional tests for ADF pipelines using NUnit and Azure DevOps YAML pipelines
• Designed and built ETL process controller using Azure Durable Functions (C#), to manage execution of Azure Data Factory (ADF) pipelines and other processes
• Designed and built metadata transformation library, enabling ETL metadata to be both stored under version control as JSON, and imported to (and re-exported from) Azure SQL DB
• Built proof-of-concept Azure DevOps YAML pipelines to create disposable development environments in Azure using Terraform, SSDT deployments and metadata deserialisation
• Automated inference of normalised staging schemas from JSON source data in Azure blob storage
• Implemented extensive test suites for SQL objects (TSQL, tSQLt) and ETL process controller (C#, NUnit, Moq, FluentAssertions)
• Automated functional tests for ADF pipelines using NUnit and Azure DevOps YAML pipelines
Implementation, SSDT, Processes, MOQ, Enterprise, Storage, Development, NUnit, Transformation, Sql, Azure SQL, Test, C, ETL, Microsoft azure, DevOps, JSON, Azure
2018 - 2019
job
Data Warehouse Developer
Dyson.
Stabilisation and productionisation of SQL Server 2016 data warehouse platform.
• Instituted robust, well-documented deployment pipeline and change control processes
• Replaced centralised TFS-based version control with git feature branch and one-step deploy
• Refactored SSIS & TSQL ETL components, reducing nightly processing time by 60%
• Implemented SSRS dashboard and tools for routine ETL monitoring and management
• Extended Kimball data model to keep pace with fast-evolving reporting requirements
• Navigated end-user communication to elucidate data model designs from raw data requests
• Delegated management of integration controls to end users using Master Data Services
• Integrated data from heterogeneous source systems including Teamcenter, MS Project Server, Active Directory (LDAP queries), SharePoint (CSOM API), JIRA (REST API) & Exchange (EWS API)
• Built API extract interfaces using SSIS script source components and JSON shredding
• Streamlined DW integration by calling Tableau extracts directly from ETL via REST API
• Instituted robust, well-documented deployment pipeline and change control processes
• Replaced centralised TFS-based version control with git feature branch and one-step deploy
• Refactored SSIS & TSQL ETL components, reducing nightly processing time by 60%
• Implemented SSRS dashboard and tools for routine ETL monitoring and management
• Extended Kimball data model to keep pace with fast-evolving reporting requirements
• Navigated end-user communication to elucidate data model designs from raw data requests
• Delegated management of integration controls to end users using Master Data Services
• Integrated data from heterogeneous source systems including Teamcenter, MS Project Server, Active Directory (LDAP queries), SharePoint (CSOM API), JIRA (REST API) & Exchange (EWS API)
• Built API extract interfaces using SSIS script source components and JSON shredding
• Streamlined DW integration by calling Tableau extracts directly from ETL via REST API
Tableau, EWS API, Processes, Processing, Sql server 2016, Kimball, Feature, Server, Monitoring, TFS, Developer, SSRS, Ssis, Management, Integration, Sql, REST, Data Warehouse, ETL, Deployment, SharePoint, Exchange, Active Directory, JSON, REST API, Jira, SQL Server, API, Git
2017 - 2018
freelance
DW/BI Consultant
Counter Intelligence Retail.
Reimplementation and automation of SQL Server 2016 sales reporting platform to release analyst and developer time, permit integration with corporate master data and facilitate report suite redevelopment.
• Abstracted complex legacy reporting model into simplified star schema
• Prepared model for replacement of legacy dimensions with corporately-managed master data
• Automated data integration from a variety of source system Excel and flat file outputs using SSIS, saving 5+ analyst days per month
• Populated new model from historical data (T-SQL) and new sources (SSIS), demonstrating consistency with existing report outputs and ensuring continued availability of legacy BI assets
• Abstracted complex legacy reporting model into simplified star schema
• Prepared model for replacement of legacy dimensions with corporately-managed master data
• Automated data integration from a variety of source system Excel and flat file outputs using SSIS, saving 5+ analyst days per month
• Populated new model from historical data (T-SQL) and new sources (SSIS), demonstrating consistency with existing report outputs and ensuring continued availability of legacy BI assets
Sql, Excel, .Net, SQL Server, Automation, Integration, T-SQL, Sales, Ssis, Net, Developer, Analyst, BEE, Server, Sql server 2016
2016 - 2017
freelance
Data Warehouse Consultant
North Staffordshire Combined Healthcare NHS Trust.
Integration of data from new Lorenzo patient system into existing SQL Server warehouse platform, enabling seamless reporting across source systems and retention of value in existing reporting assets.
• Built SSIS packages for flat file ETL
• Designed and built ETL metadata repository using SSIS to sync supplier metadata
• Used BimlScript to generate 850 SSIS packages to standard ETL pattern from metadata
• Automated T-SQL build of staging objects from metadata, supporting schema upgrades in-situ
• Implemented metadata-driven ETL application in C#
• Built searchable end-user view of historical system data using SSRS and legacy Oracle back end
• Developed master patient record in operational data store, automatically combining records from different sources
• Built SSIS packages for flat file ETL
• Designed and built ETL metadata repository using SSIS to sync supplier metadata
• Used BimlScript to generate 850 SSIS packages to standard ETL pattern from metadata
• Automated T-SQL build of staging objects from metadata, supporting schema upgrades in-situ
• Implemented metadata-driven ETL application in C#
• Built searchable end-user view of historical system data using SSRS and legacy Oracle back end
• Developed master patient record in operational data store, automatically combining records from different sources
Sql, SQL Server, Oracle, ETL, Data Warehouse, C, Integration, T-SQL, Ssis, SSRS, Retention, Server
2015 - 2016
job
ETL Developer
Staffordshire & Shropshire Health Informatics Service.
Incorporation of new acute hospital tenant into multi-tenant SQL Server warehouse platform.
• Acquired and refined reporting requirements from known NHS data sets and by liaising with customer stakeholders from a variety of professional backgrounds (technical, clinical, non-clinical)
• Integrated data from numerous source systems in a variety of technologies (SQL Server, PostgreSQL, SQLBase, mixed-type CSV files) using T-SQL & SSIS
• Designed integration transformations from a variety of source systems and data models
• Implemented library of CLR functions and stored procedures to perform specialised tasks in C# (e.g. INSERT/EXEC nesting, regular expression matching, inline transformation to 1NF)
• Acquired and refined reporting requirements from known NHS data sets and by liaising with customer stakeholders from a variety of professional backgrounds (technical, clinical, non-clinical)
• Integrated data from numerous source systems in a variety of technologies (SQL Server, PostgreSQL, SQLBase, mixed-type CSV files) using T-SQL & SSIS
• Designed integration transformations from a variety of source systems and data models
• Implemented library of CLR functions and stored procedures to perform specialised tasks in C# (e.g. INSERT/EXEC nesting, regular expression matching, inline transformation to 1NF)
Sql, SQL Server, PostgreSQL, ETL, C, Integration, T-SQL, Stored procedures, Ssis, Developer, Transformation, Server
2014 - 2015
job
BI Developer
Birmingham & Solihull Mental Health NHS Foundation Trust.
Implementation and extension of new SQL Server reporting data model.
Sql, SQL Server, Developer, Implementation, BEE, Server
My education
University of Birmingham
Doctorate, Computer Science
Doctorate, Computer Science
Richard's reviews
Richard has not received any reviews on Worksome.
Contact Richard Swinbank
Worksome removes the expensive intermediaries and gives you direct contact with relevant talent.
Create a login and get the opportunity to write to Richard directly in Worksome.
38000+ qualified freelancers
are ready to help you
Tell us what you need help with
and get specific bids from skilled talent in Denmark