uMotif

Role Description We are looking for a Data Engineer with exceptional SQL skills to join our growing team at uMotif. This role is primarily focused on writing, optimizing, and maintaining complex 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 access to the data they need. You will work closely with TechOps, DevOps, Engineering, and Clinical Operations to build well-crafted SQL solutions that underpin uMotif’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 able to liaise with the team in the UK time-zone (BST). What will you do? - SQL Development & Optimization - Write and maintain complex 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 Aurora for structured data processing - AWS Lambda and Step Functions for orchestration and transformation triggers - Write transformation logic using dbt, including tests, documentation, and lineage tracking. - Ensure pipelines are performant, reliable, and well-monitored — with clear alerting when things go wrong. - Analytics & Reporting Enablement - Build clean, well-documented SQL datasets and semantic layers that empower 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 Amazon QuickSight with optimized underlying queries. - Data Quality & Governance - Implement SQL-based data quality checks and validation frameworks across critical pipelines. - Support data cataloging, lineage tracking, and access control in line with healthcare data standards. - Assist with compliance requirements for clinical trial data, including audit trails and row-level security where needed. - Collaboration & Continuous 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. Qualifications - 4+ years of experience in data engineering or a closely related role, with SQL as a core daily skill. - Demonstrable expertise in writing complex, 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 Aurora, Redshift, Athena, 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, access control, and governance (e.g. AWS Lake Formation). - Experience working in a GitLab or similar CI/CD environment. - Strong analytical mindset, attention to detail, and excellent communication skills. Technical Skills - Core SQL & Data Tools - SQL (expert level) — Aurora/PostgreSQL, Athena/Presto, Redshift SQL - dbt (data build tool) - Python - Apache Airflow / AWS MWAA - AWS Data Services - AWS Aurora (PostgreSQL-compatible) - Amazon CloudWatch (Data Insights, Performance Insights) - AWS Lambda & Step Functions - Amazon S3 - Amazon Redshift — including query tuning, WLM configuration, and distribution strategies - Amazon Athena — federated queries, partitioning, columnar formats (Parquet, ORC) - AWS Lake Formation - AWS Glue (supporting role) - Other Tools - GitLab CI/CD - Amazon QuickSight / Grafana - Terraform (nice 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 — able to explain SQL logic and data decisions to non-technical stakeholders. - Continuous improvement mindset with a focus on data reliability, performance, and quality. - Ability to manage multiple priorities in a fast-paced, mission-driven environment. Nice to have - Experience in healthcare, life sciences, or clinical trials data environments. - Familiarity with healthcare 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.

• Design, deploy, and maintain scalable cloud infrastructure in AWS using services such as: · EC2 · S3 · RDS · Lambda · DynamoDB · Step Functions • Automate infrastructure provisioning and configuration management using Terraform. • Develop, maintain, and optimize CI/CD pipelines using GitLab. • Deploy, manage, and optimize Kubernetes clusters used for GitLab Runner deployments. • Implement and maintain monitoring, alerting, and logging solutions using tools such as: · AWS CloudWatch · Grafana • Work with AWS AI services such as Amazon Bedrock to help deploy and support AI-enabled solutions for internal development teams. • Implement security best practices across infrastructure, CI/CD pipelines, and container platforms.

Role Description uMotif is seeking a Senior Support Engineer to join our Customer Support team and help deliver reliable, high-quality support for users of the uMotif clinical trial platform. This role is ideal for a technically skilled support professional, engineer or developer with experience in clinical data systems, SQL-based data analysis, and troubleshooting complex platform issues. You will work closely with cross-functional teams to resolve technical problems, support clinical trials, and improve the tools and processes that underpin our support operations. Working remotely from the US, you will support customers during business hours while collaborating closely with our globally distributed team across Europe and North America. The successful candidate will be proactive, detail-oriented, and comfortable operating in a fast-paced environment where solving technical challenges and ensuring excellent customer outcomes are key priorities. Responsibilities - Technical Support & Issue Resolution - Provide day-to-day technical support for the uMotif clinical trial data capture platform. - Investigate, triage, and resolve technical issues using Jira Service Management and other internal systems. - Collaborate with engineering, product, and clinical operations teams to resolve issues efficiently. - Maintain clear and accurate documentation of support interactions and solutions. - Clinical Trial Support & Compliance - Support ongoing clinical trials by troubleshooting user and system issues affecting investigators, healthcare professionals, and study participants. - Provide professional and empathetic communication with users while maintaining compliance and documentation standards. - Data Reconciliation & Analysis - Perform data reconciliation between uMotif captured data and external study EDC systems. - Execute protocol-guided data updates and corrections where required. - Extract, manipulate, and report on clinical trial data using SQL and database tools. - Device Provisioning & Logistics - Manage provisioning and configuration of clinical trial devices including smartphones, tablets, glucose monitors, and wearable devices. - Configure and manage Mobile Device Management (MDM) systems. - Coordinate with global logistics and third-party vendors for device distribution and management. - Process Improvement & Automation - Identify opportunities to improve support processes, tooling, and automation. - Contribute to the adoption of AI tools and automation technologies to enhance support efficiency. - Help develop internal tooling or scripts where appropriate. Qualifications - 5+ years’ experience working in Clinical Trials, Life Sciences, Real World Evidence platforms, Pharmacovigilance, or digital health systems. - Strong SQL/database experience (5+ years) including scripting, data extraction, transformation, and analysis. - Experience supporting data capture or clinical trial platforms. - Strong troubleshooting and analytical skills. - Experience working with ticketing/support systems such as Jira Service Management. - Excellent written and verbal communication skills. - Comfortable interacting with healthcare professionals and clinical research teams. - Strong understanding of data protection and regulatory requirements, including: GCP, 21 CFR Part 11 & GDPR. Nice to have - Experience with some of the following technologies is beneficial: - AWS services including S3 and CloudWatch. - AI tooling such as AWS Bedrock or Amazon Nova. - Python or PHP. - Command line scripting and automation. - Tableau or similar data visualisation tools. - Mobile Device Management (MDM) platforms. Benefits - Unlimited Paid Time Off. - 401(k) Retirement Plan contribution. - Majority company funded benefits package incorporating: Health, Dental and Medex2 coverage, and a selection of Vision plans. - Life and AD&D Insurance fully covered by uMotif. - Remote working solutions. - Work From Home allowance. - uMotif is an equal opportunity employer. - No Recruiters Please.

• Provide day-to-day technical support for the uMotif clinical trial data capture platform. • Investigate, triage, and resolve technical issues using Jira Service Management and other internal systems. • Collaborate with engineering, product, and clinical operations teams to resolve issues efficiently. • Maintain clear and accurate documentation of support interactions and solutions. • Support ongoing clinical trials by troubleshooting user and system issues affecting investigators, healthcare professionals, and study participants. • Provide professional and empathetic communication with users while maintaining compliance and documentation standards. • Perform data reconciliation between uMotif captured data and external study EDC systems. • Execute protocol-guided data updates and corrections where required. • Extract, manipulate, and report on clinical trial data using SQL and database tools. • Identify opportunities to improve support processes, tooling, and automation. • Contribute to the adoption of AI tools and automation technologies to enhance support efficiency. • Help develop internal tooling or scripts where appropriate.

• Grow and manage a comprehensive pipeline to achieve annual targets • Work with the extended uMotif team to identify, develop and close opportunities • Territory planning and development

• Collaborate closely with Project Managers, technical managers, solution developers, and testers to design project deliverables of varying complexity • Ensure solutions align with product capabilities while meeting client needs, balancing protocol requirements and delivery team constraints • Lead customer workshops and proof-of-concept sessions, showcasing questionnaire designs and mapping user and study journeys that align with client protocol objectives and study requirements • Serve as a subject matter expert (SME) during pre- and post-sales activities, reviewing study protocols to recommend optimal solutions and utilizing internal configuration tools to create prototypes for clients • Foster a passion for technology and innovation in clinical research, advocating for innovative user-centric trial designs tailored to client-specific needs • Effectively communicate complex technical requirements and design considerations to non-technical stakeholders, translating their requests into actionable language for technical teams • Plan and prioritize user stories, managing multiple project backlogs to ensure the efficient delivery of large, multifaceted eCOA studies • Address complex technical design challenges by developing innovative, thoughtful solutions • Gain deep expertise in tools, systems, core features, and design standards to deliver high-quality outcomes, specializing in efficient, repeatable story design processes • Set and champion design standards and best practices within Delivery Services, ensuring high-quality Jira hygiene and strict adherence to requirement and story best practices, particularly for questionnaire and study design • Stay engaged with the evolving Life Sciences technology landscape, developing industry expertise by attending and presenting at relevant conferences to enhance knowledge and visibility

• Be a part of our exciting growth as we continue to expand our Customer Success team! • Lead the planning and implementation of projects to ensure they are delivered in a successful and timely manner from kick off through to study close. • Collaborate with customers to exceed their expectations of project outcomes. • Create both customer configuration speciation from customer protocol and clinical case record forms. • Ensure the quality of all customer-facing deliverables. • Manage all project documentation according to defined processes. • Identifies risk areas and determines and implements mitigation actions for the risks identified. • Determine the appropriate use of resources in accomplishing projects. • Develop strategies and methodologies for presenting accurate information succinctly.