The ideal candidate will have solid experience working with the Microsoft Data Stack, particularly MS SQL Server, T-SQL, and SSRS, with the ability to manage report development from design through deployment and ongoing support.
RequirementsKey Responsibilities
- Develop, maintain, and optimize SQL Server databases, queries, and reporting solutions.
- Design, build, and maintain SSRS reports from requirements through deployment.
- Create and optimize advanced T-SQL queries, stored procedures, and database views.
- Develop report datasets, parameters, subscriptions, and deployment configurations.
- Troubleshoot and resolve report performance and data-related issues.
- Ensure the accuracy, integrity, and consistency of reporting data.
- Support business users with reporting requests and enhancements.
- Extract, transform, and prepare data for reporting and analysis.
- Collaborate with technical teams to deliver high-quality reporting solutions.
- Assist with the transition toward modern BI platforms, including Power BI.
- Diploma or Degree in Information Technology, Computer Science, Information Systems, Data Science, or a related field.
- 2–4 years' experience in Data Engineering, SQL Development, or Business Intelligence.
- Strong hands-on experience with Microsoft SQL Server.
- Practical experience developing reports using SSRS.
- Experience writing advanced T-SQL queries for reporting and data transformation.
- Microsoft SQL Server
- T-SQL Development
- SQL Server Reporting Services (SSRS)
- SQL Query Optimisation
- Stored Procedures
- Database Views
- Data Transformation
- Report Development & Deployment
- Relational Databases
- Microsoft Excel
- Python
- Pandas
- Power BI
- Grafana
- Splunk
- Strong analytical and problem-solving skills
- Excellent attention to detail
- Effective communication skills
- Ability to work independently and collaboratively
- Strong time management and organisational skills
Skills Required
- Diploma or Degree in Information Technology, Computer Science, Information Systems, Data Science, or related field.
- 2-4 years' experience in Data Engineering, SQL Development, or Business Intelligence.
- Hands-on experience with Microsoft SQL Server.
- Practical experience developing reports using SSRS.
- Experience writing advanced T-SQL queries for reporting and data transformation.
- Experience with SQL query optimisation.
- Experience developing and maintaining stored procedures.
- Experience creating and using database views.
- Experience working with relational databases.
- Proficiency with Microsoft Excel.
- Python
- Pandas
- Power BI
- Grafana
- Splunk
What We Do
Blue Pearl is a market-leading CLOUD Solutions developer with extensive knowledge and insight into the latest technologies, standardised processes, advanced technical capabilities and consulting processes available, ensuring wholistic success for our clientele. We offer professional consulting to compliment your business strategy and overall management and make it our priority to add value to any business by listening, analysing and creating a conducive solution that will empower our client. We implement a Data Analysis Process that includes inspecting, cleansing, transforming, and modelling data with the end-goal of discovering useful information, informing conclusions, and relevant information to support your decision-making. Your business cannot afford not to engage with us, allowing our data analysis to play a role in making your business decisions more scientific and helping your business achieve effective operation. Blue Pearl’s team of experts include BI strategists, BI analysts, Data Warehouse Architects, Data Scientists, Implementation and Development experts. With the use of BI, Analytics and Big Data, we effectively partner with our customers on their mission to achieve a competitive business advantage and real ROI from the structured information we collect.
