Associate Engineer, Technology I

Company Description

About AbbVie

AbbVie's mission is to discover and deliver innovative medicines and solutions that solve serious health issues today and address the medical challenges of tomorrow. We strive to have a remarkable impact on people's lives across several key therapeutic areas including immunology, oncology, and neuroscience - and products and services in our Allergan Aesthetics portfolio. For more information about AbbVie, please visit us atwww.abbvie.com. Follow @abbvie onLinkedIn,Facebook,Instagram,XandYouTube.

Job Description

We are seeking a technically versatile and self-drivenAssociate Engineer, Technology Ito join the AdvancedSolutions Team within the DELOS (Data, Exploration & Linked Outcomes Solutions) Research Group, with a primary focus on leading the EXTRACTplatform,anAI-powered data engineering suite. This role combines data science, software engineering, and clinical informatics to automate the full lifecycle of data standardization (aligned to FDA/SDTM standards) and OMOP Common Data Model transformation. The ideal candidate brings strong Python and SQL skills, hands-on experience with large language models and RAG architectures, and a passion for building intelligent systems that replace manual data processes with automated, auditable AI pipelines executed directly against enterprise Impala infrastructure. The standardized data produced by EXTRACT directly supports the DELOSPatientVerseinitiative, providing the clean, research-ready data layer that downstream patient-level analytics and insights depend on.

Responsibilities

• Lead and execute agile sprints with stakeholders from all business domains, gathering requirements and delivering actionable data solutions.
• Harmonize and integrate patient-level data (clinical trial, EHR/claims, etc.) across business lines.
• Partner closely with project owners to ensure data, tools, and AI solutions are scalable, fit-for-purpose, and impactful.
• Contribute to the organizations long-term data/AI/tool strategies by sharing hands-on knowledge and workflow improvements.
• Drive engagement, adoption, and change management by actively collaborating with teams from early research.
• Design and build AI pipelines that ingest raw clinical trial data (Adverse Events, Lab Tests, Medical History, Procedures, Drug Names, Subject Exposure) and standardize it to FDA/SDTM regulatory formats using LLM-powered term resolution, phonetic matching, and symbolic rule engines.
• Analyze andvalidateclinical trial datasets across large study libraries to evaluate and confirm their transformation into CDISC SDTM data standards.
• Architect andmaintaina Retrieval-Augmented Generation (RAG) system that indexes OHDSI clinical documentation (THEMIS, CDM field specifications,dbt-syntheaSQL patterns) into vector stores and injects relevant context into LLM inference for automated OMOP CDM field mapping.
• Build automated ETL SQL generation that reads source schemas via scan reports, produces Impala-compatible INSERT/SELECT statements, and populates OMOP CDMtables replacingmonths of manual mapping with a single pipeline command.
• Develop vocabulary resolution systems that map clinical codes (e.g., LOINC, MedDRA, ICD-10,RxNorm) to OMOPconcept_idsusing Athena vocabulary tables, embedding similarity, and LLM reasoning for ambiguous cases.
• Implement multi-layer data quality validation (DQD constraint checks, Achilles descriptive analysis,OmopCheckoutsanity checks) translated from R/JDBC to Impala SQL, producing automated HTML quality reports after every ETL run.
• Build neuro-symbolic AI pipelines that route clinical term cleaning through four tiers symbolic rules (YAML), phonetic algorithms, embedding similarity, and LLM inference with full auditability and per-tier traceability on every decision.
• Design and develop full-stack applications (React frontend, Python-based API backend, Impala database layer) including a mapping review dashboard with confidence scores, RAG citations, and approve/reject workflows for stakeholder sign-off.
• Build and integrate interactive dashboards (Qlik Sense, Power BI) into applications to surface data-quality, mapping, and stakeholder insights.
• Build semantic classification models that automaticallydeterminethe meaning, data type category, clinical domain, sensitivity level, and OMOP mapping target for every column in any source database.
• Develop LLM-powered data profiling capabilities that analyze source schemas, profile tables and columns, visualize relationships, and generate natural-language documentation.
• Apply unsupervised machine learning (embedding-based clustering, such as K-Means) to standardize medical terminology, includingindicationterms.
• Design feedback loops where data quality validation failures and human corrections automatically generate new rules, surface vocabulary gaps, and expand training data ensuring the systemimproves withevery use.
• Lead and mentor cross-functional teams and multi-university student cohorts in building clinical data tools for example, terminology and lab-name mapping tools delivered against defined timelines translating complex technical requirements into achievable sprint deliverables.
• Partner across AbbVie divisions to scale EXTRACT through enablement sessions, cross-functional collaborations.
• Key Stakeholders: Medical Health Insights, Value and Evidence, Discovery Research, Health Economics and Outcomes, Market Access, Precision Medicine, Data Engineering & Observability (DEO), Mergers and Acquisitions

