Developer 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 at InterMed builds the data foundation and AI-driven applications that automate business and clinical workflows and support better decision-making.

Responsibilities

Support migration of BI workloads from on-prem SQL and SSIS into Microsoft Fabric; assess which legacy packages to retire, rebuild, or re-architect
Maintain existing SQL Server and SSMS-based reporting workflows and SSIS packages to preserve continuity 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
Complete data warehouse build-out across priority subject areas using a SQL-based transformation framework (for example, dbt) for modular, tested, version-controlled, documented data models
Build and publish certified Power BI semantic models with governed measures, definitions, and business-friendly descriptions to support Copilot report building and self-service data agents
Support the transition of reporting from Tableau to Power BI
Build and maintain Python automation scripts and APIs that support pipelines, applications, and agents
Implement data quality, integrity, and security controls across the platform, 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
Set 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 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 use Python- and LLM-based custom agents for multi-step workflows where low-code is insufficient
Creatively leverage EMR and other data sources, including structured fields, clinical documentation, and other unstructured sources, to support new 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 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 guidelines and InterMed policies
Perform other duties supporting InterMed’s mission, vision, and values

Requirements

Bachelor’s degree in Computer Science, Information Systems, or a related field; or an 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
Python proficiency for data engineering: transformation, automation, pipeline development, and data quality scripts
Advanced SQL skills with hands-on experience in SQL Server and SSMS-based environments (preferred)
Daily hands-on 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 integration within a broader Microsoft technology environment
Deep understanding of end-to-end data workflows from source systems to consumption
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
Demonstrated 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 and Salary

Location: South Portland, ME (onsite)
Salary: USD 105,372 - 152,880 per year

Mission and Values

Follows InterMed’s mission of patient-centered primary care, with patient first to deliver high quality, high value care
Delivers care with a level of service that exceeds patient expectations
Treats patients and each other with dignity and respect; maintains a positive attitude
Insists on honesty and integrity from team members and business partners
Emphasizes teamwork across physicians, colleagues, and patients
Embraces change to better serve patients
Uses business practices featuring individual accountability and group responsibility to deliver high value healthcare
Has fun as the team carries out the mission

View full job page →

Get Developer Jobs in South Portland, ME alerts

New Developer Jobs in South Portland, ME, daily.