Data Engineer

AMEGO INC is seeking a hands-on Data Engineer to own data strategy, metrics, reporting, and BI contractor management in Attleboro, MA.

Location: Attleboro, MA (onsite)

Responsibilities

• Collaborate with executives, program leadership, finance, HR, and clinical leadership to capture data needs and convert them into reporting and analytics deliverables.
• Define and maintain Amego's core operational, clinical, and financial metrics.
• Oversee regular reporting cycles such as board packs, program performance reviews, and compliance reports, plus ad hoc analyses to inform leadership decisions.
• Act as the internal data expert, clarifying what data exists, what it means, and what questions it can answer.
• Manage day-to-day interactions with the external BI contractor.
• Translate business needs into clear requirements; validate deliverables for quality, accuracy, and usability.
• Coordinate priorities, timelines, and budgets, ensuring contractor work integrates with internal systems.
• Assess the BI engagement over time and propose adjustments to scope, vendor, or in-house capabilities as needs evolve.
• Develop and maintain SQL queries, data models, and reports from Amego's operational systems, including NetSuite, EHRs, payroll, SharePoint, and others.
• Create dashboards and self-service reporting using Power BI.
• Design and maintain data pipelines and integrations with Power Automate, Azure Data Factory, Python, and related tools.
• Uphold data quality, integrity, and timeliness; investigate and resolve data discrepancies.
• Document data sources, definitions, transformations, and reporting logic.
• Identify manual, repetitive processes across departments and implement automation to eliminate them.
• Develop system integrations to minimize duplicate data entry and reconciliation tasks.
• Support compliance and operational reporting workflows, including MassHealth renewals, internal audits, and regulatory submissions.
• Provide tier 2 support for escalated issues across Amego's residential, clinical, and administrative locations.
• Assist with user accounts, permissions, and access provisioning across NetSuite, Microsoft 365, and SharePoint.
• Contribute to small IT projects such as software rollouts, system upgrades, and vendor coordination.
• Help maintain internal documentation, runbooks, and knowledge base content.
• Ensure data practices align with Amego security policies and HIPAA requirements.
• Implement and maintain role-based access controls for sensitive data.
• Establish and document data governance practices suitable for a growing organization.

Requirements

• Experience with NetSuite data and administration, including ODBC connections and saved searches.
• Experience administering Microsoft 365, SharePoint, Entra ID (Azure AD), and Power Platform tools.
• Background in healthcare, human services, or another regulated industry; familiarity with HIPAA.
• Familiarity with MassHealth, Medicaid, or other public payer data.
• Experience standing up or significantly maturing an analytics function.
• Experience in a small-team environment where roles span multiple disciplines.

Technologies

• NetSuite
• Power BI
• Power Automate
• Azure Data Factory
• Python
• Microsoft 365
• SharePoint
• Entra ID (Azure AD)
• Power Platform

Compensation

Salary: $100,000 - $110,000 per year