Ralph McNiven
Data Solutions Architect @Gallagher
Signup · Get unlimited contacts
WORK HISTORY
Data Solutions Architect @Gallagher
Led global data architecture initiatives as a Lead Data Architect, defining and delivering scalable, enterprise-wide data strategies aligned with business and regulatory objectives- Designed and implemented enterprise data personas, along with supporting tooling and frameworks, to standardise data usage and ownership across the organisation. Established a comprehensive metadata strategy to enable robust data governance, privacy, and regulatory compliance. Leveraged metadata-driven approaches to implement Attribute-Based Access Control (ABAC), enhancing security, data classification, and access transparency- Incorporated an implementation of Snowflake, DBT Cloud, Apache Airflow via Astronomer and Dataiku to realise this vision alongside tools such as Fivetran and Collibra to realise this vision- Acted as a strategic mentor and technical leader, coaching and developing Data Architects and data professionals to align with the organisation’s data architecture vision, promote best practices, and drive consistency across global teams.
EDUCATION
Nottingham Trent University
Bachelor of Arts (BA), Business Economics
SKILLS
ABOUT RALPH MCNIVEN
Practical experience of IT and Data Science:• Visual Basic 2005/2008.NET & SQL Server using Visual Studio (Implementation and Administration), SSMS & SSIS (6 years, 2 years with SSRS)• Netezza and Snowflake (5 years)• Qlikview, Tableau and Power BI (2 years each)• Python (numpy,scipy,matplotlib, scikit learn, pandas)(7 years), R (1.5 years), RapidMiner (2 years), Web Scraping (Python)(1 year), API Interrogation JSON and XML handling (Python, Talend & VB.NET)(3 years), Arduino and Raspberry Pi Sensor based projects (C++ & Python)(3 years)• Talend Development and Architecture (4 years)• Azure Fundamentals, Azure ML Studio, Azure DevOps and Azure WebApps (3 years)• GitHub (2 years)• Basic Unix Operations (3 years)• Advanced Excel and Access skills coupled with VBA (15 years, 11 years with VBA)• Outlook VBA (2 years)• Oracle Administration with SQL and PL/SQL using Quest software (TOAD and SQL Navigator) & SQL*Plus and querying reports via Discoverer, SAMBA and Hyperion (2 years)• Querying SQL Server via Business Objects and Cognos (4 years)• Predictive Analytics full Project lifecycle: idea, model selection (supervised or unsupervised learning method, multi model cross validation), feature and parameter selection, model deployment on technology stack (physical or cloud based)(1.5 years)• A strong interest and practical experience of economic and financial analysis.(10 years)• A strong interest and practical experience of project development/management of efficiency increasing system changes and upgrades, either run in parallel with the existing infrastructure or to replace current applications.(8 years) PRINCE2 (2 years)
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.