Data Analyst

Synectics Solutions; Stoke-on-Trent; On-site; GBP 40,000 - 60,000; Full time

Job summary

A leading technology firm in the UK seeks a professional to enhance their data strategy. The role involves supporting their data lake project and developing prototypes. Ideal candidates should have advanced SQL skills, familiarity with cloud technologies, and experience in collaborative tools. Join a dynamic team and work with cutting-edge technologies to shape data-driven solutions.

Qualifications

• Proven experience with advanced SQL for data manipulation.
• Foundational knowledge of ETL processes and data pipelines.
• Exposure to cloud and data lake technologies is a plus.

Responsibilities

• Develop functional prototypes using SQL and data tools.
• Support data lake ingestion, modeling, and transformation.
• Provide analysis to enhance business initiatives.
• Work on proof-of-concept solutions with Power BI.
• Ensure compliance with data governance standards.

Skills

Advanced SQL

ETL tools knowledge

Cloud technologies (AWS/Azure)

Power BI proficiency

Python or similar languages

Collaboration tools (JIRA)

Tools

Databricks

Data lake architectures

Job description

This is a dynamic and evolving role at the heart of our data strategy. You will contribute to our proof‑of‑concept process, support our data lake project, conduct advanced analytics, and prototype development to support client‑facing demonstrations and internal insight generation. The position offers opportunities to work with and learn modern data lake and analytics technologies, whilst collaborating across teams in a fast‑growing environment that values innovation and personal development.

Responsibilities

• Prototype Development: carry business requirements through investigation, development, and testing cycles, creating functional prototypes using SQL and modern data tools.
• Data Lake Enablement: support ingestion, modelling, and transformation of structured and unstructured data into the data lake for scalable reporting and analytics.
• Insight Delivery: provide high‑quality analysis to internal stakeholders (Sales, Solutions Consultancy, Client Success, Product Management) to enhance BAU and strategic initiatives.
• POC Acceleration: work on proof‑of‑concept solutions integrated with Power BI and the data lake to improve conversion rates and client engagement.
• Governance & Compliance: ensure data handling aligns with security, privacy, and regulatory standards, particularly for sensitive and PII data.

Qualifications

• SQL Expertise: advanced SQL for data manipulation and query optimisation.
• Data Engineering Foundations: understanding and experience of ETL tools and familiarity with modern data pipelines.
• Cloud & Data Lake Technologies: exposure to Databricks, AWS/Azure, and data lake architectures desirable.
• Data Visualisation: proficiency in Power BI or other comparable reporting software for creating dashboards and reports.
• Programming & Automation: knowledge of Python or similar languages for data wrangling and automation.
• Collaboration Tools: experience with JIRA and Agile workflows.

Desirable Skills

• Understanding of Unity Catalog, Delta Lake, or similar governance frameworks.
• Familiarity with MLOps concepts and model lifecycle management.
• Knowledge of Finance and Insurance sectors (beneficial but not essential).

Personal Attributes

• Analytical mindset with attention to detail.
• Strong communication skills for technical and non-technical audiences.
• Ability to work independently and drive initiatives to completion.
• Flexible and adaptable to evolving business priorities.

Synectics Solutions are a leading force in delivering innovative, data‑driven business solutions. For over 30 years, we've specialised in building complex data management and software products for household brands across the public and private sectors. Our next chapter focuses on leveraging cloud‑native data platforms and advanced analytics, underpinned by our data lake initiative, to deliver scalable insights and AI‑driven solutions. You'll be part of a team shaping Synectics' future through data lake‑driven innovation, enabling next‑gen analytics, AI capabilities, and new revenue streams. This role offers exposure to cutting‑edge technologies and the chance to influence strategic data initiatives.