SQL Data Analyst
Remote
United Kingdom
Full Time
26-03-2025
Job Specifications
Job Advert
Salary – Up to £40,000 per annum, depending on experience
Hours - Monday to Friday, 37.5 hours, fully remote
Holiday – 23 days annual leave (excluding bank holidays) increasing by one day per each year of service (up to a maximum of 5 days)
About The SQL Data Analyst Role
We are TC Group, the fastest-growing top 20 accountancy firm in the UK. We’re business advisors and accountants, with over 30 years of experience we’ve honed our skills and developed our service offering to deliver a much wider range of bespoke support and advice to ambitious business owners and their businesses.
Due to growth, we have an exciting role for a SQL Data Analyst to join us on a fully remote basis.
The SQL Data Analyst will play a crucial role in our operations, responsible for maintaining and monitoring our technology systems and data.
Your expertise in configuring and troubleshooting applications is vital in providing resolutions for our people and clients, you will deliver continuous improvement and manage change control over the systems they administer, a task that is integral to our success.
As a SQL Data Analyst you will be responsible for these systems and databases' performance, integrity, and security. You will also be involved in planning and development, managing system changes, troubleshooting any issues on behalf of the users, and providing key support during systems and data migrations. Strong experience using Microsoft SQL Server (T-SQL) is essential, with knowledge and experience of database administration and management an advantage. Experience with the Microsoft Power Suite of tools, including Power Apps, Power Automate, and Power BI is preferred, along with experience with CRM management / administration such as FibreCRM.
Key responsibilities of a SQL Data Analyst will include:
monitor and optimise the performance of critical systems and databases
preparing maintenance plans and schedules for the organisation’s systems and SQL databases
manage aspects of the change process for Technology systems
utilising remote access technology, knowledge sources and diagnostic tools to resolve or triage tickets to other teams or 3rd party suppliers
responsible for providing technical support to teams within the organisation and external clients when required. Your commitment to delivering high-quality service is crucial in ensuring the smooth operation of our systems
assisting with systems integrations and data migrations
manage ticketed query systems and keep a comprehensive database of queries and resolutions current
maintaining and updating technical documents and procedures
identifying and resolving technical issues
developing reports for teams across the business.
About You
We are looking for candidates with the following skills and experience:
minimum of 2 years’ experience using Microsoft SQL Server (T-SQL) is essential (including usage within the last 6 months)
experience with CRM management / administration e.g. FibreCRM
Experience with the Microsoft Power Suite of tools, including Power Apps, Power Automate, and Power BI is preferred
experience with supporting SharePoint applications
hands-on experience with database standards and end-user applications
strong database management system skills, including advanced SQL knowledge and preferably experience of database administration
experience of working with multiple datasets, transforming and using data – knowledge of ETL
excellent knowledge of data security and integrity
working with Citrix Virtual Desktops and Microsoft Applications, you will know how to troubleshoot issues and be able to speak to internal customers in a non-technical way
manage 3rd party suppliers to ensure that incident resolutions are achieved within the agreed SLA
excellent attention to detail, strong analytical skills along with problem-solving and logical thinking skills
strong communication skills, both written and verbal
self-motivated team player, organise own workload with minimal supervision, delivering to agreed schedules and reporting progress
ability to diagnose and investigate issues
ability to explain complex ideas to those with limited IT and systems knowledge
extraordinary customer service and relationship management experience
ability to adapt to changing priorities and willingness to learn on the job
Experience with accountancy applications, preferably CCH, is an advantage
Full benefits available for the SQL Data Analyst:
pension scheme
group life assurance x 4 salary
opportunity to purchase additional holiday days
access to our employee benefits portal – cashback and vouchers on everyday purchases
employee Assistance Programme
employee Referral Bonus – we’re always looking for talented individuals to join our team
regular training and development - continuous development and support not only for your professional qualifications but also for your personal goals and aspirations
About Us
TC Group is growing and changing at quite a pace! We’re an ambitious group of people with the same aim – to create a consistent, high-quality experience for our clients. Like us, our client list is growing – we’re supporting more and more of the UK’s ambitious business owners, SME’s and large Corporations and it’s a real team effort. We’re helping them make courageous decisions to grow their businesses.
We always seek the best talent, looking for individuals who are technically brilliant, solution-focused and continually strive to be the best in class. Each member of our team plays an integral part in creating the unique feel and culture of our business, which in turn helps us continue to grow, develop and evolve. We are an equal opportunity employer and welcome candidates from all backgrounds.
We can only accept applications from candidates who are based in the UK and unfortunately we are unable to provide Sponsorship.
Department
Data Analysis / Systems
Contract type
Permanent
Hours
Monday to Friday, 37.5 hours, fully remote
Salary
Up to £40,000 per annum, depending on experience
About the Company
TC Group | 0330 088 7111 | http://www.tc-group.com TC Group’s an Accountancy Age ‘Top 20’ firm of business advisors and accountants, providing quality financial advice and strategy, enabling you to achieve your business growth goals, safeguard your wealth, and maximise your tax efficiency. Our teams’ experience and expertise mean we understand the challenges and opportunities you face at a local, national, and even, international level. We’ll invest time in getting to know you so we can provide proactive and tailored ad... Know more
Related Jobs
- Company Name
- JD Sports Fashion
- Job Title
- People Technology Junior Data Analyst
- Job Description
- Established in 1981 with a single store in the Northwest of England, the JD Group is a leading omni-channel retailer of Sports Fashion, Outdoors and Gyms with our colleagues working in stores across several retail fascias in many markets around the world. JD Sports Fashion Plc was listed on the London Stock Exchange in 1996 and has been a FTSE100 publicly quoted company since 2019 and continues to grow in the UK and internationally. We want to be the leading global omnichannel retailer in the sports and outdoor industry. To be a part of this successful company and help us to achieve this you will have the desire to ingrain our strategic goals of being a people-led, innovative and customer-focused organisation which provides operational excellence whilst identifying new areas of growth as part of our day to day objectives. Job Title – People Technology Junior Data Analyst Location – BL9 8RR Working rota – Monday - Friday Working hours – 40 hours Role Overview Advance the People Technology team by championing Data and enabling JD to make data-driven decisions with People Data as a source. As a Junior Data Analyst, you will provide support across all workstreams and be integral in the development, configuration, and deployment of all data activities. You will be technically minded and be able to engage with stakeholders and business subject matter experts. The JD People team puts the colleague at the heart of what we do to develop a level of service that emulates the JD brand and maximises colleague experience. Key Roles And Responsibilities Actively participate in knowledge transfer Apply business intelligence, analytics, and reporting knowledge to deliver excellent reporting and analytics Identify data-related errors and resolve issues Support the end-to-end deployment (design, build, test) and ongoing maintenance of data flows across a wide array of functional areas Provide technical support regarding data conversion, integration solution options, report building, analytics and data security Implement policies/standards to gain process efficiency and improve data integrity Collaborate to constantly improve data reliability and quality Manage and meet multiple deadlines and deliverables Support the Data Strategy in all aspects of your work Create customized reports, summarise key takeaways, make recommendations and propose action plans Perform related duties and activities as assigned Create and maintain documentation for all data processes Essential Skills/Experience/Knowledge Elevated level of attention to detail with strong administrative and organisational skills and be able to prioritise your workload to meet deadlines Be aware of GDPR and be able to act with absolute discretion and confidentiality Be data curious, aware of how to use data effectively and aware of new/emerging trends in the data analytics space Ensure high data quality through regular quality checks Advanced knowledge of Microsoft Excel Exposure to reporting/analytics tools (e.g. Power BI, Tableau, Looker) Strong team player with ability to self-motivate Confident and courteous in dealing with internal and external stakeholders Good communication skills both written and oral Gather and analyse data to guide decision making and improve performance Optional Skills/Experience/Knowledge Experience with HCM solutions in a SaaS environment across multiple territories Ability to analyse complex data requirements with a view to the development of data conversion or providing analytic information Knowledge of SQL Understanding of broad data analytics methodologies; data storytelling; data products Awareness of version control concepts Familiarity with IT/Data design and development methodologies (e.g. Waterfall, Agile, DevOps) Experience of Python or other formal programming language We know our colleagues work tirelessly to make JD Sports the success it is today and in turn, we offer them some amazing benefits including staff Discount On JD Group and other brands within the organisation and personal development opportunities to learn and develop at work. Thank you for your time #JD Apply Now
- Company Name
- Vitesse
- Job Title
- Senior Data Engineer
- Job Description
- We are Vitesse, a global leader in cross-border payment solutions, dedicated to empowering businesses with fast, secure, and reliable financial technology. Our engineering department is expanding, and we are looking for a talented Data Platform Engineer to join our team. This role is integral to establishing a robust semantic layer and creating a framework to enable the development of data-heavy features across multiple teams. As a Senior Data Engineer, you will collaborate closely with our business and engineering teams to design, implement, and maintain data engineering solutions while ensuring security and data best practices. You will work on internal and/or Vitesse SaaS platform data initiatives. As a senior you will work mostly independently with light touch leadership from the squad lead. You will join a multidisciplinary squad of 5 data professionals within the organisations wider data team. We work remotely with regular contact time in our London based offices. Your Responsibilities Design, build, and maintain scalable data pipelines for batch and real time data handling large volumes of structured and unstructured data. Develop, enhance, and optimize ELT processes to ingest, transform, enrich and publish data. Build quality, trusted, secure data products for consumption in reporting, analytics and science. Assure the privacy, security and legal compliance of data in data engineering. Optimise data pipelines and queries for better performance and cost-efficiency. Integrate data pipelines with monitoring and observability to proactively detect and resolve issues before they impact business operations. Design and build data models for lake house storage and analytics. Implement and maintain CI/CD pipelines for data engineering. Collaborate with business teams, product owners, analysts and data scientists to understand their needs and ensure availability of relevant data. Capture and maintain data documentation enabling self-service communities to understand, assess and utilise reusable data assets. Research and evaluate cutting-edge data technologies, tools, and practices to improve data engineering processes. Mentor early in career data engineers, support the squad lead in PR review. Requirements Developing data processing pipelines in python and SQL for Databricks including many of the following technologies: Spark, Delta, Delta Live Tables, PyTest, Great Expectations (or similar) and Jobs. Developing data pipelines for batch and stream processing and analytics. Building data pipelines for enterprise data and one other business domain. Building and orchestrating data pipelines and analytical processing for streaming data with technologies such as Kafka, AWS Kinesis or Azure Stream Analytics. Knowledge of data governance, privacy regulations (e.g. GDPR), and security best practices. Delivering data engineering and designing for cloud native data platforms (AWS/ Azure/ Databricks). Building DevOps pipelines for data engineering solutions using Terraform, GitHub, DevOps. Working within highly agile multidisciplinary scrum teams in Scrum/Kanban. Mentoring data engineers, carrying out PR review. Desirable Experience Domain knowledge from insurance, payments or equivalent domains. Building data pipelines to support AI/ML solutions created in Mosaic AI/ML Flow. Background in software engineering Experience automated testing for data Benefits 25 days Holiday per year (increasing by 1 day per years' service, up to 30 days) + Bank Holidays Remote working - UK or EU Based. Contributory pension scheme Enhanced Parental leave Cycle to Work Scheme Private Medical Insurance with AXA Unlimited access to therapy sessions through our partner, Oliva Discounted Gym membership through Gympass Financial Coaching with Octopus Wealth 2 days of volunteering leave per year Sabbatical after 5 years’ service Life Assurance - MetLife (UK employees only) Ongoing Learning and Development to support you reach your career goals Vitesse at our best – our values The Vitesse values are a true reflection of what it takes to thrive in our business, so it’s important to us that any employee who joins our business is aligned with these 3 attributes Confident Humility We don’t do ego and we know that unless we all win, none of us win. We admit when we’re wrong, ask for help and always think about the wider business before ourselves. Driven to Succeed We see the opportunity ahead of us and we won’t stop until we fulfil the potential we know we have. We hold ourselves to high standards and deliver high quality outcomes for Vitesse and our customers. Tenacious Responsibility We take ownership for our actions and decisions, and face into the challenges that come our way. We are committed to seeing things through to completion, even in the face of adversity. We are an Equal Opportunity Employer We are committed to creating an inclusive environment that enables everyone to perform at their best, where we recognise the rights of all individuals to mutual respect and where there is an unbiased acceptance of others. Our policies and practices aim to promote an environment that is free from all forms of Unfair discrimination and values the diversity of all people. At the heart of our policy, we seek to treat people fairly and with dignity and respect. Please confirm if selected for an interview, what interview adjustments you would need? You can contact Clara Moretti-Greene on clara.moretti-greene@vitesse.io or in her absence contact our People Team PeopleTeam@vitessepsp.com.
- Company Name
- Foster + Partners
- Job Title
- Junior Data Engineer
- Job Description
- Foster + Partners Junior Data Engineer Permanent London, Battersea We are a global studio for sustainable architecture, urbanism, engineering and design, founded by Norman Foster in 1967. The Junior Data Engineer role sits in our Information Systems team. Responsibilities Assist in designing, developing, and maintaining data pipelines and ETL (Extract, Transform, Load) processes. Collaborate with senior engineers to integrate multiple data sources into a unified data warehouse, ensuring accuracy and completeness. Support the creation and upkeep of Power BI reports, providing insights and visualisations to inform business decisions. Monitor data quality and system performance, troubleshooting issues promptly. Document technical processes and guidelines, contributing to a shared knowledge base. Work closely with cross-functional teams to understand data requirements and provide effective solutions. Qualities and skills required Familiarity with SQL Basic understanding of database concepts and relational database systems. Strong analytical and problem-solving abilities. Good communication skills and a collaborative mindset, with a willingness to learn from more experienced colleagues. Proficiency in Microsoft Excel, Power BI similar tools for data exploration and reporting. Well-organised, detail-oriented approach to documentation and project tasks. In return we offer a competitive basic salary and generous benefits package which includes 25 days holiday (exc bank holidays), Pension, DIS and discretionary annual bonus
- Company Name
- Environment Agency
- Job Title
- Data and Information Officer - Data and Information Licensing - 30646
- Job Description
- Job Description We are looking for a Data and Information Officer to join the Data Sharing and Access team at the Environment Agency. You will: Assist project teams and business areas in licensing data to our contractors and partners. Maintain and develop our data sharing guidance, training and tools so that internal customers can seamlessly provide data and information externally. Support work to automate aspects of our approach to licensing data. This is an exciting opportunity to transform an essential part of how projects deliver environmental improvements. You will be managing risks in sharing third-party IP, personal data and commercial confidentiality. You will ensure that we are meeting our obligations under the Reuse of Public Sector Information legislation. The Environment Agency are committed to having an inclusive workforce. We don’t just talk about diversity. We seek it, embrace it and live it, for the benefit of our staff, our communities and our environment. Everyone starting in a new role will be welcomed into the team and given all the training and support needed. During your comprehensive induction, we will provide you with the equipment you need for your new role. Our team ensures we comply with our legislative duties to publish data and information. We ensure our customers can find the data and information they need to make good decisions. You will help our customers make the best environmental decisions possible. The team We are the Data and Information department of the Environment Agency. We are delighted to advertise this interesting and influential post. We provide Environmental Information online to millions of customers every year. We are an inclusive team and welcome flexible working patterns, including job sharing. We will also consider workplace adjustments during the application process, at interview and in the role. Experience/skills Required You’ll need: Experience of advising staff on internal processes Examples of identifying opportunities, improvements to processes and promoting new ways of working A proven record of working with teams and seeking advice Examples of when you have provided advice and training about complex technical and /or legal processes It would also be beneficial to have experience of: Licensing data and information Contact and additional information We are a national team and you will be able to work from any of our locations. Occasional travel, including overnight stays about once a month for meetings and away days, may be required. Everyone that joins us will undertake training and participate in our incident response. Please see the candidate pack for more information. We have accessible offices across England. We aim to interview via MS Teams during May. Please contact me if you would like to discuss. michael.waters@environment-agency.gov.uk Overview of benefits and development: Full training and support provided for new starters Funded opportunities for professional qualifications Extensive employee benefits (refer to candidate pack) Length of contract 12 months Competence 1 Focuses on Customers and Partners Description Give an example of when you have monitored and measured customer satisfaction and used that data and information to improve a service. Competence 2 Communicates Effectively Description Give an example of a time where you have conveyed complex information and ideas through a number of channels. How did you ensure your messages were clear and understood by your audience? Competence 3 Focuses on Efficiency, Innovation and Quality Description Provide an example where you have introduced or improved a process or procedure. How did the changes improve performance and/or efficiency? How did you measure improvements and ensure quality and accuracy were maintained? If you are applying from the Civil Service please note that the Environment Agency is not a part of HM Civil Service and you would not be a Crown Servant in the event of being appointed. Therefore, you will not be eligible for continuous service. For applicants who currently work in local government or other bodies listed in the Redundancy Payments (Continuity of Employment in Local Government etc) (Modification) Order 1999, you may be eligible for continuous service for the purpose of calculating any future redundancy payment. If you are unsure of your status then you should contact your own HR Team. We are fully committed to having a diverse and inclusive workforce to reflect the communities we serve. We welcome flexible working patterns for all our vacancies, including job share, so please include clearly any information regarding your preferred working arrangements on your application. We also have a Guaranteed Interview Policy to support those with a disability who are seeking employment. We have committed to guaranteeing an interview to anyone with a disability whose application meets the minimum criteria for the post. The Environment Agency, as a Non-Departmental Public Body, is committed to providing value for money and utilises Central Government frameworks and contracts for all external recruitment needs. For this reason, we are unable to engage with the market directly through post, email or phone calls . Should you wish to become a support supplier on one of these frameworks or contracts please visit https://www.gov.uk/government/publications/become-a-crown-commercial-service-supplier/becoming-a-supplier-through-the-crown-commercial-service-what-you-need-to-know for more information.