Catapult BI, a Dialog Group company

Assist client organisations in maximising the business value of their data, particularly focusing on:
- business intelligence (BI) and management reporting
- data warehousing
- data modelling (conceptual, logical, and physical; relational & dimensional)
- reference and master data management
- metadata standards and management
- data governance and data quality

Senior Consultant

QSuper Group

Key responsibilities:
	◦ Developed conceptual data models and logical database designs (dimensional) to support the design and implementation of data warehousing and BI solutions for projects such as DaPM and systems such as the Financial Crime System (FCS)
	◦ Analysed, reviewed, and provided feedback on existing logical models, using them to maintain and develop logical database design documentation and SQL Server technical specifications via shared Confluence pages
	◦ Provided design input into various design group meetings including Design Loop and BI Design Authority
	◦ Provided feedback on data model naming standards

Data Modeller

QUT (Queensland University of Technology)

Key responsibilities:
	◦ Contributed to data governance deliverables, including a business glossary, data dictionary, report catalogue, and assisted the architecture and integration teams to develop a Common Data Model based on the CAUDIT reference model
	◦ Developed data dictionary & BusinessObjects usage reports to identify data & users affected by Transforming the Collection of Student Information (TCSI) & QTAC change projects, and specified solutions to maintain downstream data and reporting
	◦ Investigated & documented the Data Warehouse system, making it easier to understand, maintain, and enhance

Senior Data Architect

Clean Energy Finance Corporation

Key responsibilities:
	◦ Establish a Data Improvement Group (DIG) aimed at resolving semantic differences and improving data quality
	◦ Create a Semantic Model that provides business users with an understanding of their data
	◦ Uplift the use of Power BI by productionising a pilot system and through business user training
Key activities and achievements:
	◦ Created the Charter for the Data Improvement Group, liaised with Subject Area business users and chaired initial DIG meeting
	◦ Created & maintained a Common Data Matrix that mapped data domains to business areas that define, produce & use that data
	◦ Reviewed, documented, and updated the CEFC Data Dictionary with naming & definitional information obtained from business stakeholders, resolving business differences through use of a Semantic Model that defined each data element in context
	◦ Created a Data Mapping document showing data flows from production source to the Common Data Platform (data warehouse)
	◦ Analysed and documented the Power BI environment
	◦ Trained business users in the existing Power BI reports and how to extend them with other visualisations

BI Analyst (short-term contract)

Queensland Urban Utilities

Key responsibilities:
      ◦ Act as the coordination point	 for the achievement of data quality objectives
      ◦ Contribute to the data quality framework and processes
      ◦ Implement Data Quality business rules, reporting and monitoring
Key achievements:
      ◦ Assessed the data quality framework & processes, presenting background briefing of the framework and current position
      ◦ Elicited business requirements for the Contract Variations data quality report, highlighting the differences between Open Windows and Ellipse contract information, using Power BI as the visualisation tool
      ◦ Created Interface Dependency Agreements (IDAs) between all source system stewards and the Enterprise Data Warehouse (EDW) team, in order to support the introduction of more robust & sustainable business governance over the EDW data
      ◦ Performed system integration (SIT) and user acceptance (UAT) testing of source-to-EDW ETL jobs in an Agile environment

BI Data Quality Analyst

Seeking Work

I sought out new opportunities, studied to keep my skills fresh, and attended industry forums to improve my network of Brisbane contacts.

Business Intelligence & Data Architect

Infoready

Key responsibilities:
      ◦ Provide consultancy and business support to clients.

Key achievements:
      ◦ Conducted an Impact Assessment and created a Change Proposal to fix invalid data being passed to an ArcGIS system used at Energex
      ◦ Documented user requirements using Enterprise Architect and used them to update rollingstock performance & payment Pentaho reports for the New Generation Rollingstock project (Transport & Main Roads)

Managing Consultant

Ergon Energy

Ergon Energy supplies electricity to homes and business, and maintains and expands the electricity network in regional Queensland.

Key responsibilities:
      ◦ Provide data models & canonical names for Enterprise Semantic Information Model (ESIM) reporting in the SAP HANA data warehouse

