Scott Johnston Email and Phone Number
With over five years of practical experience in data-related roles, my professional journey started in Marketing, where I honed my skills over a span of more than three years. During this phase, I harnessed data-driven insights to inform and shape strategic decision-making, becoming well-versed in the art of leveraging data for business advantage. This immersive experience laid a strong foundation for my transition into the role of a dedicated Data Analyst, where I further sharpened my proficiency in Tableau, Alteryx, SQL, Power BI, and Tableau Prep.My substantial experience in both marketing and data analytics has ignited a deep passion for data analysis and equipped me with a versatile skill set. This blend of expertise, involving both the practical use of data and its preparation, uniquely situates me to effortlessly comprehend user needs, provide valuable insights, and devise innovative solutions. It enables a seamless bridge between the realms of stakeholder and data analyst, facilitating effective communication and understanding.In my role as a Finance Data Analyst at Schneider Electric, I effectively harnessed the power of SQL and Alteryx Designer to prepare and transform data, culminating in the creation of indispensable finance reporting dashboards. Notably, I achieved a significant milestone by designing a tailored Tableau reporting dashboard, meticulously tracking key performance indicators (KPIs) associated with support function costs in Australia and New Zealand. This strategic move streamlined reporting processes and resulted in substantial time savings.As a BI & Analytics Consultant at Optus, I continued my journey of excellence by crafting innovative Tableau dashboards, enabling users to extract invaluable insights. My collaborative approach with business stakeholders played a pivotal role in this endeavor. Furthermore, my expertise in implementing robust and scalable data management solutions, while rigorously adhering to best practices in data preparation and visualization, proved essential in driving analytical solutions.My passion lies in harnessing data to unveil meaningful insights and drive impactful decisions. I am eager to connect and collaborate with fellow professionals in the field of data analytics, and I invite you to reach out to explore opportunities for data-driven success.
Workplace Gender Equality Agency
View- Website:
- wgea.gov.au
- Employees:
- 29
-
Data Analytics ManagerWorkplace Gender Equality Agency Oct 2024 - PresentSydney, New South Wales, Australia -
Senior Data AnalystWorkplace Gender Equality Agency Feb 2024 - Oct 2024Sydney, New South Wales, Australia -
Financial Data Analyst ConsultantSchneider Electric Mar 2023 - Dec 2023Sydney, New South Wales, Australia• Leveraged SQL and Alteryx Designer to extract, load and transform data from multiple sources, facilitating the development of essential Finance reporting dashboards• Built Tableau reporting dashboard to track KPIs related to support function costs in Australia and New Zealand, significantly reducing the manual reporting workflow by saving 30 hours per week.• Analysed financial data to identify trends, patterns, and opportunities, resulting in decreased operational costs for employees and managers• Provided ongoing maintenance and integration of new enhancements for both new and existing dashboards -
Data Analyst ConsultantData School Down Under Aug 2021 - Nov 2023Sydney, New South Wales, AustraliaComprehensive 4-month training focused on developing industry-ready data analysis skills using tools like Tableau, SQL, Power BI and Alteryx Designer.During the training, seven client weeks were planned, during which time clients submitted their own data for analysis. At the conclusion of the client week, clients received a presentation showcasing a proof-of-concept and/or insights from their data. These client weeks produced fruitful results and satisfied customers.Following this time, I was selected as a consultant for Optus and Schneider Electric while receiving the tools and assistance I needed to advance my analytical abilities. -
Bi And Analytics ConsultantOptus Nov 2021 - Dec 2022Sydney, New South Wales, Australia• Drove analytical solutions to support the Optus Network Deployment Team, collaborating with Business and relevant stakeholders to develop innovative Tableau Dashboards that empower users to gain valuable insights• Automated end-to-end data flows and processes by utilizing Google Big Query (GCP), SQL, Alteryx, and Tableau• Developed 12 Tableau Dashboards, mainly focusing on tracking project milestones as well as CapEx expenditure KPI reporting for project managers• Implemented robust and scalable solutions to manage big data while maintaining best practice for both data preparation and visualizations• Showcased data visualizations and shared best practices with the internal Optus data community -
Marketing AssistantBusways Group Pty Ltd Nov 2017 - Feb 2021Sydney, New South Wales, Australia• Produced performance reports that tracked KPIs such as website visits, traffic patterns, and social media engagement rates in order to measure campaign success.• Composed and posted online content on company website & internal channel• Developed and implemented marketing campaigns to drive initiatives and brand awareness.• Organised promotional events to increase services visibility in the marketplace.• Undertook administrative tasks, driving functionality and helping coordinate department activities. -
Fresh Produce Team MemberColes Nov 2012 - Nov 2017Newcastle, New South Wales, Australia
Scott Johnston Skills
Frequently Asked Questions about Scott Johnston
What company does Scott Johnston work for?
Scott Johnston works for Workplace Gender Equality Agency
What is Scott Johnston's role at the current company?
Scott Johnston's current role is Data Analytics Manager | Specializing in Tableau, SQL & Alteryx | Empowering Australia with Gender Equality Data Insights.
What schools did Scott Johnston attend?
Scott Johnston attended Tafe Nsw, Tafe Nsw, Bishop Tyrrell Anglican College.
What skills is Scott Johnston known for?
Scott Johnston has skills like Microsoft Excel, Teamwork, Customer Service, Microsoft Office.
Who are Scott Johnston's colleagues?
Scott Johnston's colleagues are Deborah Macdonald, Karen Michelmore, Steven Douek, Georgia Sholl, Elyse Lane, Felicity Leyne, Anne Beath.
Not the Scott Johnston you were looking for?
-
1live.com.au
-
2bigpond.com, stjohnnsw.com.au
2 +612974XXXXX
-
Scott Johnston
Greater Sydney Area -
3gmail.com, app.com.au, app.com
3 +121583XXXXX
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial