1 to 25 of 33 SQL Optimisation Jobs in London

the team. Apply and champion Azure Medallion architecture principles in future-state design. Data Ingestion & Integration Design and implement ingestion pipelines into Azure (Data Lake, Synapse, Blob Storage, Azure SQL). Ingest structured, semi-structured, and unstructured data from APIs, FTP/SFTP, cloud platforms, and file-based sources. Manage data integrations with suppliers, including file transfers and API … scalable transformation logic to enable analytics and reporting needs. Apply data validation, cleansing, and lineage tracking throughout the pipeline lifecycle. Support both existing and future ETL workloads with strong SQL and scripting capabilities. Data Platform & Server Management Revamp and support existing database designs to enable a scalable migration to Azure. Introduce and enforce standards and governance around data structures … and code. Optimize T-SQL code and SQL Server performance before deploying into production. Manage consistent data platforms across regions with a focus on reusability and modularity. Monitor and control database file growth, indexing strategies, and performance tuning. Develop scalable solutions based on both current and emerging business requirements. Data Cloud Operations & Resilience Lead initiatives in data cloud More ❯

or Jenkins. Proficiency with distributed frameworks like Apache Spark. Experience with cloud platforms (AWS, Azure, GCP) and services (S3, Redshift, BigQuery). Knowledge of data modelling, database systems, and SQL optimisation. Other key criteria Knowledge of UK broadcast industry & broadcast/OTT advertising market. Understanding of digital marketing and advertising industry. Familiarity with data design for classification, regression, A More ❯

risk management solutions for prestigious asset management firms. Public Sector: We're trusted by multiple UK government departments and public sector organisations to deliver predictive maintenance systems, supply chain optimisation, and process automation. SaaS, Manufacturing & More : From innovative SaaS providers to global manufacturing leaders, our cross-industry expertise ensures we bring diverse perspectives to complex challenges. We're seeking … Love QuantSpark Work That Matters: Lead high-impact analytics projects across diverse sectors-from building predictive models that help private equity firms identify value creation opportunities to creating inventory optimisation algorithms for household-name retailers.Tackle Exciting Challenges: Design and implement technically sophisticated solutions such as real-time analytics platforms for FTSE 100 companies, automated risk assessment systems for asset … monitoring, and documentation standards that ensure our solutions are production-ready and maintainable. Mentor Rising Talent: Guide junior analytics engineers and data scientists, sharing your expertise in pipeline design, SQL optimisation, and Python development. You'll help build the next generation of analytics engineering talent at QuantSpark. Shape Client Solutions: Work directly with clients to understand their business More ❯

build the data infrastructure and maintain a highly scalable, reliable and efficient data system to support the fast growing business. You will work with analytic tools, can write excellent SQL scripts, optimize performance of SQL queries and can partner with internal customers to answer key business questions. We look for candidates who are self-motivated, flexible, hardworking and … data warehousing, querying and reporting system. - 2+ years of data engineering experience - Experience with data modeling, warehousing and building ETL pipelines - Experience with one or more query language (e.g., SQL, PL/SQL, DDL, MDX, HiveQL, SparkSQL, Scala) - Experience with one or more scripting language (e.g., Python, KornShell) - Knowledge of AWS Infrastructure - Knowledge of writing and optimizing SQL More ❯

build the data infrastructure and maintain a highly scalable, reliable and efficient data system to support the fast growing business. You will work with analytic tools, can write excellent SQL scripts, optimize performance of SQL queries and can partner with internal customers to answer key business questions. We look for candidates who are self-motivated, flexible, hardworking and … querying and reporting system. BASIC QUALIFICATIONS - 2+ years of data engineering experience - Experience with data modeling, warehousing and building ETL pipelines - Experience with one or more query language (e.g., SQL, PL/SQL, DDL, MDX, HiveQL, SparkSQL, Scala) - Experience with one or more scripting language (e.g., Python, KornShell) - Knowledge of AWS Infrastructure - Knowledge of writing and optimizing SQL More ❯

