Microsoft Data Architect

Camco Manufacturing; Greensboro (NC); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

401k with company match

Health insurance

Paid time off

Paid holidays

Job summary

Camco Manufacturing seeks a Microsoft Data Architect to lead the design and delivery of an enterprise data foundation. You will blend data architecture with reporting, processes, data engineering, and strategic planning while partnering across the business.

The role requires hands-on Fabric experience, expertise with D365 data, and collaboration with ERP teams to ensure data delivery aligns with system changes and adoption.

Qualifications

• 7+ years in data engineering, enterprise data integration, or related roles.
• Hands-on Microsoft Fabric experience, including data pipelines and lakehouse/warehouse solutions.
• Experience integrating Dynamics 365 Finance and Operations data with other systems.
• Strong SQL and Python or PySpark skills for ETL/ELT and data modeling.

Responsibilities

• Build and support reliable pipelines connecting D365 Finance and Operations, legacy systems, and other business apps.
• Develop ingestion and transformation workflows using SQL, Python/PySpark, Fabric Data Factory, and notebooks.
• Create enterprise data models and trusted datasets across products, customers, suppliers, inventory, orders, and finance.

Skills

Data engineering

Data integration

SQL

Python

Azure

ETL/ELT

D365 integration

Education

Bachelor’s degree in Computer Science or related field

Tools

Microsoft Fabric

Power BI

Azure

D365 integration

Job description

Job Details: Job Location: Greensboro - Greensboro, NC 27409-9603, About Camco Manufacturing

Camco Manufacturing, founded in 1966, has evolved from a humble beginning with one employee and a single product to become a powerhouse in the outdoor recreation market. With a rich history spanning over 50 years, Camco has grown exponentially, boasting a workforce of over 1,000 employees, 140+ patents, and an extensive product line exceeding 5,600 offerings. The company's commitment to innovation is evident through its best-in-class, in-house development team, specializing in creating cutting-edge products for the RV, marine, ATV, and other outdoor recreation industries.

Headquartered in Greensboro, North Carolina, Camco operates eight separate manufacturing and warehousing facilities encompassing one million square feet. This extensive infrastructure allows Camco to efficiently meet the diverse needs of its customers, solidifying its position as a leading aftermarket parts and accessories manufacturer in the fast-growing outdoor recreation market. Focused on the RV, Marine, and Camping sectors, Camco's influence in these industries is significant, as it continues to lead the charge with a relentless pursuit of excellence and a commitment to delivering top-notch products and services.

Job Title: Microsoft Data Architect

Location: Greensboro, NC

Overview:

Lead the design and delivery of a connected enterprise data foundation that helps CAMCO expand the value and adoption of a data driven environment. This hands-on role combines data architecture with reporting, business processes, data engineering, strategic planning, and partnership across the business.

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 that connect 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.

Qualifications:

• 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.
• Demonstrated 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.
• Manufacturing or multi-site operating experience preferred, with familiarity across inventory, procurement, production, supply chain, or finance.
• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field; equivalent practical experience considered.

Compensation and Benefits:

• Competitive salary
• 401k with company match
• Participation in company health (medical, dental) insurance plans. Supplemental insurance offered
• Promote work/life balance including paid time off and paid holidays

Camco is an Equal Opportunity Employer. We consider all qualified applicants for employment without regard to any characteristic protected by applicable federal, state, or local law and are committed to maintaining a workplace free from discrimination and harassment.