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