Learn Data Skills
Beta
Peter de Wit

Peter de Wit

Data Management Consultant

Self Employed | Wellington

Technologies

My Portfolio Highlights

My New Course

Introduction to Python

My New Course

Introduction to Python

Quantitative detective, solving mysteries and uncovering truths in data.

My Work

Take a look at my latest work.

course

Understanding Data Engineering

course

Introduction to ChatGPT

course

Introduction to Python

course

Understanding Data Engineering

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to Python
Introduction to SQL
Introduction to ChatGPT
Intermediate SQL

My Work Experience

Where I've interned and worked during my career.

Career Break | Apr 2024 - Present

Professional Development

N/A

Wellington City Council | Jan 2023 - Jan 2024

Data Architect | Data Lead

Guiding WCC in Unleashing the Full Potential of their Data Platform I embarked on a transformative journey with WCC, partnering with them to drive the further rollout and implementation of their cutting-edge data platform powered by Snowflake. Focusing on Data Architecture, DevOps/DataOps, People leadership and Data Governance & Management, I supported WCC in enabling the full exploitation of their data's potential. As team lead Data I was the defacto Data Platform owner. Leveraging a profound understanding of Data Architecture [Data Lake], I closely collaborated with WCC to design and optimise their data infrastructure. This ensured scalability, efficiency, and seamless integration within the Snowflake ecosystem. The implementation of industry-leading DevOps and DataOps practices streamlined workflows, accelerated development cycles, and maximized the agility of their data platform. Acknowledging the critical importance of Data Governance, I established robust frameworks and processes to effectively govern and manage WCC's data assets. This encompassed defining data standards, implementing data quality controls, and ensuring compliance with regulatory requirements. Instilling a culture of data governance empowered WCC to leverage its data strategically, facilitating informed decision-making across the organization. Through collaborative partnerships and a hands-on approach, I closely engaged with WCC's stakeholders, equipping them with the knowledge and skills needed to extract actionable insights from their data platform. Providing training, guidance, and ongoing support ensured the successful adoption and utilisation of the data platform across the organisation. Together, we revolutionised WCC's data landscape, unlocking new avenues for innovation and growth. With meticulous attention to detail, strategic thinking, and a dedication to data excellence, we empowered WCC to make data-driven decisions that foster positive impact and deliver remarkable outcomes.
Show More

Te Whatu Ora Health New Zealand | Jun 2022 - Dec 2022

Team Lead - National Immunisation Programme Strategic & Adhoc Reporting

In my leadership role at Te Whatu Ora - Health New Zealand agency, I led the strategic and ad-hoc reporting of the National Immunisation Programme, shifting from Excel reporting to PowerBI. Managing a team of 12 skilled Business and Data Analysts, we enhanced Te Whatu Ora's reporting capabilities in the critical immunisation and vaccination space, covering COVID-19, MMR, Flu, HPV, Polio, and more. To ensure precision, timeliness, and data accessibility, I introduced a state- of-the-art DataOps-based Operating Model. By establishing robust Standard Operating Procedures (SIPOC), we raised data quality standards, ensuring the reliability and integrity of our reporting. Recognising the importance of stakeholder trust in data, I developed a comprehensive Data Governance & Data Management implementation plan, fostering a culture of transparency and accountability to instill confidence in our data. To maintain precise control over deliverables, we expanded the use of Jira and implemented Kanban, applying DevOps principles such as Epics, Features, and Stories. This allowed us to seamlessly track progress, meet deadlines, and consistently deliver outstanding result.

IHC Group | Sep 2021 - Jun 2022

Data Lead | Architect

Led a team of 5 Data Engineers, transforming them into a DataOps team through the introduction and implementation of a DevOps & DataOps operating model. Established Standard Operating Procedures (SIPOC) and ITIL change, release, incident, and problem management processes tailored for Data Engineering efficiency. To maintain control over deliverables, introduced Azure DevOps (Epics, Features, and Stories) for precise work tracking and optimized time management. Emphasized a focus on maximum time spent on stories, ensuring a streamlined and capped work in progress (WIP). Delivered a data strategy roadmap facilitating the rollout of Data Governance and Management. Implemented Snowflake as IHC's Data Lake with Airflow, Python, and PowerBI layered on top. Initiated the setup 24 months ago, refining the data lake architecture for improved data validation, accuracy, historical data, and reduced storage using Snowflake's zero copy clone functionality. Developed a phase 2 refinement architecture, approved by the architecture team. In response to a CIO mandate, the role of Data Lead was bifurcated into Data Manager (people) and Principal Data Engineer (Technology). This strategic move ensured equal coverage of people, delivery, and architecture. Successful recruitment secured resources for both roles. My next step involved a comprehensive handover to the Data Management team.

Statistics New Zealand | Oct 2016 - May 2021

Senior Manager Data & Analytics - Digital Business Services

