Data Engineering & Platform Development
Design and build scalable ETL/ELT pipelines from source systems into Snowflake using Azure Data Factory (ADF), ADLS Gen2, Snowflake OpenFlow, Snowpipe, and Streams and Tasks.
Design data models and warehouse layers (raw, curated, and analytics-ready) using dimensional modeling and modern data architecture practices.
Develop transformations with SQL and Snowpark Python, and orchestrate workflows with ADF or similar tools.
Build datasets, feature pipelines, and data products for AI and ML use cases, including lead scoring, Next Best Action, churn prediction, and personalization.
AI, ML & Generative AI
Build AI/ML and generative AI solutions using Snowflake Cortex, Snowflake ML, and Azure OpenAI.
Apply retrieval-augmented generation (RAG), vector search, and prompt engineering to healthcare and commercial use cases.
Partner with data scientists to move models into production and support MLOps workflows.
Technical Leadership & Delivery
Own solution architecture and technical design for integrations and data pipelines while writing production code alongside the team.
Mentor engineers through code reviews, design reviews, and pairing, and help raise the team’s technical standards.
Evaluate tools and patterns across Azure, Snowflake, and AI, and recommend solutions for adoption.
Set engineering standards, coding practices, and CI/CD pipelines using Azure DevOps or GitHub Actions for integrations and data pipelines.
Translate business requirements into technical designs, estimates, and delivery plans.
Maintain documentation, data flow diagrams, and integration specifications.
Own production support by monitoring, troubleshooting, and continuously improving reliability.
Work in an Agile/Scrum team with developers, architects, and business stakeholders.
Basic Qualifications
10+ years in data engineering and integration, including 5+ years in a technical lead capacity.
Deep, hands-on expertise in Azure integration and data services, including Logic Apps, Azure Functions, API Management, ADF, ADLS Gen2, Key Vault, and Azure Monitor.
Strong API and integration experience with REST, SOAP, JSON/XML, OAuth 2.0, error handling, and bulk data patterns.
Experience integrating with Salesforce, particularly Salesforce OCE (IQVIA), using Salesforce REST and Bulk APIs, as well as other CRM and ERP systems.
Hands-on Snowflake skills, including advanced SQL, data modeling, Snowpark Python, OpenFlow, and performance tuning.
Data warehousing and ETL/ELT experience, including dimensional modeling, data quality, and large-volume data processing.
Hands-on experience with Snowflake Cortex, Snowflake ML, or Azure OpenAI, and building production-grade data and AI/ML pipelines.
Proficiency in Python and SQL.
Strong problem-solving, communication, and documentation skills, including the ability to explain technical topics to non-technical stakeholders.
Preferred Qualifications
Experience in medical aesthetics, life sciences, or healthcare, ideally involving commercial data such as practice and injector (HCP/HCO) data, CRM, loyalty programs, and consumer data.
Certifications/Licenses: Snowflake SnowPro; Azure Data Engineer (DP-203); Azure Developer (AZ-204); or Azure Solutions Architect (AZ-305).
Company Summary
Revance is a global company developing, producing, and distributing industry-leading, differentiated products across aesthetics, skincare, and therapeutics. Revance drives innovation beyond convention to offer treatment options for individuals across generations. The Company’s vision is to redefine excellence in aesthetics, skincare, and therapeutics through science-powered innovation, with an unwavering commitment to its providers, patients, and consumers. Revance’s award-winning products are the result of robust research and development, a cornerstone for the Company, driven by renowned scientists. For more information about Revance, please visit us at www.revance.com.
What Revance invests in you
Competitive Compensation including base salary and annual performance bonus.
Flexible PTO, holidays, and parental leave.
Generous healthcare benefits, HSA match, 401k match, employer paid life and disability insurance, pet insurance, wellness discounts and much more!
This section of the job description is required by the American with Disability Act (ADA). The ADA requires that job descriptions reflect the physical and mental demands required to effectively perform the essential duties of the job. The ADA prohibits employers from discriminating against a “qualified individual with a disability” in all aspects of the employment relationship. A “qualified individual with a disability” is “an individual who meets the education, experience, skill, and other job-related requirements of a position held or desired, and who, with reasonable accommodation, can perform the essential functions of a specified job.”
Revance is an Equal Opportunity employer. All qualified applicants will receive consideration for employment based on merit, without regard to race, color, religion, sex, national origin, disability, protected Veteran Status, or any other characteristic protected by applicable federal, state, or local law.