of designing and building scalable microservice architectures. Deep understanding of event-driven systems and message queues (e.g. NATS, RabbitMQ, Kafka). Strong understanding of relational database design principles and SQL optimisation techniques. Experience designing and implementing RESTful APIs. Experience with relational databases (e.g., PostgreSQL). Solid understanding of data structures, algorithms, and software design patterns. Experience with CI More ❯

decision makers. Key job responsibilities In this role, you will: Understand a broad range of Amazon's data resources and processes. Manipulate/mine data from database tables using SQL, and from log files by writing scripts (e.g. PERL, Python). Interface with Global Stakeholders, Data Engineers, and Business Analysts across time zones to gather requirements by asking right … help you develop into a better-rounded professional. BASIC QUALIFICATIONS - Bachelor degree in mathematics, statistics, computer science, engineering. 8+ yrs of experience in Analytics/BI, writing and optimizing SQL/Python with large-scale, complex datasets. - 3+ years' experience using business intelligence tools like QuickSight, Tableau, PowerBI. - Strong financial acumen and analytics skills with a high degree of More ❯

organisation for deep data analysis and reporting to provide Deutsche Bank sales managers a clear view on clients' activity and profitability. We are seeking an experienced Oracle PL/SQL Developer with a strong background in database development to join our cross-functional application development team. The ideal candidate should have significant hands-on experience in designing, developing, tuning … and maintaining PL/SQL that underpins important analytical applications. This is an excellent opportunity to contribute to the development of strategic database systems and work in a collaborative and dynamic environment. What Well Offer You A healthy, engaged and well-supported workforce are better equipped to do their best work and, more importantly, enjoy their lives inside and … scheme and Gym benefits The opportunity to support a wide ranging CSR programme + 2 days volunteering leave per year Your Key Responsibilities Design, develop, and maintain PL/SQL code for database procedures, packages, functions and triggers. Work as part of a cross-functional team to gather and analyze business requirements, translate them into technical specifications through to More ❯

Experience with DevOps tools and practices, version control (Git) , and CI/CD pipelines . Comfortable with Agile methodologies and collaborative team-based development. Proficient in writing and optimizing SQL queries and working with relational databases . Familiar with Linux/Unix systems , shell scripting, and command-line utilities. A careful, methodical coder with good documentation habits and testing More ❯

Proficiency in production-grade coding, automated testing, and CI/CD deployment (e.g., Github Actions, Jenkins). Experience with distributed frameworks like Apache Spark, data modeling, database systems, and SQL optimization. Experience with cloud platforms (AWS, Azure, GCP) and services like S3, Redshift, BigQuery. Additional desirable qualities: Knowledge of UK broadcast industry & digital marketing. Familiarity with data design for More ❯

track record of delivering scalable and secure applications. Experience working with cloud-based environments, particularly AWS. Familiarity with performance optimization and debugging tools. Knowledge of database design principles and SQL optimization. Engineering Mindset Ability to understand and consider the broader business context and long-term implications of technical decisions. Willingness to take ownership, innovate, and proactively seek opportunities to More ❯

and maintain ongoing enhancements. Design and maintain reports for various back-office functions. Provide support for macro-enabled Office documents actively used across the business. Perform basic on-premises SQL Server administration tasks. Lead the transition of integration points from a traditional data stack to a modern, cloud-based architecture. Essential skills: Solid background in software development with a … well under pressure and manage multiple tight deadlines Self-motivated with a proactive, solution-focused mindset Technical Proficiencies: C# with ASP.NET (Web Forms), Web Services, and Windows Services Microsoft SQL Serverdatabase development, data modelling, and multi-database querying Report generation tools such as SSRS, Crystal Reports, or similar Experienced with Azure DevOps Solid understanding of system integration principles and … practices Desirable skills: Proficient in Microsoft SQL Server database administration and performance tuning Skilled in optimising SQL queries and ensuring database efficiency Familiarity with financial terminology and standard finance practices Hands-on experience with SQL Server Integration Services (SSIS) Knowledge of Azure Service Bus for cloud-based messaging and integration Industry experience in construction, architecture, or engineering More ❯

