Build Your Career Where You Matter Join CBX Solutions, the nation’s leading provider of architectural doors, frames, hardware, specialty products, and complete security integration services.
At CBX Solutions, trust and communication are the foundation of how we work. We foster an inclusive, collaborative culture where your voice is heard, your ideas matter, and your career has room to grow. Whether you're a problem-solver, innovator, or passionate about service, you’ll thrive here. Be part of a team that invests in your future, celebrates your success, and values your contribution.
Why Work With Us? We’re committed to your success, personally and professionally. You’ll have access to:
- Comprehensive Benefits: Health, dental, vision, prescription coverage, life insurance, and 401(k) with company match.
- Work-Life Balance: Generous paid time off for rest, family, and self-care.
- Career Growth: You’ll benefit from continuous learning, mentorship, and leadership training including access to CBX University, our in-house development program.
- Supportive Culture: Innovation, creativity, and teamwork are at the heart of everything we do.
The Manager of Data & Analytics will lead the organization’s data and analytics function as a strategic business partner, translating how CBX operates - its divisions, branches, projects, customers, and financial structure - into a trusted enterprise data model that powers reporting, analytics, and AI. This role owns the enterprise data model and semantic layer and is responsible for enterprise reporting, data engineering, Power BI / Microsoft Fabric enablement, ERP and CRM analytics, data governance, and practical AI-enabled analytics capabilities. The ideal candidate is a hands-on leader and expert data modeler who understands the business as deeply as the data - able to sit with Finance, Operations, and Sales leaders, understand how decisions are made, and design dimensional and semantic models that reflect that business context. This person builds strong partnerships across leadership and operating teams and establishes the foundation for a modern, governed, business-oriented data culture where a single version of the truth is trusted across the enterprise.
Responsibilities
Business Partnership & Data Strategy
- Serve as the primary data and analytics business partner to executive leadership, Finance, Operations, Sales, Digital, and division/branch leaders; build a deep understanding of business processes, decision rights, and performance drivers.
- Translate business strategy, operating models, and management questions into data model requirements - defining the business entities, relationships, hierarchies, grain, and metrics the data model must represent.
- Facilitate business-led sessions to define and agree on KPI logic, business rules, and terminology (e.g., revenue, margin, backlog, bid, job, customer, branch) so the data model reflects how the business actually operates.
- Develop and execute the enterprise data and analytics roadmap aligned to business strategy and IT priorities.
- Prioritize analytics demand with business stakeholders, manage delivery commitments, and communicate progress, dependencies, risks, and business value.
- Establish standards for analytics solution delivery, documentation, data definitions, and support models.
- Promote a data-driven operating culture through enablement, coaching, and adoption of self-service analytics built on governed data models.
Enterprise Data Modeling & Semantic Layer Design
- Own the enterprise data model - conceptual, logical, and physical - as the authoritative representation of the business across divisions, ERPs, CRM, and operational systems.
- Personally lead and perform dimensional modeling, including Kimball star schemas, fact and dimension design, grain definition, conformed dimensions, slowly changing dimensions, bridge tables, and role-playing dimensions.
- Design conformed enterprise dimensions (customer, product/item, job/project, branch/location, division, vendor, employee, fiscal calendar) that unify data across multiple ERP platforms and business units.
- Model complex business hierarchies and relationships, including legal entity, division, region, branch, cost center, chart of accounts, and project/job structures.
- Architect Power BI / Fabric semantic models with optimized relationships, reusable DAX measure libraries, calculation groups, row-level security, and performance tuning, including Import, DirectQuery, and Direct Lake trade-offs.
- Define and maintain the business glossary, data dictionary, entity-relationship diagrams, and source-to-target mappings so every model element is traceable to its business meaning and source system.
- Establish data modeling standards, naming conventions, design patterns, model review processes, and version control for all enterprise models.
- Assess how ERP consolidation, system migrations, acquisitions, and process changes affect the data model, and evolve the model to preserve historical continuity and comparability.
- Design models to support AI, natural language query, and Copilot experiences through clear business semantics, descriptions, and synonyms.
- Model data from Business Central, Comsense, Sedona, and other ERP platforms into a common enterprise data model, harmonizing differing charts of accounts, item masters, job structures, and customer definitions across divisions.
Power BI, Microsoft Fabric & BI Platform Ownership
- Own the roadmap, standards, governance, and adoption model for Power BI, Microsoft Fabric, and related analytics technologies.
- Publish and maintain certified datasets, reusable measures, and governed reporting assets built on the enterprise semantic model.
- Deliver executive dashboards, operational scorecards, financial reporting, sales analytics, and customer insights.
- Ensure reporting performance, reliability, usability, security, and adoption across the organization.
- Enable self-service reporting while maintaining consistent KPI definitions and data integrity.
- Work with IT Admins to administer and optimize the tools
ERP Analytics & Data Modernization
- Lead analytics enablement for ERP platforms, including Microsoft Dynamics 365, Business Central, Comsense, Sedona and other operational systems as applicable.
- Develop reporting and analytics capabilities for finance, project accounting, order-to-cash, procure-to-pay, inventory, margin, operations, and branch performance.
- Partner with ERP, applications, integration, and business process teams to define data requirements and reporting needs for implementations, migrations, and system rationalization efforts.
- Support data migration, reconciliation, validation, and post-go-live analytics readiness activities.
- Establish ERP-related KPI definitions, data lineage, and controls for trusted business reporting.
CRM & Commercial Analytics
- Lead analytics for CRM adoption, pipeline management, customer engagement, sales activity, lead conversion, account performance, and revenue operations.
- Partner with Sales, Marketing, and Digital teams to create dashboards and insights that improve commercial execution and customer experience.
- Create standard reporting for CRM utilization, data quality, user adoption, and business value realization.
- Support integration of CRM data with ERP, financial, operational, and customer datasets to create end-to-end business visibility.
Data Engineering, Architecture & Integration
- Oversee development and support of data pipelines, data models, curated datasets, and integration patterns required for enterprise analytics.
- Collaborate with application, integration, cloud, and infrastructure teams to ensure reliable data movement and platform operations.
- Improve data quality, availability, scalability, monitoring, and documentation across analytics environments.
- Guide data architecture decisions related to data warehouses, lake houses, semantic layers, APIs, and source-system integration.
- Ensure analytics solutions are designed for maintainability, reuse, security, and future business growth.
Data Governance, Quality & Compliance
- Implement data governance practices including data ownership, stewardship, definitions, lineage, classification, retention, and lifecycle management.
- Establish data quality monitoring, exception reporting, remediation workflows, and accountability processes.
- Partner with Information Security and Compliance teams to protect sensitive information and ensure appropriate access controls.
- Develop standards for master data, reference data, KPI definitions, reporting certification, and data usage policies.
- Balance analytics agility with appropriate controls, auditability, and trust.
Team Leadership & Vendor Management
- Lead, coach, and develop analysts, BI developers, data engineers, and related internal or external resources.
- Establish clear priorities, delivery practices, quality expectations, and performance goals for the data and analytics team.
- Manage external partners, consultants, and vendors supporting analytics platforms, data engineering, AI, or reporting initiatives.
- Build a high-performing, service-oriented team that balances operational support with strategic transformation.
AI Enablement & Advanced Analytics
- Identify and contribute practical AI, machine learning, and advanced analytics use cases that create measurable business value.
- Partner with business and IT leaders to evaluate AI-enabled reporting, natural language query, document intelligence, forecasting, anomaly detection, and automation opportunities.
- Ensure AI and advanced analytics solutions follow governance, security, privacy, data quality, and responsible-use expectations.
- Build organizational capability to use data and AI tools effectively through training, standards, and reusable patterns.
- Assist the organization to translate AI opportunities into clear business cases, pilots, adoption plans, and measurable outcomes.
Required Qualifications
- Bachelor’s degree in information systems, Computer Science, Data Analytics, Engineering, Mathematics, Business, or related field.
- 3+ years of leadership, people management, or team lead experience.
- 7+ years of experience in data analytics, business intelligence, data engineering, or enterprise reporting, including 5+ years of hands-on enterprise data modeling.
- Expert-level data modeling skills: dimensional modeling (Kimball), star and snowflake schemas, conformed dimensions, slowly changing dimensions, normalization/3NF, and conceptual-to-physical model design.
- Advanced Power BI semantic model design, including DAX, calculation groups, row-level security, model performance optimization, and enterprise BI delivery.
- Experience with Microsoft Fabric, Azure Data Services, data warehousing, Lakehouse concepts, ETL/ELT, and modern data architecture.
- Advanced SQL and proven experience modeling data from complex ERP and CRM source systems (financials, project/job costing, inventory, order-to-cash, procure-to-pay).
- Demonstrated portfolio of enterprise data models designed and delivered; candidates should be prepared to walk through and defend their modeling decisions.
- Proven track record as a trusted business partner - able to engage business leaders, understand operational and financial context, and translate business questions into data models, KPIs, and analytics products.
- Strong communication, stakeholder management, prioritization, and executive presentation skills.
Preferred Qualifications
- Experience supporting ERP and CRM platforms such as Microsoft Dynamics 365, Business Central, Comsense, Sedona, or similar systems.
- Experience in construction, distribution, manufacturing, project-based, field service, or multi-site operating environments.
- Experience with data governance programs, master data management, data quality frameworks, and KPI standardization.
- Experience with data modeling tools and practices such as Tabular Editor, DAX Studio, ALM Toolkit, erwin, ER/Studio, or equivalent; familiarity with Data Vault and medallion (bronze/silver/gold) architectures.
- Experience consolidating data models across multiple ERPs, acquisitions, or business units into a single enterprise view.
- Strong business acumen in finance, project accounting, or operations, with the ability to discuss performance in business terms, not just technical terms.
- Experience with AI, machine learning, natural language analytics, forecasting, anomaly detection, or intelligent automation.
- Microsoft certifications such as Fabric Analytics Engineer (DP-600), Power BI Data Analyst (PL-300), Azure Data, Azure AI, or related technologies.
Physical Demands The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. While performing the duties of this job, the employee is regularly required to talk and hear, and is frequently required to stand, walk, use hands to finger, handle, or feel, and reach with hands and arms.
Work Environment This is a field-based, regional role. The employee is expected to travel to branch locations within the region a minimum of 25% of time monthly, and as frequently as business need allows, with total travel expected to run 25–35%. Additional travel to Corporate or other regional locations may be required for acquisitions, employee relations matters, or other business need.
Qualification Requirements To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed in this job description are representative of the knowledge, skills, and/or abilities required to fulfill the essential functions of the role. This job description is not intended to be an exhaustive list of all duties, responsibilities, or qualifications associated with the position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions in accordance with the Americans with Disabilities Act (ADA) and applicable state and local laws.
Equal Opportunity Employer
CBX Solutions is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other characteristic protected by applicable federal, state, or local law.
We are a VEVRAA Federal Contractor and give priority referral to protected veterans. We are committed to taking affirmative action to employ and advance in employment qualified minorities, women, individuals with disabilities, and protected veterans.