Database/Data Warehouse Consultant – Contract
Senior Infrastructure Recruitment Consultant at E-Frontiers Ltd
Qualifications
* A degree in Computer science, Data Science or a relevant related discipline.
* A recognised industry standard certification in Data Engineering.
Key Deliverables
* 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 data models and warehousing to best meet the requirements of DAFM Business Divisions and to maximise capabilities of available tools.
* Liaise with business owners to monitor and report on project progression.
* Write and provide documentation including functional & technical specifications and user guides or any supporting documentation required by the business owner.
* Provide training, including presentations, and facilitate/organise workshops as required.
* Maintain and support analytical products throughout their life cycle.
Key Experience, Competencies & Skillsets
* 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 such as 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 data profiling, sourcing, and cleansing routines utilizing typical data quality functions such as standardisation, transformation, rationalisation, linking, and matching.
* Experience in providing data that is accurate, congruent and reliable, and ensuring the information is easily available to users for direct consumption or integration with other systems.
* Experience with real‑time analytics and business intelligence platforms including Microsoft Power BI, Oracle, Cloudera & Hadoop.
* Using scripting languages to develop new insights from the available data, including SQL/PL‑SQL.
* Experience supporting mission‑critical enterprise BI systems.
* Experience delivering end‑to‑end BI systems.
* Experience working within a Public Service Body to develop insights for data‑driven policy development.
Seniority Level
Mid‑Senior level
Employment Type
Contract
Job Function
Information Technology
Dublin, County Dublin, Ireland
#J-18808-Ljbffr