new changes/enhancements BASIC QUALIFICATIONS - 1+ years of data engineering experience - Experience with data modeling, warehousing and building ETL pipelines - Experience with one or more query language (e.g., SQL, PL/SQL, DDL, MDX, HiveQL, SparkSQL, Scala) - Experience with one or more scripting language (e.g., Python, KornShell) PREFERRED QUALIFICATIONS - Experience with AWS technologies like Redshift, S3, AWS … Glue, EMR, Kinesis, FireHose, Lambda, and IAM roles and permissions - Experience writing and optimizing SQL queries with large-scale, complex datasets - Experience with any ETL tool like, Informatica, ODI, SSIS, BODI, Datastage, etc. Our inclusive culture empowers Amazonians to deliver the best results for our customers. If you have a disability and need a workplace accommodation or adjustment during More ❯

and agents. Curate, structure, and maintain databases and datasets optimised for AI consumption. Design and maintain scalable ETL/ELT pipelines to transform and prepare data. Maintain and optimise SQL-based transformations and data models to ensure accuracy and performance. Solutions Lifecycle Troubleshoot and resolve data-related issues, improving data flow efficiency and performance. Evaluate and recommend improvements in … Skills Experience in a role focused on data structuring, transformation, and visualisation. Python skills, particularly for scripting, data manipulation, and integrating with AI tools and APIs. Experience in optimising SQL queries and managing complex datasets. Comfortable using version control tools such as Git to collaborate and maintain clean code practices. Nice to have An understanding of data warehouse concepts More ❯

and agents. Curate, structure, and maintain databases and datasets optimised for AI consumption. Design and maintain scalable ETL/ELT pipelines to transform and prepare data. Maintain and optimise SQL-based transformations and data models to ensure accuracy and performance. Solutions Lifecycle Troubleshoot and resolve data-related issues, improving data flow efficiency and performance. Evaluate and recommend improvements in … Skills Experience in a role focused on data structuring, transformation, and visualisation. Python skills, particularly for scripting, data manipulation, and integrating with AI tools and APIs. Experience in optimising SQL queries and managing complex datasets. Comfortable using version control tools such as Git to collaborate and maintain clean code practices. Nice to have An understanding of data warehouse concepts More ❯

and enhance data-driven strategies. What you'll be involved in: Collaborating closely with traders, analysts, and stakeholders to gather requirements and develop tailored visualization solutions. Writing and optimizing SQL queries to effectively extract, analyze, and present data. Developing and continuously improving visualization best practices and documentation. What we need from you: Proven experience creating impactful data visualizations and … dashboards. Strong proficiency in SQL with experience querying complex databases. Programming experience in Python. Solid understanding of database structures, data modeling concepts, and performance optimization. Excellent analytical, problem-solving, and communication skills. Familiarity with DBT (Data Build Tool) or similar frameworks is advantageous. Experience in financial services or trading environments is beneficial but not mandatory. About Mako Mako is More ❯

to investigate forecast model performance deviations, while meeting with business stakeholders to understand their metrics requirements. The afternoon could be spent building QuickSight visualizations for evaluation dashboards and optimizing SQL queries for newly defined business metrics. Throughout the day, you'll partner with data engineers on implementing quality checks, write Python scripts to automate metric processing, and participate in … and pride ourselves on fostering a collaborative environment where innovation and work-life harmony thrive. BASIC QUALIFICATIONS - Experience with data visualization using Tableau, Quicksight, or similar tools - Experience with SQL - Experience with scripting language (e.g., Python, Java, or R) - Experience in the data/BI space - Experience in analyzing and interpreting data with Redshift, Oracle, NoSQL etc. - Experience with More ❯

proven experience as a backend engineer with a focus on Power BI solutions. Strong knowledge of Power BI architecture, data modeling, DAX, and AML. Proficient in designing and optimizing SQL queries, stored procedures, and data warehouses. Hands-on experience with ETL tools and data integration processes. Familiarity with data governance, security, and compliance standards. Strong problem-solving skills and More ❯

Kafka), including configuring and optimizing message flows. Expertise in event-driven microservices development. A proven track record in building and optimizing high-throughput, distributed systems. Extensive experience with PostgreSQL, SQL optimization, and architecting high-throughput transactional databases. Hands-on experience deploying and managing services on AWS, with a solid understanding of container orchestration tools like Kubernetes and Docker. Strong More ❯

