At a Glance
- Tasks: Deliver expert technical solutions and support clients in various industries.
- Company: Join RT Business System Solutions Ltd, a tech consultancy focused on ending housing poverty.
- Benefits: Enjoy hybrid working, casual dress, flexitime, and free travel perks.
- Why this job: Make a real impact while developing your skills in a supportive team culture.
- Qualifications: Experience with SQL, OOP, ETL, and strong problem-solving skills required.
- Other info: Opportunity for personal development and mentorship in a dynamic environment.
The predicted salary is between 28000 - 42000 Β£ per year.
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
Technical Consultant employer: LinkedIn
Contact Detail:
LinkedIn Recruiting Team
StudySmarter Expert Advice π€«
We think this is how you could land Technical Consultant
β¨Tip Number 1
Familiarise yourself with the specific database technologies mentioned in the job description, especially Microsoft SQL Server. Consider working on personal projects or contributing to open-source projects that utilise these technologies to showcase your hands-on experience.
β¨Tip Number 2
Brush up on your SQL skills by creating complex T-SQL scripts. You could even set up a mock project where you design and optimise views and stored procedures, as this will not only enhance your skills but also give you concrete examples to discuss during interviews.
β¨Tip Number 3
Engage with communities or forums related to technical consulting and data integration. Networking with professionals in the field can provide insights into the role and may even lead to referrals or recommendations for the position at RTBSS.
β¨Tip Number 4
Prepare to demonstrate your problem-solving skills by thinking of real-world scenarios where you've successfully resolved technical issues. Being able to articulate these experiences clearly will show your potential employer that you can handle the challenges of the role.
We think you need these skills to ace Technical Consultant
Some tips for your application π«‘
Tailor Your CV: Make sure your CV highlights your experience with database technologies, SQL proficiency, and any relevant programming skills. Use specific examples that demonstrate your problem-solving abilities and client engagement experience.
Craft a Compelling Cover Letter: In your cover letter, express your passion for technology and how it can help end housing poverty. Mention your adaptability and eagerness to learn, as well as your ability to communicate complex information clearly to diverse stakeholders.
Showcase Relevant Projects: If you have worked on similar projects, describe them in your application. Highlight your role in data integration, system architecture design, or any technical troubleshooting you performed, as these are key responsibilities of the Technical Consultant role.
Prepare for Technical Questions: Be ready to discuss your technical skills in detail during the interview process. Brush up on your knowledge of ETL tools, data warehousing concepts, and object-oriented programming, as these will likely be focal points in discussions.
How to prepare for a job interview at LinkedIn
β¨Showcase Your Technical Skills
Be prepared to discuss your experience with database technologies, particularly Microsoft SQL Server. Highlight your proficiency in writing complex T-SQL scripts and any relevant projects where you've implemented ETL processes or data warehousing solutions.
β¨Demonstrate Problem-Solving Abilities
Expect to face technical scenarios during the interview. Prepare to explain how you've tackled intricate technical issues in the past, showcasing your analytical skills and resilience in overcoming challenges.
β¨Engage with Stakeholders
Since the role involves client engagement, practice articulating how you gather and validate requirements from clients. Be ready to discuss your approach to tailoring communication for different stakeholders, ensuring clarity regardless of their technical background.
β¨Emphasise Continuous Learning
RT Business System Solutions Ltd values adaptability and a willingness to learn. Share examples of how you've quickly picked up new technologies or adapted to changing project needs, demonstrating your commitment to personal and professional development.