Business Intelligence & Data Engineering Lead

JOB SUMMARY

Monday - Friday 8AM - 5PM

IN-OFFICE POSITION (Denton, TX)

Job Summary

The Business Intelligence & Data Engineering Lead is responsible for architecting, developing, and governing the enterprise data warehouse and analytics ecosystem for Group CBS Companies.

This role leads the design and implementation of scalable data models, reporting frameworks, and cross-system integrations across NetSuite, Salesforce, ADP, and other enterprise platforms. The position ensures the accuracy, integrity, and strategic alignment of financial, operational, and sales data across subsidiaries.

The role goes beyond report development and includes data architecture, pipeline orchestration, governance, automation strategy, and executive analytics enablement. This position serves as a strategic liaison between Finance, Operations, IT, and Leadership to empower data-driven decision-making across the organization.

ESSENTIAL DUTIES AND RESPONSIBILITIES include the following: May be modified from time to time.  Other duties may be assigned.

Enterprise Data Architecture & Engineering

• Architect, develop, and maintain the enterprise data warehouse using modern data engineering principles (Bronze/Silver/Gold or medallion architecture).
• Design and manage data pipelines for ingestion, transformation, and scheduling across multiple source systems (NetSuite ERP, Salesforce CRM, ADP, etc.).
• Implement incremental load strategies, change tracking, and data validation controls.
• Identify and resolve data inconsistencies across systems to ensure reporting accuracy.
• Evaluate and mitigate technical debt within reporting and ERP environments.
• Monitor and optimize cloud spend by creating visibility dashboards for usage, identifying inefficiencies, and implementing automated, continuous improvements to eliminate waste.

Business Intelligence & Analytics

• Design and deploy enterprise-level Power BI semantic models and dashboards aligned with executive, financial, and operational KPIs.
• Managing user licenses and permissions, configuring workspace settings and data gateways, monitoring performance/usage metrics, and enforcing security policies, such as sensitivity labels and data protection.
• Standardize reporting logic across subsidiaries to ensure consolidated financial and operational visibility.
• Create and maintain semantic layer for business-friendly abstraction between data lake and analytics tools, translating complex, technical data structures into familiar business terms 
• Lead requirements gathering sessions with stakeholders and translate business processes into scalable data solutions.
• Provide advanced financial and operational analysis to support executive decision-making.
• Serve as primary analytics liaison for cross-functional initiatives (e.g., subsidiary expansion, FX reporting, consolidation).

Governance & Strategy

• Establish data governance standards, documentation practices, and role clarity between BI, Finance, and Applications teams.
• Identify redundant or conflicting data sources and rationalize architecture.
• Ensure reporting processes align with accounting integrity and audit requirements.
• Support strategic initiatives including AI enablement, automation opportunities, and data-driven operational optimization.
• Provide technical leadership in cross-functional projects and system enhancements.

Cross-Functional Collaboration

• Partner with Finance, Accounting, Operations, IT, and executive leadership to ensure data initiatives align with company objectives.
• Support subsidiary expansion efforts (e.g., multi-currency and international reporting).
• Act as a trusted advisor for reporting, data modeling, and system interaction between ERP, CRM, and BI platforms.
• Mentor users and promote data literacy across departments.

METRICS

Performance is evaluated based on:

• Accuracy and reliability of enterprise reporting
• Stability and success rate of data pipelines
• Timely delivery of strategic analytics initiatives
• Improvement of data governance and reduction of technical debt
• Executive satisfaction and cross-functional collaboration effectiveness
• Scalability and maintainability of data architecture

QUALIFICATIONS

Candidates must possess or quickly acquire expertise in:

• Microsoft Fabric / Azure Data ecosystem (or equivalent modern data platform)
• Power BI (semantic modeling, DAX, governance)
• SQL Server / Data Warehousing
• ERP systems (NetSuite strongly preferred)
• CRM systems (Salesforce preferred)
• Data integration, ETL/ELT methodologies
• Financial and operational reporting frameworks

Preferred:

• Experience with multi-entity consolidation and multi-currency reporting
• Familiarity with DevOps and deployment best practices
• Exposure to AI/automation tools and enterprise data strategy

KNOWLEDGE & SKILLS REQUIRED 

• Enterprise-level problem solving
• Systems thinking and architecture design
• Strong financial data acumen
• Ability to lead cross-functional initiatives without formal authority
• Executive-level communication skills
• Strong documentation and governance discipline
• Strategic thinking with operational execution capability
• High ownership mindset and accountability

EDUCATION & EXPERIENCE 

• Bachelor’s degree in Business, MIS, Data Science, or related field required
• 5+ years experience in BI, data engineering, or enterprise analytics
• Experience designing and managing enterprise-scale data models and reporting environments