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 #J-18808-Ljbffr