Microsoft Data Architect

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

Benefits offered by this job

401k with company match

Health insurance plans

Paid time off and holidays

Paid holidays

Job summary

Camco Manufacturing is seeking a Microsoft Data Architect to lead the design of a connected enterprise data foundation and drive data-driven decision making across the business. The role combines data architecture, data engineering, reporting, and strategic planning with cross-functional collaboration.

Responsibilities include building pipelines between D365 Finance and Operations and legacy systems, creating enterprise data models, and enabling Power BI reporting for stakeholders.

Qualifications

• 7+ years in data engineering or related roles, including architecture and delivery.
• Hands-on Microsoft Fabric experience, including data pipelines, OneLake, and lakehouse/warehouse solutions.
• Experience integrating Microsoft Dynamics 365 Finance and Operations data with other enterprise systems.
• Strong SQL and Python or PySpark skills, with ETL/ELT and data quality expertise.
• Ability to assess fragmented environments, define target architecture, and deliver improvements in phases.
• Experience partnering with operational and finance stakeholders to clarify requirements and drive adoption.
• Manufacturing or multi-site experience preferred, with familiarity across inventory, procurement, production, or finance.

Responsibilities

• Lead design and delivery of a connected enterprise data foundation and reporting.
• Build ingestion pipelines connecting D365 Finance and Operations, legacy systems, and other apps using appropriate connectors and APIs.
• Create enterprise data models and trusted datasets spanning products, customers, suppliers, inventory, orders, and finances.
• Partner with business owners to establish data definitions, master data standards, and quality rules.
• Enable Power BI reporting and semantic models for operational and financial stakeholders.
• Implement access controls, lineage, documentation, monitoring, and deployment practices.
• Translate architecture decisions into business language and guide delivery partners.

Skills

Data engineering

Data integration

SQL

Python

PySpark

ETL/ELT

Dimensional modeling

Azure data

Power BI

Stakeholder collaboration

Education

Bachelor's degree in Computer Science / Information Systems / Engineering

Tools

Microsoft Fabric

OneLake

Power BI

Job description

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

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.

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