SQL Data Analyst - Hybrid/London
On site
London, United Kingdom
£ 408 / day
Freelance
27-03-2025
Job Specifications
Job Title: SQL Data Analyst - Hybrid/London
Location: London - twice a week (every Wednesday and Thursday)
Salary/Rate: Up to £408 a day Inside IR35
Start Date: April
Job Type: 12 Month Contract
Company Introduction
We are looking for a Data Analyst with strong experience working with SQL and Git for Change Control to join our client in the Telecommunication industry.
The successful candidate for this role will be able to work on site in Paddington two days a week (every Wednesday and Thursday).
The Data Analyst for this role will develop and operate big data products. You will build, maintain, optimise and automate data processes through pipelines, scripts and script control to maintain and improve data products, used to deliver insights to a wide range of clients. Working within an agile product development team, the role is jointly accountable for the quality, development and operation of the data products.
Required Skills/Experience
Experience in writing and deploying production ready code
Aptitude for problem solving
Strong understanding of databases and experience in writing analytical queries and data processes in SQL and or Python
Able to comprehend, define, and implement changes independently
Strong track record of defining and implementing data process changes independently
Self-motivated with good organisational and time management skills
Experienced in effective use of Git or similar for change control
Business awareness and aptitude for building and developing data products
Experienced in developing complex methodology, analysing data and visualising complex ideas to customers
Good standard of written and spoken English
Job Responsibilities/Objectives
Developing software or scripts required to deliver data products, including visualisation tools, databases and data processing systems
Developing new or improving existing methodologies, processes and products, and driving improvements in quality
Continuous improvement of the ability to deliver changes to products in a regular, reliable, and predictable manner through improving feedback loops throughout the product delivery process
Developing a thorough understanding of Mobile Network Data and its processing to be able to take full advantage of the data assets
Respond to technical issues in a professional and timely manner
Desirable Skills/Experience
Experienced in using CI/CD pipelines
Experienced in working with data used in transport modelling
Experienced in working in continuous delivery environment
Experience in analysing geospatial data and or GIS experience
Experience with processing large volumes of data
Tableau or similar data visualisation experience
If you are interested in this opportunity, please apply now with your updated CV in Microsoft Word/PDF format.
Disclaimer
Notwithstanding any guidelines given to level of experience sought, we will consider candidates from outside this range if they can demonstrate the necessary competencies.
Square One is acting as both an employment agency and an employment business, and is an equal opportunities recruitment business. Square One embraces diversity and will treat everyone equally. Please see our website for our full diversity statement.
About the Company
Fondée en 2018, Square One est une entreprise de service numérique (ESN), du Top 100 français, en pleine expansion proposant à une clientèle grands comptes de bénéficier de l’expertise et de la fiabilité de ses ingénieurs consultants pour l’analyse, le cadrage, le déploiement et l’exploitation de projets IT. Square One se positionne comme un « artisan » dédié à la transformation numérique de clients pour des activités de DevOps, de structuration cloud computing et de cybersécurité. Know more
Related Jobs
- Company Name
- Lorien
- Job Title
- Data Solutions Architect - Data Governance Exp
- Job Description
- Data Solutions Architect - Data Governance Exp Inside IR35 2 days per week on-site in London £590 per day Job Overview Currently 1 year into programme to transform and manage curriculum. They have implemented data framework and need to bring in data foundation/ building blocks. Job Requirements Capable of handling ambiguous requirements, identifying NFRs, and creating designs that meet objectives Able to understand the business drivers for change, critical deficiencies, and opportunities for improvement Leading design activities across complex business functions with multiple stakeholders Discovering and analysing requirements, understanding the context, identifying, and assessing alternative solutions and advising on configuration Define the principles, guidelines, standards, and solution patterns to ensure solution decisions are aligned with the enterprise's future-state architecture vision. Direct the governance activities associated with ensuring solutions architecture assurance and compliance. Technical Experience in data governance and data quality tools in an enterprise (Collibra, Informatica, etc) Awareness of Azure and AWS cloud data toolsets. Experienced in providing cloud data patterns for Azure and AWS. Strong knowledge of data governance and data quality frameworks and tools Skilled in solution in relation to data cataloguing, metadata management, and data lineage tracking. Interpersonal Excellent communication and interpersonal skills. Strong analytical and problem-solving abilities. Ability to work collaboratively in a team environment. Leadership skills with the ability to influence and drive initiatives.
- Company Name
- Pan Macmillan
- Job Title
- Data Engineer
- Job Description
- Data Engineer / Analyst – 12 Month Fixed Term Contract Pan Macmillan is looking for an experienced Data Engineer with the technical, analytical, and project skills to accelerate delivery of three key projects in data migration and expansion. This role is ideal for someone with a keen eye for detail who enjoys delivering innovative and appropriate data solutions. Your team: You’ll be joining a small but dynamic team, reporting to the Head of Analytics and working on projects alongside a Database Engineer and two Data Analysts. You’ll also collaborate with colleagues in the US and technology support teams. The team provides accurate and timely data to drive decision-making across the business, managing a suite of Tableau reports and the underpinning Snowflake database. We are a project team working closely with stakeholders in the commercial, creative, business, and process areas to meet the evolving needs of the company and the publishing industry. Your role: You will be working on three key projects: Completing migration from Microsoft SQL Server to Snowflake, using Matillion as the primary transformation tool. Migrating Tableau dashboards to point at our newly structured data warehouse, including requirement gathering, data scoping, and building views and data marts Expansion of commercial data sources, including scoping business requirements, pipeline development, and API integration. You can expect project delivery to involve improving automation and data-flow reliability, leveraging APIs for data enrichment and integration, exploring AI-assisted solutions for data cleansing and categorisation, and creating Tableau dashboards to monitor data content and quality. Adaptability and proactive problem-solving are essential in this fast-evolving environment, as is being a team player and a willingness to help deliver business as usual. Your key responsibilities: Data warehouse migration & infrastructure Collaborate with the Data Engineer to deliver the migration of the enterprise data warehouse from SQL Server to Snowflake. Contribute to data mapping, modelling, shaping, and architecture design to support efficient and scalable data structures. Handle data transfers and manage regular maintenance and updates of data pipelines. Build and maintain ETL/ELT transformations using relevant tools. Verify data, transformations, and packages to ensure completeness and accuracy. Performance, quality & monitoring Carry out query, data, and connection optimisation to improve pipeline performance. Design and implement data quality assurance and monitoring processes. Conduct troubleshooting and proactively resolve data-related issues, ensuring minimal disruption to data flows. Integration & automation Discover and integrate new data sources in line with business priorities. Review and improve existing data-handling processes for automation, efficiency, and better leveraging of APIs. Develop data-cleansing and categorisation solutions, including exploration of AI-assisted approaches. Dashboards & migration Review Tableau dashboards to define data requirements for migration to the restructured warehouse. Maintain, improve, and contribute to our suite of Tableau dashboards and automated solutions. Develop complex SQL queries, views, and marts to support Tableau dashboards and other outputs. General responsibilities Participate in requirement gathering and specification activities for analytics projects. Manage your workload using Asana to ensure timely delivery of tasks as part of a collaborative project team. Support the Analytics team in delivering business-as-usual reporting and data support. Share knowledge and provide support to team members, upskilling where relevant to meet new requirements. Documentation of updates, decisions, and data solutions to support team knowledge and continuity. Essential experience, abilities, and knowledge you’ll need to succeed: Proven experience with SQL, including working knowledge of pipeline management, data architecture, and performance optimisation. Working knowledge of cloud-based data warehousing and the following technologies: Python, AWS, APIs, DBT, with the ability to quickly upskill in Matillion. Working knowledge of data visualisation / BI tools, with experience in creating or editing dashboards and reports. Experience with handling commercial data and understanding the data use-cases of commercial teams. Clear record of problem-solving capabilities, with strong analytical skills for data-driven decision-making. Technical scoping expertise, especially: Reviewing existing dashboards to recommend improvements to data sources and flows. Assessing new data sources to deliver pipeline and data-handling recommendations. Data cleansing, validation, and transformation skills. Creating and maintaining clear and relevant technical documentation. Ability to manage time effectively and meet deadlines under pressure. Excellent attention to detail, with a focus on accuracy, relevancy, and quality. Collaborative team player with a willingness to contribute ideas. Ability to think both practically and strategically about data sources and applications, demonstrating initiative, creativity, and flexibility. A minimum of three years of experience in a data-oriented role such as a Data Engineer, Database Administrator, ETL Developer, or a related field. Undergraduate degree in a mathematically based subject (e.g., Information Systems, Economics, Psychology, Computer Sciences), or equivalent work experience. Project experience, including working as part of a team and meeting deadlines, and some experience of leading project tasks or workstreams. Desirable skills we’d love you to have: An interest in, or experience with, publishing, reading, or the contemporary book market. Experience with database migration and/or consultancy. Experience with the following technologies would be advantageous: Tableau Desktop, Snowflake, Microsoft SQL Server, Matillion, Git or GitHub. Practical experience working with social media data. Strong communication skills, including stakeholder engagement and the ability to present and interpret data for non-data audiences. Experience working in Agile or sprint-based delivery environments, particularly in data or analytics projects. Proficiency with the Microsoft suite, especially Excel (including formulas, functions, pivots, and macros/VBA). What you’ll get in return: In return we can offer you a range of great projects, a supportive and collaborative working environment as well as a competitive salary and benefits package. Closing date: 21 April 2025 Salary start from: £42,000 Some of the benefits we offer: 28 days’ annual leave increasing with years of service + bank holidays Generous pension scheme Discounted private medical insurance Group income protection scheme Enhanced family pay and leave Flexible working hours and summer hours (early finish on a Friday during summer months) 2 Volunteer Days per year 75% off all Pa...
- Company Name
- OptumUK
- Job Title
- Data Migration Consultant
- Job Description
- The Vacancy Are you an experienced Data Migration Engineer looking to join a team where your work genuinely makes a difference? This is an exciting opportunity to contribute to a major project migrating a legacy data centre to the AWS cloud platform by the end of 2025. The project involves moving 93 individual services, including critical data from some of our key products, from an on-premise Microsoft SQL Server environment to AWS. The migration will involve a mix of lift-and-shift alongside re-engineering where required. We’re seeking a Data Migration Engineer with strong SQL skills and a solid background in cloud-based data migrations to join our dynamic, innovative team on a day-rate contract. We are a collaborative and driven team who are passionate about the work we do—and we like to enjoy the journey. If that sounds like your kind of environment, we’d love to hear from you. What You’ll Do At Optum UK, we believe in using the power of technology to make healthcare faster, better, and more accessible for everyone. You’ll play a key role in helping us deliver on that mission. Your key responsibilities will include: Planning, designing, and executing data migration strategies and activities Ensuring the accuracy, integrity, and security of data throughout the migration process Troubleshooting and resolving any technical challenges that arise during migration Communicating progress, issues, and solutions clearly and effectively to stakeholders Enabling a seamless transition from legacy systems to modern cloud-based environments Who You’ll Be You’ll be an experienced Data Migration Engineer, confident in migrating databases to the cloud, and comfortable working as part of a team. We value curious thinkers who seek out opportunities for improvement and efficiency. Your approach and mindset will be just as important as your technical expertise. Essential skills and experience: Proficiency in SQL and Microsoft SQL Server migration and configuration Expertise in Microsoft SQL Server administration and clustering Experience working within AWS cloud architecture Working knowledge of Infrastructure as Code (IaC), particularly using Terraform Ability to work with limited documentation and effectively conduct system discovery Experience delivering database migrations with minimal or no downtime If this sounds like you, apply now to discover why Optum UK is a great place to work.
- Company Name
- trg.recruitment
- Job Title
- Freelance Data Engineer
- Job Description
- Location: Remote-first (UK-based) Rate: Up to £550 p/d Contract: 6 - 12 months (Outside IR35) Tech Stack: BigQuery, SQL, GCP (Dataflow, Cloud Storage, Pub/Sub), ETL/ELT, Python We’re working with a fast-moving team that’s building high-performance data infrastructure on Google Cloud Platform. They’re looking for a Senior Data Engineer to help design, implement, and optimise scalable pipelines while supporting both data and product teams with reliable, secure, and efficient systems. If you enjoy working with large-scale datasets and solving performance challenges in cloud environments, this is a great opportunity to lead with impact and collaborate across teams. What You’ll Be Doing: Designing and implementing scalable data pipelines using BigQuery and other GCP tools Developing and maintaining ETL/ELT workflows for transforming and aggregating data Optimising database performance for cost-effective, efficient querying Collaborating with analysts, scientists, and engineers on analytics and product use cases Automating workflows and monitoring pipeline performance Mentoring junior engineers and fostering a strong engineering culture What You Need: Strong SQL skills and experience with large-scale datasets Hands-on experience with BigQuery and GCP tools like Dataflow, Cloud Storage, and Pub/Sub Deep knowledge of query optimisation and performance tuning Proven experience with ETL/ELT design and data modelling best practices A collaborative mindset and solid communication skills Ability to mentor and guide junior team members This is an outside IR35 contract, so you must be UK-based. Interested? Click Apply or get in touch with Ionut Roghina for more details!