Microsoft Data Architect

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

Benefits offered by this job

Competitive salary

401k with company match

Health insurance plans

Paid time off

Paid holidays

Job summary

Camco Manufacturing in Greensboro, NC, seeks a Microsoft Data Architect to design and deliver a connected data foundation that expands the value of a data-driven environment. This hands-on role blends data architecture with reporting, data engineering, and strategic planning.

You will build and support reliable pipelines connecting D365 Finance and Operations, legacy systems, and other apps using Microsoft integration services, APIs, and Fabric notebooks.

Qualifications

• 7+ years in data engineering or related roles.
• Hands-on Microsoft Fabric experience with pipelines and lakehouse.
• Experience integrating Dynamics 365 Finance and Operations data with other systems.
• Strong SQL and Python/PySpark skills for ETL/ELT and modeling.
• Ability to define target architecture and prioritize a roadmap.
• Experience partnering with operating and finance stakeholders on data definitions.
• Bachelor’s degree in CS/IS/Engineering or equivalent practical experience.

Responsibilities

• Build and support pipelines connecting D365 Finance and Operations, legacy systems, and other apps.
• Develop ingestion and transformation workflows using SQL, Python or PySpark, Fabric Data Factory, notebooks.
• Create enterprise data models and trusted datasets across core domains.
• Enable Power BI reporting and semantic models for stakeholders.
• Establish data definitions, quality rules, ownership, and governance.
• Collaborate with ERP teams to align data delivery with ERP changes and adoption.

Skills

Data engineering

Enterprise data integration

SQL

Python

PySpark

Azure data services

D365 Finance and Operations

Education

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

Tools

Microsoft Fabric

Power BI

OneLake

Lakehouse

Azure Data Factory

Job description

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 ArchitectLocation: Greensboro, NCOverview: 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 salary401k with company matchParticipation in company health (medical, dental) insurance plans. Supplemental insurance offeredPromote work/life balance including paid time off and paid holidaysCamco 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.