Our client, an S&P/ASX 200 organisation, is dedicated to fostering inclusive communities across 109 locations, supported by a network of over 4,000 investors and 1,450 employees. With a focus on integrity, respect, and continuous improvement, they strive to create meaningful connections and enrich lives.
Challenges
Our client faced major data challenges affecting efficiency and decisions.
Lack of Data Governance: No formal framework for managing data quality and governance.
Security Vulnerabilities: Significant risks due to insufficient authentication measures and poor access controls, including privileged accounts with weak authentication processes.
Inefficiencies in Queries and Processing: Ineffective use of Snowflake's capabilities leading to suboptimal performance.
Limited Documentation: A lack of comprehensive data documentation prevented effective use and understanding of the platform.
No Proactive Maintenance: Absence of ongoing oversight and optimisation of the Snowflake environment.
Internal Skill Gaps:
Reliance on external partners due to insufficient in-house technical expertise.
Solutions
Intelligen delivered a detailed Snowflake Health Check, collaborating closely with their data leadership team to evaluate, identify and remediate their Snowflake ecosystem. Our approach focused on:
- Designing a roadmap of initiatives to address core challenges and uplift the organisation’s data capabilities.
- Establishing a formal framework to ensure data quality, management, and governance across the enterprise.
- Strengthening their security measures by addressing weak authentication processes and enforcing best practices, including multi-factor authentication.
- Streamlining queries and processing to eliminate inefficiencies and optimise resource usage.
- Developing a formal architectural approach to reduce rework, improve decision-making, and enforce governance standards.
- Addressing internal skill gaps by creating a strategy to reduce reliance on external partners and empower in-house teams.
Outcome
Our Snowflake Health Check delivered impactful results, transforming the client’s Snowflake environment into a more secure, efficient, and governed data platform. We provided immediate cost savings through the identification and elimination of unnecessary resource consumption, addressed critical risks related to privileged and user access, and established a scalable secure environment maximising our clients Snowflake investment.