Qualifications

Required:

• Bachelors Degree in Computer Science, Data Science, Statistics, Mathematics, or related quantitativefieldrequired.
• Programmingproficiencyin Python and SQLrequired.
• Hands-on experience building applications with large language model APIs (Claude, GPT, or equivalent) including prompt engineering and Retrieval-Augmented Generation (RAG) architectures.
• Familiarity with clinical data standards such as OMOP CDM, CDISC SDTM, LOINC, and MedDRA (RxNorma plus), ordemonstratedability to learn clinical informatics domains rapidly.
• Experience developing data visualizations and dashboards (Power BI, Qlik Sense).
• Demonstrated ability to learn, understand, and masternew technologiesrapidly.
• Strong written and oral English communication skills with the ability to present technical work to non-technical stakeholders.
• Ability to lead cross-functional teams and mentor junior developers or student cohorts.
• Analytical reasoning abilities, intellectual curiosity, and creativity in problem solving.

Preferred

• Experience with distributed data systems (Apache Impala, Cloudera, Snowflake, or equivalent) preferred.
• Experience profiling, standardizing, orvalidatingclinical or trial datasets against regulatory or common data models (e.g., SDTM, OMOP) preferred.
• Familiarity with OHDSI tools andvocabularies(Athena,WhiteRabbit, Achilles,DataQualityDashboard, Ariadne), or the ability to ramp up on them quickly, preferred.
• Experience with full-stack and web development (React, HTML/CSS, and API design;FastAPIor a similar backend framework a plus) preferred.
• Exposure to machine learning methods, including unsupervised techniques such as clustering (e.g., K-Means), preferred.
• Experience with embedding models and embedding-based similarity or semantic search (vector databases a plus) preferred.

Additional Information

Applicable only to applicants applying to a position in any location with pay disclosure requirements under state orlocal law:

• The compensation range described below is the range of possible base pay compensation that the Companybelieves ingood faith it will pay for this role at thetimeofthis posting based on the job grade for this position.Individualcompensation paid within this range will depend on many factors including geographiclocation,andwemay ultimately pay more or less than the posted range. This range may bemodified in thefuture.
• We offer a comprehensive package of benefits including paid time off (vacation, holidays, sick),medical/dental/visioninsurance and 401(k) to eligibleemployees.
• This job is eligible toparticipate in our short-term incentiveprograms.

Note: No amount of payis considered to bewages or compensation until such amount is earned, vested, anddeterminable.Theamountandavailabilityof anybonus,commission, incentive, benefits, or any other form ofcompensation and benefitsthat are allocable to a particular employeeremains in the Company'ssoleandabsolutediscretion unless and until paid andmay bemodified at the Companys sole and absolute discretion, consistent withapplicable law.

AbbVie is an equal opportunity employer and is committed to operating with integrity, driving innovation, transforming lives and serving our community. Equal Opportunity Employer/Veterans/Disabled.

US & Puerto Rico only - to learn more, visithttps://www.abbvie.com/join-us/equal-employment-opportunity-employer.html

US & Puerto Rico applicants seeking a reasonable accommodation, click here to learn more:

https://www.abbvie.com/join-us/reasonable-accommodations.html