AI, Data & Automation Engineer

QualDerm Partners LLC; Brentwood (TN); On-site; USD 90,000 - 140,000; Full time

Benefits offered by this job

Competitive Pay

Comprehensive Health Coverage

Generous 401(k)

Paid Time Off (PTO)

Company-Paid Life Insurance

Disability Protection

Wellness Plans

Employee Assistance Program (EAP)

Exclusive Employee Discounts

Referral Bonus Program

Job summary

QualDerm Partners LLC seeks a Data & Automation Engineer to design and evolve our data platform, analytics, and intelligent automation stack. You will build Snowflake ELT/ETL pipelines, create dimensional models, and deliver Power BI reports while enabling AI-driven insights across the business.

You will deploy LL M-powered solutions, develop robust prompts and guardrails, and implement RPA/workflow automations to improve operational efficiency and data governance. Healthcare exposure is a plus.

Qualifications

• Bachelor's degree or equivalent in a related field.
• 2-4 years of hands-on data engineering, analytics engineering, data analysis, or automation development experience.
• Hands-on experience with Snowflake, advanced SQL, and building data pipelines and models.
• Hands-on experience with Power BI, including data modeling and dashboard design.
• Experience with Python or other scripting for data processing and automation.
• Experience in data integration, modeling, optimization, and data quality.
• Experience working in cross-functional teams with business stakeholders.
• Healthcare industry experience.

Responsibilities

• Design, build, and optimize scalable ELT/ETL pipelines in Snowflake from diverse sources.
• Develop dimensional and analytical data models with SQL, dbt, Snowpark, and orchestration tools.
• Monitor pipeline health, cost, performance, and access controls in Snowflake.
• Apply CI/CD practices to data and automation assets.
• Create analytics solutions to answer critical business questions and drive efficiency.
• Develop and publish Power BI reports and semantic models for varied audiences.
• Support KPI tracking and ad hoc analytical projects as needed.
• Design and deploy LL M-powered solutions (extraction, summarization, classification, search) over enterprise data.
• Develop prompts, guardrails, and evaluation methods for AI outputs.
• Build RPA/workflows using Power Automate, UiPath, etc., to automate repetitive processes.
• Identify automation opportunities and measure results after deployment.
• Collaborate with stakeholders to translate requirements into concrete data/analytics deliverables.
• Support data governance, security, and privacy practices, including PHI/PII protection.

Skills

Snowflake

Power BI

Python

SQL

Data modeling

CI/CD

RPA

Education

Bachelor's degree in Computer Science / Information Systems / Data Science / Engineering

Tools

dbt

Snowpark

Power Automate

UiPath

Job description

COMPANY SUMMARY:

To achieve and maintain our high-quality standards, we seek to partner with physicians and staff who share our vision, values and brand promises and are dedicated to advancing our culture. QualDerm providers and staff are well-trained, highly skilled and recognized as leaders in the specialty of dermatology.

We currently have 158 practices in 17 states, spanning across the full spectrum of dermatology, skin cancer care, cosmetics, plastic surgery, and pathology with continued plans to expand further across the nation.

We will partner with you to establish the best combination of environment, technology, teamwork and personal reward opportunities to earn your confidence that we are your best place to work.

PURPOSE:

The AI, Data & Automation Engineer builds and evolves the organization's modern data platform and the intelligent automations that run on top of it. This role combines data engineering (Snowflake pipelines and models), analytics and visualization (Power BI), and process automation (LLM-powered workflows, RPA, and low-code tools) to turn internal and external data into trusted KPIs, actionable insights, and measurable operational efficiency.

The position is responsible for both the technical foundation of the data platform and the delivery of analytics and automation solutions that business teams rely on every day.

ESSENTIAL DUTIES AND RESPONSIBILITIES:

Data Platform & Engineering

• 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.

Analytics & Visualization

• 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.

AI & Automation

• 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.

Collaboration & Governance

• 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.

Required

• 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.

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.

Benefits of joining Qualderm Partners:

• Competitive Pay – Attractive compensation to reward your hard work
• Comprehensive Health Coverage – Includes Medical, Dental, and Vision plans to keep you covered
• 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 – Peace of mind with basic life coverage, with the option for additional plans
• Disability Protection – Short-term and long-term disability coverage to protect you in unexpected circumstances
• Additional Wellness Plans – Accident, critical illness, and identity theft protection plans for extra security
• 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

QualDerm Partners is proud to be an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. Applicants must be currently authorized to work in the United States in a full-time basis.