Full-time, Permanent, Hybrid working, from £35,000.00 per year depending on experience
RT Business System Solutions Ltd (RTBSS) is a technical consultancy and software development business based in South Wales. We provide high-quality IT solutions to a range of companies, especially housing organisations and councils, across the UK, aiming to help them end housing poverty and support local communities.
As a Technical Consultant at RTBSS, you will play a pivotal role in delivering expert technical solutions to our clients. You will be responsible for advising clients, designing and implementing technical solutions, and supporting post-implementation phases. The role involves hands-on configuration, data integration and migration, and stakeholder engagement to ensure the success of technology projects across diverse client environments.
As a Technical Consultant at RTBSS, you will have the opportunity to work on a variety of exciting projects, and to collaborate with a huge variety of people across various industries.
We acknowledge that as a Technical Consultant, you may not initially be familiar with all aspects of the role or the sectors we operate. That's why we aim to provide the training and guidance you need through a supportive team culture.
Essential Skills / Qualities
Extensive Experience with Database Technologies: Expertise in Microsoft SQL Server and other database systems.
Advanced SQL Proficiency: Object-Oriented Programming: Can write scripts in an object-oriented programming (OOP) language, ideally C#.
Expertise in ETL and Data Warehousing: Comprehensive understanding of ETL tools and techniques, data warehousing concepts, and best practices.
Understanding of Software Architectures: Comprehensive knowledge of front-end, back-end, APIs, databases, and infrastructure components.
Lead Technical Projects: Analyse client business processes and technical environments to recommend and deliver robust solutions.
Data Integration Leadership: Deliver advanced data integration solutions using tools such as SQL Server Integration Services (SSIS).
Reporting Excellence: Develop meaningful client-facing reports using SSRS, Power BI, and other reporting tools.
Implementation Support: Guide clients through deployment and testing phases, ensuring smooth handovers and user adoption.
Technical Troubleshooting: Act as a subject matter expert in diagnosing and resolving technical issues during implementation or live operation.
Client Training and Support: Provide training to client users, supporting them post-go-live to maximise solution impact.
SQL Development and Data Engineering
Data Pipeline Design: Implement advanced ETL pipelines that support client data transformation needs across various systems.
Ensure seamless data connectivity between client systems using modern interfaces and integration protocols.
Data Migration: Lead data migration projects, ensuring accuracy, integrity, and minimal downtime.
Improve system performance through query tuning and indexing strategies.
Data Warehouse Design: Create and maintain scalable data warehouse solutions aligned to client objectives.
Collaborative Development: Work closely with in-house and client development teams to embed data solutions into software systems.
Issue Resolution: Investigate and resolve issues in data pipelines, interfaces, and client environments.
Enforce quality through peer reviews and continuous improvement of development standards.
Job Type: Full-time, Permanent
00 per year depending on experience
Hybrid working
Company pension
Free or subsidised travel
Free parking
On-site parking
Work from home