Brisbane City, Queensland, Australia
Greeting! Patrick is a Data Analytics Engineer with 3+ years of experience in designing and maintaining data warehouses, managing and expanding BI analytics, and fostering data-driven decision-making. Proficient in SQL, DBT, Python, Snowflake, and cloud services (AWS, Azure, & GCP). Adept at collaborating with cross-functional teams to enhance data literacy and maintain data governance. Proven ability to thrive in startup environments, with a strong focus on innovation, efficiency, and effective communication.
Instructing in tutorials/practicals for CAB432 Could Computing
- Designed and implemented a data pipeline to modernize annual and quarterly Excel reports by developing a Snowflake-based data model for metrics and visualizing dashboards using Tableau. - Designed and built an automated data pipeline to replace manual reporting processes by creating data models in Snowflake and integrating them with Alteryx, while enabling data export in Excel format using a Snowflake Streamlit app.
The University of Sunshine Coast wants to build a Customer Data Platform to centralize its data from its Website, Warehouse, and Ads/tech platform (GA4, Fb Pixel, Tiktok, Linkedin, Twitter) Patrick skilfully orchestrated the deployment of a comprehensive events streaming pipeline, seamlessly transmitting data from Azure Synapse to Segment. This feat was accomplished through the adept utilization of Azure Data Factory in tandem with Azure Functions App. Furthermore, Patrick played a pivotal role in architecting the data warehouse tables, ensuring their alignment with the Customer Data Platform (CDP) for optimized marketing analysis. His involvement in the solution design process for the entire project underscored his holistic understanding and contribution to its overall success. Patrick's expertise and dedication significantly enriched the project's data-handling capabilities and strategic direction.