Data Jobs in South Portland, ME

1 job found

Include remote jobs

Today

AI Data Engineer

InterMed, P.A. South Portland, ME

South Portland, ME

Today

$105k - $153k/yr Full time Backend Developer Analytics Artificial Intelligence

Apply Now

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

View full job page →

Get Data Jobs in South Portland, ME alerts

New Data Jobs in South Portland, ME, daily.