Data Warehouse Consultant

Summary: The Data Warehouse Consultant role involves identifying data requirements, designing and managing business intelligence reporting, and implementing ETL processes. The consultant will engage with stakeholders, provide documentation and training, and maintain analytical products. Experience with Oracle and business intelligence platforms is essential, along with skills in data modeling and data architecture design. The position is a 6-month contract with a hybrid working arrangement in Dublin.

Key Responsibilities:

• Identify data requirements and data sources and engage with data owners and stakeholders to ensure data access and ingest.
• Design, develop, implement, and manage business intelligence reporting and Extract, Transform, Load (ETL) processes and environments.
• Design of data models and warehousing to best meet the requirements of DAFM Business Divisions and to maximise capabilities of available tools.
• Liaise with the business owners to monitor and report on project progression.
• Write and provide documentation including functional & technical specification and user guides or any supporting documentation required by the business owner.
• Provide training including presentations and facilitate/organise workshops as required.
• Maintenance and support of analytical products throughout their life cycle.
• Oracle/PLSQL development experience like in writing stored procedures, data processing in oracle etc.
• Big Data/Spark/PySpark/Hadoop experience a bonus.
• Developing Power BI dashboards a bonus (accept Tableau, Qlik, Quicksight, Jsper, etc…).

Key Skills:

• Experience with real-time analytics and business intelligence platforms including the following software and database systems; Microsoft Power BI, Oracle, Cloudera & Hadoop.
• Oracle is a must-have.
• Using scripting languages to develop new insights from the available data. Including the following programming languages; SQL/ PL-SQL.
• Experience in designing, developing, documenting, managing, and implementing business intelligence technical solutions covering Data modelling and Data architecture design (both logical and physical).
• Experience in Data Warehouse design methodologies e.g. star and snowflake schemas, or equivalent.
• Implementation, ETL, data integration and data migration design and implementation and Data warehouse performance optimisation.
• Experience in data management best practices including demonstrated experience with data profiling, sourcing, and cleansing routines utilising typical data quality functions including standardisation, transformation, rationalisation, linking and matching.
• Experience in providing data that is accurate, congruent, and reliable, and ensure the information is easily available to users for direct consumption or integration with other systems.
• Experience supporting mission-critical enterprise BI Systems.
• Experience in delivering end to end BI systems.
• Experience of working within a Public Service Body to develop insights for data driven policy development.

Salary (Rate): £420 per day

City: Dublin

Country: Ireland

Working Arrangements: hybrid

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT