Senior Staff Officer IT

The Housing Agency is now seeking applications for a Database Developer/Analyst at Senior Staff Officer IT – Grade VI level. This is a permanent vacancy in the IT Team. The Database Developer/Analyst will help to modernise our data infrastructure, reduce reliance on legacy systems, and provide timely, accurate reporting to support data-driven decision making. This post is based in our offices in Dublin 2. The Housing Agency operate a Blended Working Policy.

Main Duties

• Engage with business units to gather, analyse, and document data requirements.

• Design and develop scalable, secure, and efficient SQL-based cloud databases (e.g., Azure SQL).

• Lead the upgrade and migration of legacy Microsoft Access databases to modern cloud-based platforms.

• Ensure data quality and integrity across systems.

• Develop and maintain data models, stored procedures, and ETL processes.

• Create and maintain comprehensive documentation for database structures, data flows, and business logic.

• Provide training and support to business users on accessing and using data systems effectively.

• Collaborate with internal ICT team and external vendors as needed to ensure successful delivery of data solutions.

• Lead and coordinate projects including reporting on progress and outcomes.

• Contribute to the delivery of the Housing Agency’s IT strategy and digital transformation initiatives.

• Provide expert technical support and guidance to internal departments and stakeholders.

• Stay current with emerging technologies and integrate relevant innovations into practice.

• Contribute to the leadership of the ICT function, supporting team development, project delivery, and strategic alignment with organisational goals.

• Demonstrate excellent communication and customer service skills in all interactions.

• Other duties as assigned from time to time.

Educational & Experience Requirements

• Bachelor’s degree (or equivalent) in Computer Science, Information Systems, Data Science, or a related discipline.

• Minimum of 3 years’ professional experience in MS-SQL database development and administration, including cloud-based environments.

• Demonstrated proficiency in SQL (T-SQL or equivalent), including data modelling, query optimisation and performance tuning.

• Experience with ETL tools, such as SQL Server Integration Services (SSIS), Azure Data Factory, or Power Automate, particularly in automating data flows and integrating cloud-based systems.

• Proven ability to gather and translate business requirements into effective technical solutions.

• Experience in upgrading and migrating legacy systems, particularly Microsoft Access and Excel-based data solutions.

• Familiarity with data governance principles and GDPR compliance.

• Working knowledge of scripting languages (e.g., Python, PowerShell) for automation and data processing.

• Experience documenting technical processes and communicating effectively with non-technical stakeholders.

• Relevant professional certifications (e.g., Microsoft Certified: Azure Database Administrator Associate) are desirable.

• Strong analytical thinking and creative problem-solving capabilities.

• The ideal candidate will be a collaborative problem-solver with a strong technical foundation and a keen understanding of business needs.

Competencies

Management & Delivery of Results – proactively identifies areas for improvement and develops practical suggestions for their implementation.

Communications and Interpersonal Skills – Excellent communication and interpersonal skills with an ability to interact with all levels, internally and externally.

Analysis and Decision Making – takes account of any broader issues and related implications when making decisions.

Drive and Commitment – demonstrates resilience in the face of challenging circumstances and high demands.

Specialist Knowledge – Demonstrates deep and current knowledge of database technologies, with the ability to apply this expertise to develop, modernise, and optimise data systems that support business operations and decision-making.

Salary Scale – Senior Staff Officer – Grade VI LA Scales

€57,322 – €58,689 – €60,356 – €63,491 – €65,363 LSI 1 – €67,690 LSI 2 – €70,030

New entrants will be appointed on the first point of the scale in line with government policy. Different terms and conditions may apply if immediately before appointment you are a currently serving civil/public servant.

Eligibility to Compete

Candidates should note that eligibility to compete is open to citizens of the European Economic Area (EEA). The EEA consists of the Member States of the European Union along with Iceland, Liechtenstein and Norway. Swiss citizens under EU agreements may also apply. To qualify candidates must be citizens of the EEA by the date of any job offer. Eligible candidates must be:

a) A citizen of the European Economic Area. The EEA consists of the Member States of the European Union, Iceland, Liechtenstein and Norway; or

b) A citizen of the United Kingdom (UK); or

c) A citizen of Switzerland pursuant to the agreement between the EU and Switzerland on the free movement of persons; or

d) A non-EEA citizen who is a spouse or child of an EEA or Swiss citizen and has a stamp 4 visa; or

e) A person awarded international protection under the International Protection Act 2015 or any family member entitled to remain in the State as a result of family reunification and has a stamp 4 visa; or

f) A non-EEA citizen who is a parent of a dependent child who is a citizen of, and resident in, an EEA member state or Switzerland and has a stamp 4 visa.