AI Data Engineer

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