Unijobs on behalf of our public sector client have a requirement for a Business Intelligence Developer & Analyst who will be reporting to the Chief Data Architect.
This is a temporary position for a duration of 82 weeks, based in Dublin 8 and there may be an option to work on a hybrid basis.
Working 35 hours per week, the successful candidate will be employed as an agency employee and will be paid an hourly rate equivalent to the annual salary. The salary scale associated with this position is €55,644.00 - €67,981.00. You will also accrue 30 days annual leave per year and paid Bank Holidays.
Purpose of the role:
Reporting to the Chief Data Architect, this is a key role within the Centre for Data & Analytics and carries a technical responsibility for the provision and ongoing development of business information, data and analytics services. Including the technical infrastructure to support the same.
Data Engineering:
- Ad hoc SQL Operational Queries: Create and supply ad hoc reports for end users, raising tickets for data requests.
- SQL Queries Development: Develop SQL queries for data analysis purposes, enhancing reporting capabilities for users.
- SQL Daily Jobs Management: Monitor and manage 150 SQL jobs for the data warehouse (including ETL packages). Investigate, correct, and create new jobs as necessary.
- Database Administration: database consistency checks and resizing exercises, raise tickets for adjustments.
- Project Work: Write stored procedures and create tables and views in SQL for Power BI reports.
Reporting Services:
- Report Migration: Migrate tabular model reports to Power BI from scratch.
- Power BI Reports: Create Power BI reports using DAX for end users.
- Patient Level Reports: Create and amend patient level reports on Excel and provide access via SharePoint.
- Monthly KPI Updates: Update in-house KPIs for Income and Expenditure, HR Training, Medical Oncology Metrics, BI Pressure Ulcer Metrics, and NCCP Metrics.
- Finance Reports: Provide monthly reports to finance, including Consultant Contract compliance, ABF Report, SACC NTPF Outpatient, and weekly extracts for Inpatient Day case and Outpatient waiting lists to the NTPF. Address data integrity issues with the Dedulas NTPF extract.
Training:
- Power BI Training: Conduct quarterly Power BI training sessions.
- Ad hoc Training: Provide ad hoc training on Power BI and Excel Services as required.
Required
Candidates must have at the latest date of application:
- Have not less than three years satisfactory experience in an administrative capacity within the Public Sector / Hospital / Health Care environment relevant to the role.
- A minimum of three years' experience in database design and development in a large data warehouse environment to include, ETL Tools; relational/ multidimensional databases.
- A minimum of two years' experience in MS SQL technologies; SQL Server; Analysis Server; Reporting Server; Integration Server.
- A minimum of two years' experience in Visualisation Tools.
- Strong query language knowledge especially SQL; MDX; DAX.
- Highly evolved analytical skills to ensure clear analysis and sound decision making.
- Knowledge of Data Protection/Data confidentiality.
- Possess sufficient administrative capacity to discharge the functions of the grade.
- Relevant third level qualification specialising in Data Analytics or Data Science.
*The above Role Profile is not intended to be a comprehensive list of all duties involved and consequently the post holder may be required to perform other duties as appropriate to the post which may be assigned to him/her from time to time and to contribute to the development of the post while in office. This Role Profile will be subject to review in the light of changing circumstances*
This position may be subject to Garda Vetting and Foreign Police Clearance, if applicable you will be required to obtain these prior to commencing in this role
Unijobs is an equal opportunities employer
