Report Writer / Database specialist

POSITION OVERVIEW A Report Writer specialized in SQL Server Reporting Services (SSRS) responsible for designing, developing, and maintaining business reports that transform raw data into meaningful insights to support decision-making. The role focuses primarily on advanced SSRS report development, requiring strong knowledge of report design, dataset creation, parameter handling, and SQL query optimization. Additionally, the candidate should have experience working with relational databases, data modeling, ETL processes, and complementary BI tools such as Power BI. KEY RESPONSIBILITIES SSRS Report Development (Primary Responsibility) * Design, develop, and maintain advanced reports using SQL Server Reporting Services (SSRS). * Translate business requirements into structured and user-friendly reports. * Create efficient datasets using optimized SQL queries. * Implement parameters, filters, expressions, and grouping logic in SSRS reports. * Optimize report performance when handling large data volumes. * Maintain and improve existing reports ensuring reliability and accuracy. Data Analysis and Preparation * Analyze, clean, and organize raw data from multiple sources. * Prepare datasets to facilitate reporting and business analysis. * Perform data analysis and communicate relevant findings. Data Modeling and Optimization * Prepare data models that support efficient reporting. * Apply best practices in database design and data modeling. * Identify and resolve SQL query performance issues. ETL and Data Integration * Develop and maintain ETL processes using data integration tools such as: * SSIS * Pentaho (Spoon) * RedGate’s software tools * Support data migration and data integration initiatives. * Monitor and optimize data loading processes. Complementary Business Intelligence * Create dashboards and visualizations in Power BI when required. * Support business decision-making through data-driven reporting.