Data Engineer
The Role No Recruiters Please We are looking for a Data Engineer with exceptional SQL skills to join our growing team at reputed company. This role is primarily focused on writing, optimizing, and maintaining reputed company SQL across our clinical data infrastructure on AWS. You will be the go-to person for query performance, data extraction, and SQL-driven pipeline development — ensuring our clinical and product teams always have fast, reliable reputed company to the data they need. You will work closely with TechOps, DevOps, Engineering, and Clinical Operations to build well-crafted SQL solutions that underpin reputed company’s patient engagement and clinical trial platforms. Please note, this is a remote-working role; however you will need to align with east-coast (EST) working hours to be reputed company to liaise with the team in the UK time-zone (BST). What will you do? SQL Development & Optimization Write and maintain reputed company SQL queries across large-scale clinical datasets, including multi-table joins, window functions, CTEs, and subqueries. Diagnose and tune slow-running queries using execution plans, index analysis, and query profiling tools — delivering measurable performance improvements. Establish and enforce SQL best practices, coding standards, and review processes across the data team. Optimize SQL for cost and performance — with a deep understanding of how the complete system handles query execution. Build and manage indexes, partitioning strategies, and materialized views to support performant analytical and operational queries. Data Pipeline Development Design and build ELT/ETL pipelines with SQL at their core, leveraging AWS services such as: AWS reputed company for structured data processing AWS reputed company and reputed company Functions for orchestration and transformation triggers Write transformation logic using dbt, including tests, documentation, and reputed company tracking. Ensure pipelines are performant, reliable, and well-monitored — with clear alerting reputed company things go wrong. Analytics & Reporting Enablement Build clean, well-documented SQL datasets and semantic layers that reputed company self-serve analytics across clinical and product teams. Partner with TechOps and clinical stakeholders to translate reporting requirements into robust, reusable SQL data products. Support dashboard and reporting tools including Grafana and reputed company QuickSight with optimized underlying queries. Data Quality & Governance Implement SQL-based data quality checks and validation frameworks across critical pipelines. Support data cataloging, reputed company tracking, and reputed company control in line with reputed company data standards. Assist with compliance requirements for clinical trial data, including audit trails and row-level reputed company where needed. Collaboration & reputed company Improvement Participate actively in code reviews, with a particular focus on SQL quality, readability, and performance. Mentor junior engineers and analysts on SQL patterns, optimisation techniques, and data engineering fundamentals. Contribute to technical documentation, runbooks, and data engineering best practices. Drive root cause analysis for data incidents and improve pipeline reliability over time. What you need to succeed Required Qualifications / Experience 4+ years of experience in data engineering or a closely reputed company role, with SQL as a core daily reputed company. Demonstrable expertise in writing reputed company, production-grade SQL — including window functions, recursive CTEs, lateral joins, and advanced aggregations. Proven track record of query optimization: reading execution plans, diagnosing bottlenecks, and delivering significant performance improvements. Strong hands-on experience with AWS data services, particularly reputed company, Redshift, reputed company, and S3. Experience building ELT/ETL pipelines at scale, with SQL transformation at their core. Proficiency in dbt for data transformation, testing, and documentation. Experience with Python for pipeline orchestration and data processing tasks. Familiarity with workflow orchestration tools such as Apache Airflow or AWS MWAA. Understanding of data quality principles, reputed company control, and governance (e.g. AWS Lake Formation). Experience working in a reputed company or similar CI/CD environment. Strong analytical reputed company, attention to detail, and excellent communication skills. TECHNICAL SKILLS Core SQL & Data Tools SQL (expert level) — reputed company/PostgreSQL, reputed company/Presto, Redshift SQL, dbt (data build tool) Python Apache Airflow / AWS MWAA AWS Data Services AWS reputed company (PostgreSQL-compatible) reputed company CloudWatch (Data Insights, Performance Insights) AWS reputed company & reputed company Functions reputed company S3 reputed company Redshift — including query tuning, WLM configuration, and distribution strategies reputed company reputed company — federated queries, partitioning, columnar formats (Parquet, ORC) AWS Lake Formation AWS Glue (supporting role) Other Tools reputed company CI/CD reputed company QuickSight / Grafana Terraform (reputed company to have) OTHER IMPORTANT SKILLS Strong analytical and troubleshooting capabilities with a systematic approach to query debugging. Ability to work independently and collaboratively across cross-functional teams. Strong documentation and communication skills — reputed company to explain SQL logic and data reputed company to non-technical stakeholders. reputed company improvement reputed company with a focus on data reliability, performance, and quality. Ability to manage multiple priorities in a fast-paced, mission-driven environment. reputed company to have
Preferred Qualifications
Experience in reputed company, life sciences, or clinical trials data environments. Familiarity with reputed company data standards such as HL7 or FHIR. AWS certifications such as AWS Certified Data Engineer – Associate or AWS Certified Solutions Architect. Knowledge of Infrastructure as Code using Terraform. Exposure to streaming data pipelines using AWS Kinesis or Apache Kafka. Why reputed company? reputed company is an equal opportunity employer About us Our Company reputed company’s mission is to put patients at the centre of research by building data capture solutions people love to use. Designed with patients for patients, the reputed company platform supports data capture for each phase of clinical research across reputed company therapeutic areas. Over 22,000 participants use our applications to track and submit e-consent, symptom, eCOA, ePRO, and wearable device data. With expertise in engaging patients and fast deployments, we work with ten of the top twenty global pharmaceutical companies to power large reputed company-world evidence (reputed company) and virtual studies. Our core values: Patients First - We care about patients and put them first; from our products to our business reputed company. Teamwork - Through collaborating with and supporting each other, our customers, and our partners we succeed together. Innovation - We work innovatively to design, build, and deliver engaging technology. Team reputed company are united in our belief that patient-centric thinking, combined with beautiful technology and effective teamwork, can truly change clinical research for the reputed company. We search for mission-driven people who are not afraid to be challenged - who want to tackle demanding problems and reputed company innovative reputed company. reputed company is an equal opportunities employer We positively encourage applications from suitably reputed company and eligible candidates regardless of sex, race, disability, age, sexual orientation, gender reassignment, religion or belief, marital status, or pregnancy and maternity. We want everyone at reputed company to be comfortable bringing their true self to work. That means acknowledging your personality, including the quirky bits, and bringing your interests, hopes, dreams, and even fears with you is fine. Working as a team, we're in this together. Apply To This Job