umotif
Data Engineer
USA (Eastern Time)
Sponsorship not specifiedDetected 29 days ago
PythonCode ReviewGitSQLPostgreSQLRedshiftAWSTerraformCI/CDGrafanaDevOpsAirflowdbtData EngineeringAI OrchestrationHL7/FHIRClinical TrialsCommunicationCollaboration
About the role
- No Recruiters Please 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.
Responsibilities
- SQL Development & Optimization Write and maintain complex SQL queries across large-scale clinical datasets, including multi-table joins, window functions, CTEs, and subqueries.
- Build and manage indexes, partitioning strategies, and materialized views to support performant analytical and operational queries.
- 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.
- Drive root cause analysis for data incidents and improve pipeline reliability over time. ]]>
Nice to have
- 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. ]]>
- reading execution plans, diagnosing bottlenecks, and delivering significant performance improvements.
- Strong hands-on experience with AWS data services, particularly Aurora, Redshift, Athena, and S3.
- 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.
Skills
- 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.
Benefits
- Support data cataloging, lineage tracking, and access control in line with healthcare data standards.
This listing is sourced directly from umotif's careers page and normalized into a canonical job model.