Technical Lead, Data Engineering
Job Summary:
Revance is building an Intelligence Platform that will serve as a single source of truth for insights, recommendations, and knowledge across the company. The Technical Lead, Azure Integration & Data Engineering will design and deliver the integrations that connect enterprise systems and the data platform that transforms source information into trusted data for reporting, analytics, and AI. This hands-on technical leadership role will guide integration and data engineering work while contributing production code. The role partners closely with data science, architecture, business, and compliance teams to enable capabilities serving both practices (B2B) and consumers (B2C).
Reporting to: Director, Data Engineering
Location: Hybrid from Nashville TN, Dallas TX, Johnson City TN, or Newark CA; remote from all other US locations
Responsibilities/Essential Duties:
- Enterprise Integrations:
- Lead the design, development, and delivery of enterprise integrations on Microsoft Azure using Logic Apps, Azure Functions, and API Management.
- Build and maintain secure, scalable REST and SOAP APIs to exchange data with Salesforce OCE (Orchestrated Customer Engagement), other CRM platforms, and ERP systems.
- Design real-time synchronization, bulk data loads, and change data capture patterns.
- Secure integrations using Azure Key Vault, Managed Identity, OAuth 2.0, and other Azure security services.
- Implement robust error handling, retries, logging, alerting through Azure Monitor, and reconciliation processes.
- 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.
Create a Job Alert
Interested in building your career at Revance ? Get future opportunities sent straight to your email.
Apply for this job
*
indicates a required field