As a passionate people leader, I led a team of 22 Analytical DevOps Engineers, driving the delivery of scalable, high-performance solutions to meet the growing data and information needs at StatsNZ. Under my leadership, we fortified the organisation's Data Eco System, ensuring its resilience and agility to support critical national data assets. As the technical product manager, I oversaw the Integrated Data Infrastructure, Datahub [Hadoop], SAS 9.4 Grid, SAS Viya, and RStudio, providing strategic oversight and ensuring the effective integration of these platforms. A core aspect of my role involved managing a comprehensive suite of analytical tools while fostering strong relationships with senior stakeholders and aligning our data initiatives with business objectives. I conducted in-depth analytics and BI health checks, ensuring the platforms’ optimal performance, reliability, and security. Additionally, I led the strategic migration from Jira to Azure DevOps, streamlining our toolsets and significantly improving operational efficiency across the organisation. A standout accomplishment was launching the Statistics Analytical Capability Roadmap, enhancing analytical capabilities. This initiative improved Senior Stakeholder Management and fostered meaningful engagement with senior staff, General Managers, and Executive Managers. I adeptly managed external relationships with technology partners like CCL/Revera, Fujitsu, SAS Institute, and Rstudio, leveraging their expertise in Government Cloud, Azure, SaaS, IaaS, and more. I led key projects, including SAS Grid, Data Migration, the Datahub (StatsNZ Data Lake on Cloudera Hadoop), and the Analytics, Datalab, and IDI (Integrated Data Infrastructure) development, acting as the technical owner for the IDI platform. Guiding my team to achieve remarkable milestones, we empowered StatsNZ with advanced data capabilities, laying the foundation for data-driven decision- making across the organisation.

National Emergency Management Agency (NZ) | Mar 2020 - May 2020

Logistics Officer (seconded)

seconded into the National Crisis Management Centre (NCMC) as part of the National Emergency Management Agency (NEMA). Specifically, I served within the Logistics function, ensuring the seamless operation of the NCMC and handling critical tasks such as procurement and shipping of personal protective equipment (PPE). Additionally, I provided support to other functions within the NCMC. Throughout the COVID-19 national lockdown, which included Alert Levels 4, 3, and 2, I played a crucial role in coordinating logistical operations to meet the demands of the crisis. This involved managing the procurement process, ensuring the timely delivery of essential supplies, and maintaining the smooth functioning of the NCMC. By actively participating in the national response efforts, I contributed to the overall success of managing the COVID-19 situation and ensuring the safety and well-being of New Zealanders. It was an opportunity to apply my skills and expertise in logistics and crisis management in a high-pressure environment, making a meaningful impact during a challenging time.

Ministry of Health New Zealand | Apr 2016 - Sep 2016

Data Architect - EOHR Programme

As a Data Architect, I played a key role in various projects, collaborating closely with BAs & Key Stakeholders to address comprehensive requirements for the Oral Health System. My focus was on national consistency, integration, accessibility, and robust data security. In the Electronic Oral Health Record Project, I: - Formulated the Oral Health Data Management Strategy for effective data handling. - Identified technical data and non-functional requirements for EOHR's processes. - Mapped master data sources from systems like ICD9/10, HL7 & SNOMED CT. - Designed the future state Datamodel for efficiency. - Documented requirements for operational management and quality assurance. I also contributed to the Cancer Services Personal Health Service Improvement initiative by: - Analysing patient data flow within the system. - Participating in blueprint discussions for data marts. - Providing support for analytical activities within the CHIS project. My proficiencies in Data Architecture, Migration, and Quality ensure the robustness, reliability, and alignment of data infrastructure with organisational goals.

Stellar Consulting | Apr 2014 - Mar 2016

Lead Consultant

As a Lead Business Intelligence Consultant based in Wellington, NZ, I have been actively involved in various business development projects and advisory/ auditing initiatives for information management solutions. In the area of business development, I have contributed to projects such as BID team participation, ensuring effective collaboration and successful outcomes. I have also provided advisory and auditing services for information management solutions, including conducting BI and Data Warehouse health checks, information management environment assessments, and developing BI strategies and roadmaps. Additionally, I have been involved in data governance and management, focusing on improving data quality and driving continuous improvement. Internally, I have served as a performance leader, taking responsibility for coaching and mentoring junior colleagues in their career development. I have provided guidance, support, and opportunities for growth to help them excel in their roles. Furthermore, I have managed the operational and organizational aspects of the Wellington office, ensuring smooth day-to-day operations and promoting effective communication and collaboration within the team. For client engagements, I have worked on a range of projects that span data engineering, data architecture, data migration, dimensional modeling, and business intelligence tools. I have conducted requirements analysis, performance tuning, and provided consulting services to optimize data solutions. With expertise in SAS and Microsoft SQL Server, I have delivered high-quality outcomes that meet client needs and drive business success. Skills: Data Engineering, Data Architecture, Data Migration, Data Quality, Dimensional Modeling, Business Intelligence Tools, Requirements Analysis, Performance Tuning, Consulting, SAS, Microsoft SQL Server, Management.

ACC | Oct 2008 - Apr 2014

Manager, Information & Data Management

