Microsoft Data Architect

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:

We offer a wide range of career opportunities with excellent benefits. Above all, we are looking for passionate, talented, hard-working, nice people with great taste to help us build this brand we love.

• 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.