Job Description
Once code has been tested, you oversee its deployment, ensuring that affected parties have been notified and are expecting the change, and that the deployment won’t affect any currently running reports and processes. Where necessary, you create process notes and other supporting documentation.
Responsibilities:
- Developing and maintaining the suite of Data Analytics products and bespoke customer solutions.
- Building new and adapting existing SSRS Report RDLs.
- Developing, creating and maintaining SQL Server objects inside the Reporting database.
- Understanding the structure and utilisation of SQL Server objects inside the MiWarehouse and Quotatio databases.
- Maintaining the extraction procedures that transform the data from MiWarehouse into usable Reporting data.
- Creating supporting documentation for new and changing processes to be supplied to Data Delivery.
- Supporting the QA Tester with creating test plans, designing tests and generating test outputs for developed pieces of work.
- Refining backlog items by working with stakeholders to understand their requirements, and creating stories that are ready for a developer to begin working on.
- Responding to incidents by identifying the source of the problem and seeking a resolution.
- Reporting any bugs, mistakes in data, or data leaks to the relevant people and escalating where needed.
- Identifying, reporting and reducing technical debt.
- A to coding standards and code peer reviews.
- Supporting other developers with SQL-based code reviews.
- Identifying and escalating capacity and performance issues.
- Reducing performance issues wherever possible or required.
- Creating proof of concepts for new products and demonstrating them to the product owner and stakeholders to understand and analyse further requirements.
- Partaking in and delivering team training and knowledge sharing to enhance skills and knowledge.
Qualifications
- SQL code development.
- Knowledge of relational database design.
- SSRS report building.
- Ability to work with others.
- Strong communication skills – including the ability to present complex technical specifications to non-technical users and stakeholders.
- Effective time management skills.