AI Data Engineer

InterMed, P.A.; South Portland (ME); On-site; USD 105,000 - 153,000; Full time

Job summary

InterMed, P.A. in South Portland, ME seeks an AI Data Engineer to build an AI-ready data foundation, driving automated clinical and business workflows.

You will modernize data platforms with Microsoft Fabric and Power BI, and develop LLM-enabled tooling while safeguarding HIPAA/PHI protections. This role spans data engineering, analytics enablement, and governed AI development, including migrating BI workloads, designing Fabric OneLake pipelines, and delivering reusable pipelines, semantic

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent combination of education and experience.
• 3-5 years of hands-on experience with AI, data engineering, BI development, or data architecture, with proven ownership of production pipelines.
• Proficiency in Python for data engineering tasks including transformation, automation, and pipeline development.
• Advanced SQL skills with hands-on experience in SQL Server and SSMS-based environments preferred.
• Hands-on daily experience using AI coding assistants and AI tools to write, test, debug, and document code and queries.
• Familiarity with Microsoft Fabric, Azure data services, Snowflake or equivalent cloud data platform and how it integrates in a Microsoft environment.
• Deep understanding of end-to-end data workflows from source to consumption.
• Proven experience delivering at least one production application, automation, or AI agent that replaced a manual process.
• Experience with version control, CI/CD workflows, and code review practices for data assets.
• Ability to design, document, and govern enterprise data models and architecture.

Responsibilities

• Migrate BI workloads from on-premises SQL and SSIS to Microsoft Fabric, assessing which legacy packages to retire, rebuild, or re-architect while maintaining reporting continuity during the transition.
• Design and build data pipelines into Fabric OneLake from source systems (eClinicalWorks, payer and ACO files) including orchestration, scheduling, dependency management, alerting, and failure recovery.
• Deliver data warehouse build-out across priority subject areas using a SQL-based transformation framework (e.g., dbt) with modular, tested, version-controlled, and documented data models.
• Build and publish certified Power BI semantic models with governed measures and descriptions powering Copilot report building and self-service data agents; support transitioning reporting from Tableau to Power BI.
• Create and maintain Python automation scripts and APIs that support pipelines, applications, and agents.
• Maintain data quality, integrity, and security controls, including HIPAA/PHI safeguards and automated monitoring for key data quality metrics.
• Evaluate and integrate LLM-powered tooling to accelerate data workflows and enable natural-language data access.
• Establish team standards for responsible AI development, including AI-assisted coding with human review of generated output.
• Use AI to optimize dashboard builds and capabilities for end-user agents and self-service analytics.
• Develop custom apps and agents using Power Apps, Power Automate, Fabric data agents, and Python- and LLM-based agents for multi-step workflows.

Skills

Python for data engineering

SQL

AI tooling

Version control

CI/CD

Data modeling

Education

Bachelor's degree in Computer Science or Information Systems

Tools

Python

SQL Server

SSMS

SSIS

Fabric OneLake

Power BI

dbt

GitHub Copilot

Claude Code

Power Apps

Power Automate

LLM APIs

EMR

Job description

The AI Data Engineer role at InterMed, P.A. supports the creation of an AI-ready data foundation that powers automation of business and clinical workflows, with an emphasis on improving decision-making. Based in South Portland, ME (onsite), you will build and modernize data platforms using Microsoft Fabric and Power BI, while developing LLM and AI-assisted tooling that remains aligned with HIPAA and PHI protections.

This position combines responsibilities across data engineering, analytics enablement, and governed AI development. Work includes migrating BI workloads from legacy SQL and SSIS environments, designing pipelines into Fabric OneLake, and delivering reusable pipelines, semantic models, and agent-enabled applications that move from data intake to auditable action.

Responsibilities

• Support migration of BI workloads from on-premises SQL and SSIS to Microsoft Fabric, including assessing which legacy packages to retire, rebuild, or re-architect, while maintaining continuity of reporting during the transition
• Design and build data pipelines into Fabric OneLake from source systems (for example, eClinicalWorks, payer and ACO files), including orchestration, scheduling, dependency management, alerting, and failure recovery
• Deliver data warehouse build-out across priority subject areas using a SQL-based transformation framework (for example, dbt) with modular, tested, version-controlled, and documented data models
• Build and publish certified Power BI semantic models with governed measures, definitions, and business-friendly descriptions that power Copilot report building and self-service data agents, including support for transitioning reporting from Tableau to Power BI
• Create and maintain Python automation scripts and APIs that support pipelines, applications, and agents
• Maintain strong data quality, integrity, and security controls, including HIPAA/PHI safeguards and automated monitoring and alerting for key data quality metrics
• Evaluate and integrate LLM-powered tooling (for example, Claude, Copilot, or equivalent) to accelerate data workflows and enable natural-language data access
• Establish team standards for responsible AI-assisted development, including using AI tools to write, review, test, and document code and queries with human review of generated output
• Use AI to optimize dashboard builds and capabilities for end-user agents and self-service analytics
• Design, build, and deploy purpose-built applications and AI agents that automate BI, IT, and administrative or clinical workflows end to end, from data intake through action and audit trail
• Develop custom apps and agents using low-code tools in the Microsoft ecosystem (for example, Power Apps, Power Automate, and Fabric data agents) and Python- and LLM-based custom agents for multi-step workflows where low-code tools fall short
• Leverage EMR and other data sources, including structured fields, clinical documentation, and unstructured sources, in compliance with HIPAA/PHI safeguards
• Partner with IT on integration, deployment, and ongoing operation of applications and agents
• Advise IT and business partners on AI vendor point solutions, including fit, overlap with in-house capabilities, data access and integration requirements, and build-versus-buy tradeoffs
• Develop analyst capability in Python, flexible coding, unstructured data techniques, and AI-assisted development through coaching, code review, and shared patterns and templates
• Maintain strict confidentiality in alignment with HIPAA and InterMed policies
• Perform other duties to support InterMed’s mission, vision, and values

Requirements

• Bachelor’s degree in Computer Science, Information Systems, or a related field; or equivalent combination of education and experience
• 3-5 years of hands‑on experience with AI, data engineering, BI development, or data architecture, with demonstrated ownership of production pipelines and infrastructure
• Proficiency in Python for data engineering, including transformation, automation, pipeline development, and data quality scripts
• Advanced SQL skills with hands‑on experience in SQL Server and SSMS-based environments preferred
• Hands‑on, daily experience using AI coding assistants and AI tools (for example, Claude Code, GitHub Copilot, or similar) to write, test, debug, and document code and queries
• Familiarity with Microsoft Fabric, Azure data services, Snowflake or a comparable cloud data platform and how it integrates in a broader Microsoft environment
• Deep understanding of end-to-end data workflows from source system to consumption layer
• Demonstrated experience delivering at least one production application, automation, or AI agent that replaced a manual business process
• Experience with version control, CI/CD workflows, and code review practices for data assets
• Ability to design, document, and govern enterprise data models and architecture

Technologies

• Microsoft Fabric, Power BI, Microsoft Copilot, Claude, Claude Code, GitHub Copilot
• SQL, SQL Server, SSMS, SSIS, OneLake
• Power BI semantic models, Copilot report building
• Power Apps, Power Automate, Fabric data agents
• dbt, Python, LLM APIs, JSON
• EMR, Tableau, Azure data services, Snowflake
• Microsoft Entra ID, Microsoft 365

Location: South Portland, ME (onsite)
Compensation: USD 105,372 - 152,880 per year
Experience: 3+ years