Enterprise Data Architect

Paycom - ATS; New York (NY); Remote; USD 160,000 - 230,000; Full time

Benefits offered by this job

Annual bonus

Medical/Dental/Vision/Life Insurance

401(k) match

Job summary

GAL MANUFACTURING COMPANY LLC is seeking an Enterprise Data Architect to design and evolve Vantage Elevation’s enterprise data landscape, spanning MDG, MDM, and data warehousing. Target platforms include Infor Visual ERP, Tacton CPQ, Salesforce, and Microsoft Fabric.

This role partners with Master Data Governance Council and domain managers to ensure accurate, well-modeled data for reporting across multi-site manufacturing.

Qualifications

• 7+ years in data architecture or enterprise data warehousing in manufacturing environments.
• Strong governance frameworks, stewardship models, and data quality metrics.

Responsibilities

• Lead Master Data Governance and MDG initiatives across key domains.
• Define data quality rules, lineage, and dictionaries for critical data entities.
• Own logical/physical data models for enterprise data warehouse and Fabric lakehouse.

Skills

MDM/MDG

SQL Server

Data modeling

Microsoft Fabric

Salesforce

Tacton CPQ

Infor Visual ERP

MuleSoft

Data governance

ETL/ELT

Education

Bachelor’s degree in CS/IS/Data Management

Tools

SQL Server

Microsoft Fabric

Power BI

Infor Visual

Tacton

Salesforce

MuleSoft

Job description

Enterprise Data ArchitectRegular Position | Full-Time | RemoteIf you are a forward-thinker interested in building enterprise data strategy, strengthening data governance, and creating scalable data architecture across a growing organization, then keep reading! We are searching for an experienced Enterprise Data Architect to join our Vantage Elevation team.About UsVantage Elevation, LLC is North America’s leading independent manufacturer of elevator components and systems. Vantage is comprised of eight business units, including GAL Manufacturing, GAL Canada, Hollister-Whitney, Elevator Controls, Courion, Bore-Max, Thames Valley Controls, and Vertical Dimensions.Through its brands, Vantage supplies nearly all of the electro-mechanical devices used in contemporary elevators. Founded in 1927, the Vantage group employs more than 900 team members across multiple locations in the United States, Canada, and the United Kingdom.About the RoleThe Enterprise Data Architect is responsible for designing and evolving Vantage Elevation’s enterprise data landscape across master data governance (MDG), master data management (MDM), and data warehousing and analytics.This role will translate business requirements from Finance, Sales, Operations, and Engineering into scalable, well-governed data architecture spanning our ERP (Infor Visual), CPQ (Tacton), CRM (Salesforce), and analytics platforms (Microsoft Fabric / SQL Server).The Enterprise Data Architect will partner closely with the Master Data Governance Council, domain application managers, and business stakeholders to ensure data is accurate, consistent, well-modeled, and readily available for reporting and decision-making across Vantage’s multi-site, engineer-to-order and configure-to-order manufacturing environment.RequirementsWe are searching for a candidate with:Bachelor’s degree in Computer Science, Information Systems, Data Management, or a related field; equivalent experience will be considered7+ years of experience in data architecture, master data management, or enterprise data warehousing, ideally within a manufacturing or industrial environmentDemonstrated experience designing and implementing MDM and/or MDG programs, including governance frameworks, stewardship models, and data quality metricsStrong data modeling skills, including dimensional and entity-relationship modelingHands-on experience with SQL Server, data warehousing, and modern analytics platforms such as Microsoft Fabric, Power BI, or equivalentExperience with ERP and CPQ data structures; experience with Infor Visual and Tacton is strongly preferredFamiliarity with integration platforms and API-based data synchronization patternsExcellent communication skills with the ability to translate complex technical data concepts for business stakeholders and executive audiencesExperience supporting ERP migrations or major system upgrades from a data architecture perspective is a plusExperience within a private-equity-owned or multi-site discrete manufacturing environment, particularly engineer-to-order or configure-to-order, is preferredFamiliarity with data governance and MDM tooling evaluationCDMP (Certified Data Management Professional), DAMA-DMBOK familiarity, Microsoft Fabric/Azure Data certifications, or similar credentials are a plusExperience chairing or actively supporting a formal data governance council or committee is preferredDuties and ResponsibilitiesA typical day may include:Master Data Governance (MDG)Serve as the architectural lead supporting the Master Data Governance Council and help define and maintain data governance policies, standards, and stewardship models across customer, item, supplier, and site master domainsDesign and maintain data quality rules, ownership matrices, and approval workflows for the creation, modification, and retirement of master data recordsDefine and track data quality KPIs, including completeness, accuracy, timeliness, and duplication rates, and lead root-cause analysis and remediation of recurring data quality issuesDocument and maintain data lineage, business glossaries, and data dictionaries for critical master and reference data entitiesFacilitate cross-functional governance forums and drive alignment between IT and business data owners on policy exceptions and process changesMaster Data Management (MDM)Architect and support the selection and implementation of MDM tooling and integration patterns to synchronize master data across Infor Visual ERP, Tacton CPQ, and SalesforceDesign golden-record strategies, matching and merge rules, and survivorship logic for key domains, including customer, item, vendor, and site dataDefine integration and data synchronization patterns in partnership with the Integrations domain manager, leveraging MuleSoft for real-time and batch master data flowsEstablish data stewardship workflows and exception-handling processes for conflicting or duplicate records across source systemsSupport M&A and site-expansion data onboarding, ensuring new business units are incorporated into the enterprise master data model with minimal disruptionData Warehousing & AnalyticsOwn the logical and physical data architecture for the enterprise data warehouse (SQL Server) and broader analytics platform (Microsoft Fabric), including dimensional models, semantic layers, and data martsDesign ETL/ELT pipelines and data integration flows from transactional systems, including Visual, Tacton, Salesforce, OneStream, Esker, and DocuWare, into the warehouse and Fabric lakehousePartner with FP&A, Operations, and Sales leadership to translate reporting and analytics requirements into scalable data models and self-service semantic modelsDefine standards for data modeling, naming conventions, version control, and documentation across the analytics environmentMonitor and optimize data pipeline performance, storage costs, and platform reliabilityEstablish monitoring and alerting for data pipeline failures and SLA breachesArchitecture, Strategy & CollaborationMaintain and evolve Vantage’s enterprise data architecture reference model in alignment with the broader application and integration architectureEvaluate emerging tools and platforms, including MDM suites, data catalogs, and PDM/MDM dependencies, and provide build-versus-buy recommendations to IT leadershipProduce architecture documentation, data flow diagrams, and governance artifacts appropriate for technical teams as well as executive and board audiencesProvide technical guidance and mentorship to domain application managers, including ERP, CPQ, and Integrations, on data-related design decisionsEnsure data architecture decisions support compliance, audit, and financial reporting requirements across U.S. and Canadian business unitsComplete other projects and responsibilities as assignedBenefits of Working With UsSalary Range: $160,000–$230,000Actual compensation will be determined based on experience, qualifications, geographic location, and in keeping with applicable local legislation.Annual Bonus: Target bonus opportunity of 15%, subject to the terms and conditions of the Company’s annual incentive planMedical/Dental/Vision/Life InsuranceHSA401(k) / Company Match / Non-ElectiveCommuter Benefits (where applicable)Generous Paid Time Off (PTO)Tuition ReimbursementEmployee Assistance Program (EAP)Plum Benefits…and more!Position DetailsFull-TimeRegular PositionDepartment: ITLocation: RemoteGeneral office and manufacturing plant environments may apply depending on business needsLimited physical effort requiredEqual Employment OpportunityVantage Elevation, LLC provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual