Reporting Analyst
We are seeking a skilled Reporting Analyst to join our Data and AI Team in Dublin.
Key Responsibilities:
* Create, modify, and maintain various types of reports using SQL Server Reporting Services (SSRS).
* Develop and optimize complex SQL queries, stored procedures, functions, and views to support reporting needs.
* Design, develop, and test data extraction, transformation, and loading (ETL) processes using SQL Server Integration Services (SSIS).
* Build and deploy Analysis Services Data Cubes and Tabular Models using SQL Server Analysis Services (SSAS).
* Monitor and troubleshoot the performance and availability of SQL Server databases, SSRS, SSIS, and SSAS.
* Implement best practices and standards for data quality, security, and documentation.
* Collaborate with business users and stakeholders to gather and analyze reporting requirements and specifications.
* Provide technical support and training to end-users on report usage and data analysis.
Required Skills and Expertise:
* Proficiency in SQL Server Reporting Services (SSRS).
* Experience in designing, developing, testing, and deploying SSRS reports and dashboards.
* Familiarity with SQL Server Analysis Services (SSAS) and SQL Server Management Studio (SSMS).
* Ability to write complex SQL queries and stored procedures.
* Understanding of report performance optimization techniques and best practices.