Technical Consultant

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.

The role:

As a Technical Consultant at RTBSS, you will play a pivotal role in delivering expert technical solutions to our clients. This role bridges the gap between complex technical requirements and real-world business needs. 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.

Personal Development:

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: Ability to write complex T-SQL scripts, including the creation and optimization of views, stored procedures, and advanced queries.
• 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.
• Strong Analytical and Problem-Solving Skills: Proven ability to troubleshoot and resolve intricate technical issues efficiently.
• Excellent Communication and Leadership Skills: Ability to lead client engagements, communicate effectively with stakeholders of varying technical backgrounds, and present complex information clearly.
• Adaptability and Continuous Learning: Demonstrated ability to quickly learn new technologies and adapt to evolving business and client needs.
• Understanding of Software Architectures: Comprehensive knowledge of front-end, back-end, APIs, databases, and infrastructure components.
• Effective Stakeholder Management: Skilled in engaging with diverse client stakeholders, tailoring communication to suit different levels of technical understanding.
• Documentation and Diagramming: Proficient in creating detailed documentation and diagrams that are easily understood by both technical and non-technical stakeholders.
• Resilience and Tenacity: Strong determination to overcome challenging problems, with a passion for continuous improvement and innovation.

Key Responsibilities

Client-Focused System Consulting

• Lead Technical Projects: Analyse client business processes and technical environments to recommend and deliver robust solutions.
• Client Engagement and Requirements Gathering: Work directly with clients to capture and validate technical and functional requirements.
• Solution Architecture: Design scalable, secure, and maintainable system architectures tailored to client needs.
• 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.
• Team Collaboration and Mentorship: Collaborate with internal development and delivery teams while mentoring junior consultants.
• 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.
• Systems Integration: 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.
• Query Optimisation: 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.
• Code Review and Standards: Enforce quality through peer reviews and continuous improvement of development standards.
• Technology Innovation: Stay up to date with emerging trends and incorporate best practices into client engagements.

If you are eager to join a company where you can truly make a difference and grow your career, we encourage you to apply for this exciting opportunity today.

Job Type: Full-time, Permanent

Pay: From £35,000.00 per year depending on experience

Benefits:

• Hybrid working
• Casual dress
• Company pension
• Flexitime
• Free or subsidised travel
• Free parking
• On-site parking
• Work from home