In my role as a leader and Data platform owner, I successfully managed a high-performing Information & Data Management team, overseeing their strategic efforts to elevate data quality and efficiency within the organisation. With technical expertise, I managed the Data Quality Platform & Infrastructure, leveraging SAS DataFlux and QAS to ensure the integrity and reliability of our data ecosystem. Additionally, I implemented the Datahub, a central hub for all data flowing in and out of ACC, streamlining data operations and enhancing accessibility. One of my notable achievements was co-authoring the ACC BI Strategy and Roadmap, a visionary blueprint that propelled a $16 million Programme over four years. This initiative resulted in the successful delivery of a new Data Warehouse, known as In Fact, improving data management and enabling advanced analytics capabilities. Moreover, I played a pivotal role in enhancing vendor relationships, particularly with SAS Institute, and fostering stronger collaboration with business users, ensuring alignment between technology and organisational needs. Recognising the importance of industry best practices, I championed the implementation of the Data Management Association (DAMA) Body of Knowledge (DMBOK) as the recognised standard for Data Management Best Practices within ACC. This commitment to excellence established a foundation for robust data governance and propelled the organisation towards optimal data utilisation. Furthermore, as a co-initiator of the Intelligent Business Programme, I unlocked new possibilities in data utilisation that were previously untapped. This program not only showcased the transformative power of data but also safeguarded previous investments, driving significant ROI and reducing operational costs. In fact, a forecasted total ROI of $16 million over five years was achieved, with a remarkable cost reduction of $6.4 million in 2012 alone.

Altis Consulting | Oct 2006 - Sep 2008

Senior Data Warehousing & Business Intelligence Consultant

As a Senior Data Warehouse/Business Intelligence Consultant in Wellington, NZ, I drive success for clients and our team. I contribute to RFPs and SoWs, ensuring winning proposals aligned with client needs. I conduct DW Health Checks and Info Management assessments, optimising data infrastructure and practices. Crafting BI Strategies and Roadmaps, I define client visions, goals, and implementation plans. I lead BI/DW Software Performance Improvement workshops, fine-tuning systems for optimal data processing and reporting. I coach and mentor junior colleagues as Performance Leader, fostering their growth and overseeing Wellington office operations. Client projects include designing/implementing Data Warehouses and BI solutions, conducting data migrations/integrations, and system upgrades. Each project is customized to deliver high-quality outcomes that drive value and enable data-driven decision-making.

Ministry of Justice - New Zealand | Mar 2006 - Oct 2006

Senior Business Intelligence Consultant

Department of Collections Seasoned Data Warehouse and Business Intelligence Consultant. Responsible for: - Data Warehouse Design and Architecture - Data pipelines (ETL) Design and Build - Technical Business Analysis - Data Management (Integration, Migration & Quality) - BI Reporting Tools: - SAS - Oracle Discoverer - Wherescape Red

LogicaCMG | Oct 2002 - Feb 2006

Senior Business Intelligence Consultant

During my employment with LogiceCMG, I have performed the following roles - Data Warehouse & Business Intelligence Architect - Business Intelligence Consultant - Technical ETL (data pipelines) designer - Senior Data Engineer (ETL Developer) - Technical Data Warehouse Modeller (Inmon & Kimball) - Mentor/Coach For client engagements, see projects

Inergy | Feb 2002 - Oct 2002

Senior Business Intelligence Consultant

Inergy delivers Data Warehouse solutions based upon Informatica as Data Integration Tool and Business Objects as reporting tool. All projects are carried out in house to meet their high quality, standards and deadlines.

LogicaCMG | Feb 2000 - Apr 2001

Senior Business Intelligence Consultant

Technical ETL designer Technical Data Modeller Mentor/Coach Data Warehouse Architect Senior ETL Developer

SAS Institute | May 1996 - Feb 2000

Certified SAS Consultant

- Certified SAS Software Consultant - SAS Analyst Developer - Pre Sales support SAS Institute is one of the few software suppliers who delivers full end-to-end Data Warehouse and Business Intelligence solutions before the millennium.

BDO Nederland | Sep 1995 - May 1996

Internship IT (EDP) Auditing

A 9 month assigment as part of the HES Business Information Technology education to ensure graduation as BSc in Business Information Technology. Worked predomantly with IBM AS400 Vendors in the field for ISO 9001 certification as part of IBM NL Quality Assurance Programme, BDO NL was involved as advisor and certifier. The traineeship was completed with a thesis on Total Quality Management "How to keep the ISO 9001 certificate after certification”.

My Education

Take a look at my formal education

Post Graduate Diploma, Business Administration IIHES Amsterdam | 1998
BSc, Business Information TechnologyHES Amsterdam | 1996
Diploma Intermediate Professional Education (NZQA Lv 6), Business Information TechnologyMr. Johan Enschedeschool MEAO | 1991
"de Eikenhof" - MAVO | 1986
n/a, Primary SchoolBornwaterschool | 1982

About Me

Peter de Wit

Dynamic data leader with 25+ years of experience transforming data into strategic assets. Known for empowering high-performing teams in Data Governance and Operational Excellence. Skilled in stakeholder engagement, delivering scalable data solutions.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free