AI Data Engineer

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