Microsoft Data Architect

CAMCO MANUFACTURING LLC•Greensboro, NC

10d•Onsite

About The Position

Lead the design and delivery of a connected enterprise data foundation to expand the value and adoption of a data-driven environment at CAMCO. This hands-on role combines data architecture with reporting, business processes, data engineering, strategic planning, and partnership across the business. The position works with Microsoft Fabric, Azure data services, Dynamics 365 Finance and Operations, legacy systems, and other business applications to create reliable data pipelines, trusted datasets, and consistent reporting.

Requirements

7+ years in data engineering, enterprise data integration, or related roles, including responsibility for solution architecture and delivery.
Hands-on Microsoft Fabric experience, including data pipelines, OneLake, and lakehouse or warehouse solutions, supported by a strong Microsoft Azure data background.
Experience integrating Microsoft Dynamics 365 Finance and Operations or Dynamics AX data with other enterprise systems and reporting platforms.
Strong SQL and Python or PySpark skills, with practical experience in ETL or ELT, dimensional modeling, data quality, and pipeline troubleshooting.
Ability to assess fragmented environments, define a target architecture, prioritize a roadmap, and deliver improvements in manageable phases.
Experience partnering with operational and finance stakeholders to clarify requirements, establish common data definitions, and drive adoption.
Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field; equivalent practical experience considered.

Nice To Haves

Manufacturing or multi-site operating experience, with familiarity across inventory, procurement, production, supply chain, or finance.

Responsibilities

Build and support reliable pipelines connecting D365 Finance and Operations, legacy systems, and other business applications using appropriate Microsoft integration services, supported connectors, and APIs.
Develop ingestion and transformation workflows using SQL, Python or PySpark, Fabric Data Factory, and notebooks as appropriate; support incremental processing, reconciliation, and error recovery.
Create consistent enterprise data models and trusted datasets connecting core domains such as products, customers, suppliers, inventory, orders, and financial transactions.
Partner with business owners to establish data definitions, master data standards, quality rules, ownership, and processes for resolving inconsistencies across sites.
Enable Power BI reporting and semantic models that provide consistent metrics and usable insights for operational and financial stakeholders.
Implement appropriate access controls, lineage, documentation, monitoring, deployment practices, and performance and capacity management.
Work closely with the D365 functional and administration team, business leaders, and implementation partners to align data delivery with ERP changes, testing, and adoption.
Translate architecture and engineering decisions into clear business language; guide delivery partners and support knowledge transfer to internal teams.