Reporting Analyst

at  Codec

DESCRIPTION

We are looking for a reporting analyst to join our Data and AI Team.

SKILLS, KNOWLEDGE 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

• 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 SSA
• 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 repot usage and data analysis