AI, Data & Automation Engineer

QualDerm Partners is a dermatology-focused healthcare organization with practices spanning dermatology, skin cancer care, cosmetics, plastic surgery, and pathology. The AI, Data & Automation Engineer will build and evolve the modern data platform, develop analytics and Power BI solutions, and deploy AI-powered and workflow automations to deliver trusted insights and improve operational efficiency.

Responsibilities

Design, build, and optimize scalable ELT/ETL pipelines in Snowflake, ingesting data from diverse internal systems, third-party sources, and APIs while ensuring data quality, integrity, and performance

Develop and maintain dimensional and analytical data models, using tools such as SQL, dbt, Snowpark, Streams/Tasks, and orchestration frameworks

Monitor pipeline health and manage cost, performance tuning, and access controls (roles, warehouses, resource usage) within Snowflake

Apply version control, testing, and CI/CD practices to data and automation assets

Build analytics solutions that answer critical business questions, inform decisions, and drive operational efficiency

Develop, publish, and maintain Power BI reports, dashboards, and semantic models (DAX, Power Query, row-level security) that communicate insights clearly to audiences ranging from frontline teams to executives

Support development and tracking of KPIs and business metrics, and support ad hoc analysis projects as needed

Design and deploy LLM-powered solutions such as document and text extraction, summarization, classification, intelligent search/RAG over enterprise data, and AI-assisted reporting, using Snowflake Cortex, Azure OpenAI, or comparable platforms

Develop prompts, evaluation methods, and guardrails to ensure AI outputs are accurate, auditable, and appropriate for business use

Build and maintain RPA and workflow automations (e.g., Power Automate, UiPath, or similar) that eliminate manual, repetitive processes and integrate with the data platform and business systems

Identify and prioritize opportunities to increase efficiency through automation; document expected value and measure results after deployment

Partner with cross-functional teams and business stakeholders to gather and refine requirements and translate them into data, analytics, and automation deliverables

Develop and foster relationships with internal and external partners to manage work-streams and cross-functional deliverables

Partner with senior leaders to support data governance, security, and responsible AI practices, including protection of sensitive data (e.g., PHI/PII) and compliance with applicable regulations

Build stakeholder trust in data accuracy and cleanliness through documentation, validation, and clear communication

Learn the business quickly and stay current on emerging data, AI, and automation technologies

Comply with organizational policies and procedures as outlined in the Teammate Handbook and Policy & Procedure Manuals

Preferred

Experience building solutions with LLMs and generative AI (prompt engineering, RAG, API integration, evaluation), e.g., Snowflake Cortex, Azure OpenAI, or similar

Experience with RPA and workflow automation tools (e.g., Power Automate, UiPath, Automation Anywhere)

Familiarity with the Azure ecosystem (Azure Data Factory, Synapse, Azure Functions) and with dbt or comparable transformation/orchestration tools

Experience with Git, CI/CD, and DevOps practices for data and automation

Knowledge of data governance, security, and privacy practices, including HIPAA

Snowflake, or cloud/AI certifications

LLM solution development

Generative AI

Prompt engineering

Retrieval-augmented generation (RAG)

API integration

AI evaluation

Snowflake Cortex

Azure OpenAI

RPA

Workflow automation

Power Automate

UiPath

Automation Anywhere

Azure Data Factory

Azure Synapse

Azure Functions

dbt

Data transformation

Workflow orchestration

Git

CI/CD

DevOps

Data governance

Data security

Data privacy

HIPAA

Snowflake certification

Cloud certifications

AI certifications

Benefits

Comprehensive Health Coverage – Includes Medical, Dental, and Vision plans

Generous 401(k) Plan – Company matches 100% of the first 3%, plus 50% of the next 2%, with immediate vesting

Paid Time Off (PTO) – Accrue PTO from day one, plus enjoy 6 paid holidays and 2 floating holidays each year

Company-Paid Life Insurance – Basic life coverage, with the option for additional plans

Disability Protection – Short-term and long-term disability coverage

Additional Wellness Plans – Accident, critical illness, and identity theft protection plans

Employee Assistance Program (EAP) – Access confidential support for personal or work-related challenges

Exclusive Employee Discounts – Save on products and services with special discounts just for you

Referral Bonus Program – Earn bonuses by referring qualified candidates to join the team

Hybrid workplace

Company

Dermatology and aesthetics practice management services

Brentwood, Tennessee, USA

http://qualderm.com/

Founded in 2014

1001-5000 employees

Qualifications

Applicants must be currently authorized to work in the United States in a full-time basis

Bachelor's degree in a related field (e.g., Computer Science, Information Systems, Data Science, Engineering, Analytics) or equivalent experience

2-4 years of experience as a data engineer, analytics engineer, data analyst, or automation developer

Hands-on experience with Snowflake, including advanced SQL and building and optimizing data pipelines and models

Hands-on experience with Power BI, including data modeling, DAX, and dashboard design

Experience with Python or another scripting language for data processing and automation

Experience in data management disciplines including data integration, modeling, optimization, and data quality

Experience working in cross-functional teams and collaborating with business stakeholders on data and analytics initiatives

Healthcare industry experience

Experience building solutions with LLMs and generative AI (prompt engineering, RAG, API integration, evaluation), e.g., Snowflake Cortex, Azure OpenAI, or similar

Experience with RPA and workflow automation tools (e.g., Power Automate, UiPath, Automation Anywhere)

Familiarity with the Azure ecosystem (Azure Data Factory, Synapse, Azure Functions) and with dbt or comparable transformation/orchestration tools

Experience with Git, CI/CD, and DevOps practices for data and automation

Knowledge of data governance, security, and privacy practices, including HIPAA

Snowflake, or cloud/AI certifications

2-4 years of experience as a data engineer, analytics engineer, data analyst, or automation developer.

Required skills

Snowflake, SQL, Data Engineering, Power BI, DAX, Python, Healthcare, Generative AI, Prompt Engineering, Retrieval-Augmented Generation (RAG), Power Automate, UiPath, dbt, Git and CI/CD, HIPAA, Stakeholder Collaboration

Preferred skills

Snowflake, or cloud/AI certifications

Experience

2+ years