Senior Data Engineer at OmniTrial

OmniTrial is the developer of CRAVE (Clinical Research Analytics Visualization Engine), a powerful SaaS tool designed to streamline clinical research management. CRAVE transforms the operational and financial management of clinical trials by consolidating data from various sources into a single, user-friendly platform. This innovative solution empowers clinical operations teams to efficiently gather, track, and assess data, ultimately identifying actionable insights to optimize and accelerate studies.

We are currently seeking a Senior Data Engineer to join and directly shape our early-stage team. In this role, you will extend the build-out of our ingestion infrastructure and data pipelines from end to end. You will assist in configuring and maintaining a data integration service based on the modern data stack, which includes a cloud data warehouse, a data transformation layer, and workflow orchestration.
Your responsibilities will entail deeply analyzing the details of our various data sources, employing creativity in assessing and ensuring data quality, and employing critical thinking in evaluating technologies that serve our use cases. Additionally, you will collaborate with customers on data onboarding and the streamlined ingestion of their clinical trial data. Furthermore, you will assist in the implementation of our predictive analytics.

What you'll do:

• Steer the build of data pipelines to external and internal data sources and work with both structured and unstructured data to efficiently extract and load various sources into our data warehouse.
• Design and implement data orchestration using tools like Airflow to manage ingestion, processing, and data flow across all the components of the data infrastructure.
• Oversee the processing, deduplication, and reconciliation of data from different sources using external customer EDCs (Castor, Medidata) and dbt.
• Work with customers on data onboarding and ingestion with an understanding on how the data impacts the analytic dashboards
• Help design, update, and implement a predictive analytics engine using AI models alongside a data scientist

What you'll need:

• 5+ years of experience as a hands-on Data Engineer specializing in data ingestion, extraction, and modeling using modern data stacks. 
• Expertise in SQL 
• Deep experience building dbt models to transform and connect disparate raw data sources. 
• Expertise in developing and implementing data integration strategies, including API connections, direct database queries, and custom data pipelines, to facilitate seamless data flow between our platform and external systems
• Experience with workflow orchestration tools such as Airflow.
• Experience with a cloud data warehousing (AWS)
• Ability to work well independently and with remote team in an Agile environment
• Experience in gathering customer requirements, providing consultative support, and tailoring data solutions to meet specific client needs

Who you are:

• Manages Ambiguity: You skillfully analyze situations, asking the right questions to uncover root causes to difficult issues. By synthesizing data from diverse sources, you navigate complex, high-quantity, and sometimes contradictory information to solve problems effectively.
• Drive Results: You have a strong bottom-line orientation and persist in accomplishing objectives despite obstacles and setbacks.
• Communicates & Collaborates: You are effective in a variety of communication settings: one-on-one, in small, and large groups, or among diverse styles and position levels. 

Additional Information:

Full-time base salary range of $128,000 to $158,000 plus equity