Technical Consultant (SQL / BI / Data)
About the Role
Our client is seeking a technically strong and proactive Technical Consultant
(SQL/BI/Data) to join their growing team.
This is a client-facing, hands-on role where the primary responsibility is understanding
customer requirements and implementing a specialist reporting software solution within
client environments.
The successful candidate will regularly engage with managers and stakeholders to gather
reporting requirements, remotely connect to client servers, analyse databases and systems,
and ensure seamless integration between the reporting platform and client data sources.
The role combines SQL development, database investigation, cross-system data integration,
software implementation, client training, and practical problem-solving.
Key Responsibilities
● Engage directly with managers and stakeholders to understand reporting and
business requirements
● Translate business requirements into robust SQL-based solutions
● Remotely connect to client servers to install, configure, and support the reporting
software
● Identify where relevant data is stored across client systems (not limited to SQL
Server)
● Extract and interpret data from a range of database platforms and business systems
● Analyse and understand existing database structures and data relationships
● Understand how the software connects to and interacts with SQL databases
● Create and modify:
○ SQL views
○ Stored procedures
○ Functions
○ Tables
● Apply fixes, updates, and performance improvements within SQL Server
● Troubleshoot database, connectivity, and networking issues
● Work within Windows Server environments and liaise with client IT teams
● Deliver training sessions to clients on effective use of the software
● Provide post-implementation support and guidance to users
● Take ownership of implementations from initial setup through to completion
Essential Skills & Experience
● Strong experience with Microsoft SQL Server
● Advanced SQL querying (joins, aggregations, subqueries, troubleshooting)
● Experience creating views, stored procedures, and functions
● Solid understanding of relational database design
● Experience working within Windows Server environments
● Good understanding of networking fundamentals (permissions, ports, firewalls, DNS)
● Experience remotely accessing and working on client infrastructure
● Confident communicator able to work with non-technical stakeholders
● Ability to work independently and proactively solve problems
Desirable (Not Essential)
● Understanding of bookkeeping principles and core financial structures (e.g. nominal
ledger, trial balance, sales/purchase ledgers)
● Experience working with financial accounting systems or ERP platforms
● Experience deploying or supporting applications via IIS
● Exposure to APIs and application integrations
● Exposure to other SQL dialects (e.g. MySQL, PostgreSQL)
● Experience working with other database management systems (DBMS)
● Experience working with C#
● Familiarity with JSON used within application environments
Personal Attributes
● Self-motivated and organised
● Practical and solution-focused
● Comfortable taking ownership of projects
● Calm and methodical when troubleshooting
● Strong attention to detail
● Professional and confident when dealing with clients