track record of delivering scalable and secure applications. Experience working with cloud-based environments, particularly AWS. Familiarity with performance optimization and debugging tools. Knowledge of database design principles and SQL optimization. Ability to understand and consider the broader business context and long-term implications of technical decisions. Willingness to take ownership, innovate, and proactively seek opportunities to drive impact More ❯

track record of delivering scalable and secure applications. Experience working with cloud-based environments, particularly AWS. Familiarity with performance optimization and debugging tools. Knowledge of database design principles and SQL optimization. Ability to understand and consider the broader business context and long-term implications of technical decisions. Willingness to take ownership, innovate, and proactively seek opportunities to drive impact More ❯

track record of delivering scalable and secure applications. Experience working with cloud-based environments, particularly AWS. Familiarity with performance optimization and debugging tools. Knowledge of database design principles and SQL optimization. Ability to understand and consider the broader business context and long-term implications of technical decisions. Willingness to take ownership, innovate, and proactively seek opportunities to drive impact More ❯

Single Customer View. Additionally, collaboration with the Analytics and Insights teams is essential to ensure they have seamless access to the necessary data, as well as assisting in optimizing SQL reporting processes. The ideal candidate will: Possess a strong curiosity and passion for exploring, transforming, and integrating data from diverse sources. Be adept at troubleshooting and fine-tuning data … stability. Thrive in team settings, with excellent communication skills and the confidence to engage with various stakeholders. Key Responsibilities: Support the development of the data warehouse and enhance the SQL reporting framework. Design, implement, and manage data pipelines to gather, process, and store information from multiple data sources, automating the transition from UAT to Production. Maintain and evolve the … Single Customer View to consolidate data from various sources. Demonstrate hands-on experience with Microsoft Azure technologies (including Synapse Analytics, Datalake, Azure SQL), as well as familiarity with DevOps and GitHub practices. Contract Details: Initially a Fixed Term Contract, likely transitioning to Permanent. 1-2 days a week on-site. 30 days holiday. A fantastic company culture. Please apply More ❯

Single Customer View. Additionally, collaboration with the Analytics and Insights teams is essential to ensure they have seamless access to the necessary data, as well as assisting in optimizing SQL reporting processes. The ideal candidate will: Possess a strong curiosity and passion for exploring, transforming, and integrating data from diverse sources. Be adept at troubleshooting and fine-tuning data … stability. Thrive in team settings, with excellent communication skills and the confidence to engage with various stakeholders. Key Responsibilities: Support the development of the data warehouse and enhance the SQL reporting framework. Design, implement, and manage data pipelines to gather, process, and store information from multiple data sources, automating the transition from UAT to Production. Maintain and evolve the … Single Customer View to consolidate data from various sources. Demonstrate hands-on experience with Microsoft Azure technologies (including Synapse Analytics, Datalake, Azure SQL), as well as familiarity with DevOps and GitHub practices. This role could accommodate 1 visit a month/fully remote for the right individual and is a 12-month Fixed Term Contract with a high likelihood More ❯

you will be responsible for creating impactful dashboards and visual reports, responding to business data requests, and providing actionable insights to various stakeholders. You will leverage your experience with SQL and BigQuery to build efficient data models and enhance the company's data-driven decision-making processes. Specific duties will include: Developing and maintaining Power BI dashboards and reports … to present key business data Writing and optimising SQL queries to manipulate and analyse large datasets Using BigQuery to manage and query cloud-based data Collaborating with stakeholders to capture business requirements and translate them into technical specifications Troubleshooting and resolving issues related to dashboards and data accuracy Ensuring that dashboards and reports are user-friendly and aligned with … business goals YOUR SKILLS AND EXPERIENCE: The ideal Power BI Developer will have: Strong commercial experience in building dashboards and reports using Power BI Advanced SQL skills, including complex query writing and data manipulation Experience working with BigQuery or similar cloud-based data platforms A proven track record of delivering high-quality work within deadlines Strong communication skills with More ❯