Engineer 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

InterMed, P.A. is seeking an AI Data Engineer to help build the data foundation and AI-enabled applications that automate business and clinical workflows while improving decision-making. This role is focused on developing a Microsoft Fabric and Power BI data platform and supporting LLM and AI-assisted tooling, with healthcare data use handled under HIPAA/PHI safeguards.

Based in South Portland, ME (onsite), the engineer will support migrations from legacy on-premises SQL/SSIS workflows into modern lakehouse patterns, while also delivering governed semantic models, data pipelines, and automation that connect sources to end users and AI agents.

What you’ll do

Assist with migrating BI workloads from on-premises SQL and SSIS to Microsoft Fabric, including assessing which legacy packages to retire, rebuild, or re-architect, and maintaining existing SQL Server and SSIS workflows for continuity of reporting during 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
Complete data warehouse build-out across priority subject areas using a SQL-based transformation framework (for example, dbt) to create 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 support Copilot report building and self-service data agents, including support for transitioning reporting from Tableau to Power BI
Build and maintain Python automation scripts and APIs that support data pipelines, applications, and agents
Ensure data quality, integrity, and security controls across the platform, including HIPAA/PHI safeguards and automated monitoring and alerting on 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, other administrative, and clinical workflows end to end, from data intake through action and an audit trail
Develop custom apps and agents using low-code tools within 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 other unstructured sources, to support analytics and automation use cases 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 by assessing fit, overlap with in-house capabilities, data access and integration needs, 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 aligned with HIPAA guidelines and InterMed policies
Perform other duties that support the mission, vision, and values of InterMed

What you bring

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 platform, and integration within 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 you’ll work with

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

Compensation: USD 105,372 - 152,880 per year.

View full job page →

Get Engineer Jobs in South Portland, ME alerts

New Engineer Jobs in South Portland, ME, daily.