Technical Lead, Data Engineering
Revance
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).
Job description
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).
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).
Requirements
- 10+ years in data engineering and integration
- 5+ years in a technical lead capacity
- Hands-on expertise in Azure integration and data services (Logic Apps, Azure Functions, API Management, ADF, ADLS Gen2, Key Vault, 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 (Salesforce OCE/IQVIA) using REST and Bulk APIs, plus 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 production-grade data/AI/ML pipelines
- Proficiency in Python and SQL
- Strong problem-solving, communication, and documentation skills
Benefits
- Competitive Compensation
- Annual Performance Bonus
- Flexible PTO
- Holidays
- Parental Leave
- Healthcare Benefits
- HSA Match
- 401(k) Matching
- Employer Paid Life Insurance
- Disability Insurance
- Pet Insurance
- Wellness Discounts
Company overview
Revance is a leading biotechnology company that specializes in developing innovative aesthetic, skincare, and therapeutic products through science-powered innovation. Founded in 1999 and headquartered in Nashville, Tennessee, the company has grown into a fully-integrated global organization with operations spanning over 60 countries. Revance is best known for its groundbreaking DAXXIFY® (daxibotulinumtoxinA-lanm), a peptide-stabilized botulinum toxin that represents the first true innovation in neuromodulator formulation in over 20 years. The company's diverse portfolio includes aesthetic injectables, consumer skincare brands like StriVectin and Blue Lizard sunscreen, and therapeutic treatments for conditions such as cervical dystonia. With a team of 1,001-5,000 employees, Revance combines deep scientific expertise with commercial excellence to deliver differentiated products that address unmet needs in health, beauty, and wellness across generations.