Key achievements:
      ◦ Provided a data dictionary that mapped existing source system data to business-approved canonical names and definitions that formed the basis of the EDW design. This involved reviewing approximately 12,000 physical column names, harmonising them against industry models such as the CIM (Common Information Model, developed by the electric power industry) and the existing EDW, to produce around 9,000 business names and definitions
      ◦ Developed & maintained detailed Conceptual and Logical Data Models for a number of Subject Areas defined in the ESIM and realised in the Enterprise Data Warehouse (EDW), including Location (geographic points, lines & areas), Meteorology (forecasts & weather events), Network Asset Management (inspections, work orders and maintenance)
      ◦ Began migrating the Logical Data Models from CA ERwin® Data Modeler (Relational style) to Enterprise Architect (UML style)

Logical Data Modeller, ESIM Team (on assignment from Infoready)

Contribute to the ongoing activities and engagement work of the company, either internally by providing tender responses, advice and support; or externally by being placed on assignment with organisations that need assistance in maximising the business value of their data.

Information Management Consultant

Services Australia (Medicare)

The Department of Human Services (DHS) is responsible for providing access to social, health, and other payments and services.

Key responsibilities:
      ◦ Provide business information & design support for Medicare Enterprise Data Warehouse (EDW) reporting

Key achievements:
      ◦ As the first business analyst ever engaged to cover the EDW, identified and engaged with business & technical stakeholders, developing strategies and creating new business processes that enabled & supported business analysis of the EDW
      ◦ Designed BI solutions covering a series of Medicare reporting projects including Streamlined Pharmaceutical Benefits Scheme (PBS) Claims, Australian Childhood Immunisation Registry (ACIR) reminder letters, Extending Immunisation Requirements, Automating PBS Authority Approvals, and management information covering the Provider Digital Access (ProDA) portal
      ◦ Provided data models, data flow diagrams, data dictionaries, report designs, & SAS Portal screen flows to document project-impacted portions of the Medicare EDW
      ◦ Supported system testers by briefing them on the reporting solutions, incl. SAS Portal report screens, data structures and expected outputs
      ◦ Advised management on the Medicare Benefits Schedule (MBS)/Pharmaceutical Benefits Schedule (PBS) split requested by the Australian Information Commissioner
      ◦ Provided specialist advice to BIDS regarding information & data governance policies, strategies & issues
      ◦ Approved mainframe ETL software release packages (Endevor) on behalf of the BIDS branch

Business Analyst, Medicare EDW (on assignment from Catapult BI)

David Jaques-Watson is a Data Modeller & BI Analyst, with 30 years of experience in business and systems analysis, data and information modelling, data warehouse design, BI reporting, enterprise architecture, data governance, reference and master data management, and data quality techniques.

His most recent engagement was at QSuper, where he worked on conceptual data models and logical database designs (dimensional) to support the design and implementation of data warehousing and BI solutions for projects such as DaPM and systems such as the Financial Crime System (FCS). Previously he was at QUT, where he worked on data governance deliverables (data models, business glossary, data dictionary, report catalogue) and a Common Data Model based on CAUDIT, and the TCSI and QTAC (OP to ATAR) change projects.

David has taken leading roles in diverse & complex data management projects with DHS, the ATO & Centrelink. These projects typically focussed on data governance, design, quality, reference data & metadata management. His project experience is complemented by many successful consultancy assignments in which he has assisted strategically in the formation of major enterprise data repositories & their associated structures, processes & widely varying end uses.

David holds a Bachelor of Business (Comp. & Mgt. Info Systems) from Charles Sturt University & is an active member of industry organisations such as the Data Management Association (DAMA) & the Institute of Analytics Professionals Australia (IAPA).

Taplio

David Jaques-Watson's Linkedin Analytics

David Jaques-Watson

Want to drive more opportunities from LinkedIn?

Taplio

.css-1jgreyo{background-image:linear-gradient(284deg, rgba(39,43,72,1) 0%, rgba(33,47,183,1) 100%);color:transparent;-webkit-background-clip:text;background-clip:text;}David Jaques-Watson's Linkedin Analytics

David Jaques-Watson

Want to drive more opportunities from LinkedIn?

David Jaques-Watson's Linkedin Analytics