Data Architect Jobs in Massachusetts

ABOUT THE ROLE

We are seeking a Principal Data Architect to lead the design of data architecture across our Microsoft Dynamics 365 ecosystem (ERP and CRM) and enterprise data platform. You will play a critical role in connecting core business systems with modern data platforms to enable scalable analytics, AI, and efficient business operations.

• Design and lead data architecture for Microsoft Dynamics 365 (Finance & Operations, CRM)
• Define integration patterns between D365 and enterprise systems (MES, PLM, etc.) using APIs, Dataverse, Dual-write, and Azure services
• Develop scalable data models supporting finance, customer, product, and operational domains
• Enable high-quality data for analytics, reporting, and AI/ML use cases
• Partner with engineering and business teams to streamline data flows and reduce complexity
• Establish best practices for data governance, quality, and lifecycle management
• Guide adoption of modern Azure data platforms (e.g., Data Factory, Synapse, Fabric)

WHAT YOU BRING

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field (or equivalent practical experience)
• 10+ years of experience in data architecture or data engineering
• Hands-on experience with Microsoft Dynamics 365 (ERP and/or CRM)
• Strong understanding of Dataverse, Dual-write, BYOD, and D365 data structures
• Experience with Azure data and integration services
• Expertise in data modeling and enterprise data integration
• Ability to work across teams and influence technical direction

NICE TO HAVE

• Experience integrating D365 with MES, PLM, or manufacturing systems
• Familiarity with event-driven architectures (Service Bus, Event Grid, Kafka)
• Experience with Power BI, Fabric, or modern analytics platforms

WHY THIS ROLE MATTERS

You'll help shape how data flows across critical business systems, reducing complexity and enabling faster, more reliable insights across the organization.

ROLE SUMMARY

The Principal Data Architect will define and drive the data architecture strategy across core enterprise systems—including ERP, MES, PLM, and other business-critical applications—while enabling a scalable data platform for analytics and AI. This role ensures consistent data models, seamless integration, and high data quality across operational and analytical environments.

KEY RESPONSIBILITIES

Enterprise Data Architecture (ERP, MES, PLM)

• Define end-to-end data architecture spanning ERP, MES, PLM, CRM, and other enterprise systems
• Establish canonical data models and master data standards (e.g., product, customer, supplier, manufacturing data)
• Design integration patterns across applications (APIs, event-driven, ETL/ELT, data virtualization)

Data Integration & Interoperability

• Lead architecture for cross-system data flows (e.g., order-to-cash, procure-to-pay, manufacturing execution)
• Standardize data exchange, synchronization, and lineage across platforms
• Partner with application teams to reduce point-to-point integrations and data silos

Data Platform & Analytics Enablement

• Align operational data architecture with enterprise data platform (warehouse / lake house)
• Enable high-quality, trusted data for reporting, analytics, and AI/ML use cases
• Define patterns for real-time and batch data processing

Master Data & Governance

• Define and support Master Data Management (MDM) strategy across domains
• Establish data governance, quality, and stewardship models
• Ensure compliance with data security, privacy, and regulatory requirements

Leadership & Collaboration

• Act as a bridge between enterprise applications, data engineering, and business teams
• Influence architecture decisions across IT and business domains
• Provide technical leadership and mentorship to architects and engineers

QUALIFICATIONS

Required

• 10+ years in data architecture, data engineering, or enterprise architecture roles
• Strong experience with Microsoft Dynamics 365 (ERP and CRM), including understanding of underlying data models (Finance & Operations, Sales, Customer Service, etc.)
• Proven track record designing data architectures and integrations around D365, including data extraction, synchronization, and extension patterns
• Deep expertise in data modeling (transactional and analytical), particularly across finance, customer, product, and order domains
• Experience designing cross-system integrations using APIs, Dataverse, Azure Integration Services, or middleware platforms
• Hands-on experience with Azure data ecosystem (e.g., Azure Data Factory, Synapse, Fabric, Data Lake)
• Strong understanding of data lifecycle management, data quality, and governance practices
• Ability to influence across business and IT stakeholders without direct authority

Preferred

• Experience integrating D365 with MES, PLM, or other enterprise/manufacturing systems
• Familiarity with Dataverse, Dual-write, BYOD (Bring Your Own Database), and Common Data Model (CDM)
• Experience with event-driven architectures (e.g., Azure Event Grid, Service Bus)
• Knowledge of master data management (MDM) solutions and implementation
• Experience supporting analytics and reporting layers (Power BI, Fabric, or similar) on top of D365 data
• Background in manufacturing, supply chain, or industrial environments

BENEFITS

Pay Range: The pay range on this posting applies to the role in the primary location specified. If the candidate would ultimately work outside of the primary location posted, the applicable range could differ. Actual starting pay is determined by a number of factors including relevant skills, qualifications, and experience.

Other Compensation: Employees in this role are eligible for additional rewards which could include: Annual Discretionary Bonus or Sales Bonus as Applicable

Benefits Provided: All Regular US employees receive:
- Paid vacation time accrued based on years of service
- Paid sick time
- 12 (twelve) Paid Holidays Each Calendar Year
Prorated for reduced hour schedules

Additional Benefits Offered: IPG also offers access to:
- Medical, dental, and vision insurance plans with options for HSA/FSA
- Dependent Care FSA
- Paid Basic Life and AD&D Insurance
- Short-term and Long-term Disability insurance
- 401(k) plan with Company matching
- Employee Stock Purchase Plan (ESPP)
- Tuition Reimbursement Program
- Employee Assistance Program (EAP)
- Adoption Assistance
- Pet Insurance
- Parental Bonding Leave
- Bright Horizons Backup Care
- Bright Horizons College Coach
*Benefits eligibility may differ by program for reduced hour schedules.

DEADLINE AND HOW TO APPLY

This job posting will remain active until a candidate is identified and/or the Company rescinds the job posting. For full consideration, please click on the link to apply.

COMPENSATION

MA: $112,436 - $148,978