Summary: The role involves designing, developing, and deploying ETL packages using SSIS, as well as creating interactive reports and dashboards with SSRS. The position requires collaboration with data engineers and participation in the full software development lifecycle to meet business reporting and data integration needs. Strong SQL skills are essential for maintaining complex queries and ensuring data quality. The candidate will also be responsible for troubleshooting ETL processes and optimizing performance.

Key Responsibilities:

• Design, develop, and deploy ETL packages using SSIS.
• Develop and maintain complex SQL queries, stored procedures, functions, and triggers.
• Design and develop reports and dashboards using SSRS.
• Gather and analyze business requirements for reporting and data integration.
• Translate business requirements into technical specifications.
• Perform data analysis and profiling to ensure data quality.
• Optimize performance of SSIS packages and SSRS reports.
• Troubleshoot and resolve ETL process and data quality issues.
• Create and maintain technical documentation for ETL processes and reports.
• Collaborate with data engineers on data warehouse and data mart structures.
• Participate in the full software development lifecycle.

Key Skills:

• Microsoft BI, SSIS, SSRS, and SQL.
• Experience with JIRA (good to have).
• Data analysis and data profiling skills.
• Ability to translate business requirements into technical specifications.
• Strong troubleshooting skills for ETL processes.
• Technical documentation skills.
• Collaboration skills with data engineers.
• Understanding of data warehouse and data mart structures.
• Experience in the software development lifecycle.

Salary (Rate): undetermined

City: Warwick

Country: UK

Working Arrangements: undetermined

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT