John MorrisonData ArchitectSummary:Results-oriented data engineer with over 15 years of experience deploying and configuring Data and ETL solutions on Microsoft Azure/Windows based systems. Proven expertise in designing and implementing end-to-end Enterprise Data Platforms. Skilled in working with various ETL tools, automating processes, and collaborating with cross-functional teams to optimize data operations. Committed to delivering high-quality solutions and driving continuous improvement in data engineering practices. Experience:- Work closely with clients filling roles as Data Engineering Architect, Ingestion & Consumption ETL developer, and Infrastructure resource to ensure efficient data operations.- Deploy Bronze/Silver/Gold Medallion architecture using Databricks, Synapse, Azure Data Factory (ADF), and Azure Data Lake (ADLS)- Design and architect Enterprise Data Platform, enabling seamless data integration and analytics.- Drive the development and adoption of self-service capabilities and automation, empowering stakeholders to access and analyze data independently.- Collaborate with customers and stakeholders to develop correlation visualization, reports, and dashboards, providing actionable insights.- On-board new ETL tools, applications, and processes to the Azure platform, ensuring smooth data migration and integration.- Maintain GitHub repository for solution management, ensuring accurate version control and collaboration.- Expert in writing and modifying custom MS SQL stored procedures and Spark SQL notebook scripts for ETL transformations and serving KPIs from the Gold data layer to Power BI.- Monitor ADO pipelines for failures, diagnose and resolve issues promptly, ensuring smooth pipeline execution.- Create and maintain documentation, and conduct one-on-one training sessions, enabling knowledge transfer and efficient team collaboration.- Collaborate with clients to ensure correct identification of data relationships and appropriate data ownership.