Senior BI Engineering & Data Platforms Lead

City Auto Glass, inc.; Columbus (OH); On-site; USD 150,000 - 210,000; Full time

Benefits offered by this job

Weekly pay and bonus opportunities

Tuition reimbursement

Health benefits

Job summary

City Auto Glass, inc. is seeking a Senior Manager of BI Engineering and Data Products to lead enterprise analytics programs and build a high-performing BI organization.

You will set technical direction for scalable BI platforms, partner with Data Engineering and IT, and translate priorities into durable roadmaps delivering trusted analytics at scale. This role is office-based in Columbus, OH with a strong emphasis on governance and delivery.

Qualifications

• Bachelor's Degree in computer science, engineering, analytics, or related field Required
• 7-9 years hands on experience in a data engineering or analytics related role Required
• 4-6 years managing a technical team Required
• 7-9 years Advanced SQL development, including complex transformations, performance optimization, and data modeling. Required
• 4-6 years Experience with modern cloud data warehouses (e.g., Snowflake or similar). Required
• 4-6 years Experience using Python or other programming languages for data transformation, automation, or analytics workflows. Required
• 4-6 years Experience with modern analytics engineering tools (e.g., dbt, FiveTran) and CI/CD practices. Required
• Expert-level SQL knowledge, including advanced query optimization, window functions, CTEs, nested queries, and complex transformations used in enterprise analytics workflows. High (High proficiency)
• Advanced proficiency in Python or similar programming languages for analytics engineering, automation, workflow orchestration, and operational reporting. High (High proficiency)
• Ability to technically scope, decompose, and solve abstract analytical problems by translating ambiguous business needs into well‑defined BI engineering designs using computer science and analytics engineering principles. High (High proficiency)
• Deep knowledge of BI and analytics engineering architecture, including the design and evolution of governed semantic layers, metrics frameworks, and reusable analytics components. High (High proficiency)
• Strong understanding of data warehouse architecture and data modeling best practices, including dimensional modeling, performance optimization, and alignment with upstream ingestion patterns. Medium (Medium proficiency)
• Experience leading teams responsible for enterprise BI platforms, dashboards, and downstream data products built on governed semantic layers. Medium (Medium proficiency)
• Ability to lead technical scoping, estimation, and business case refinement, including defining and comparing quantifiable value, complexity, and architectural impact across analytics use cases. Medium (Medium proficiency)
• Demonstrated people management skills, including coaching, performance management, mentoring senior technical talent, and workforce development. Medium (Medium proficiency)
• Strong communication and stakeholder management skills, with the ability to translate between business objectives and technical design decisions. Medium (Medium proficiency)
• Sound architectural judgment to balance near‑term delivery with long‑term scalability, maintainability, and platform consistency. Medium (Medium proficiency)
• Experience administering and governing BI platforms (e.g., Tableau Cloud), including site management, permissions, content organization, certification, automation, and enforcement of reporting standards. Medium (Medium proficiency)
• Familiarity with modern data engineering tools, CI/CD concepts, and version control practices as they relate to analytics engineering and BI workflows. Medium (Medium proficiency)

Responsibilities

• Provide technical and people leadership for the BI Engineering and Data Products team: Sets architectural direction and governs BI engineering standards to ensure scalable, reliable analytics solutions. Manages and develops BI Engineers and BI Developers through performance management, coaching, and workforce planning, and serves as the escalation point for complex, cross‑functional technical and delivery issues.
• Scope, decompose, and lead execution of complex BI engineering problems across a variety of functional areas: Analyzes ambiguous business and analytical needs and translates them into well‑defined BI engineering designs and work plans. Deconstructs complex or legacy reporting workflows and guides the application of computer science and analytics engineering principles to ensure solutions are performant, extensible, and maintainable.
• Oversee BI pipeline engineering quality and delivery: Ensures end‑to‑end quality of BI pipelines from semantic and metrics layers through dashboards and downstream data products by establishing and enforcing standards for data modeling, testing, documentation, version control, and CI/CD. Drives consistent engineering practices to improve reliability, scalability, and speed of analytics delivery.
• Design and evolve BI semantic and reporting architecture: Leads the design and continuous improvement of shared semantic layers, metrics frameworks, and reusable BI components. Partners closely with Data Engineering and IT engineering teams to align BI solutions with enterprise data platforms, ingestion patterns, and architectural standards, enabling scalable self‑service analytics.
• Define and communicate business and technical value of BI initiatives: Quantifies the impact of BI solutions and communicates value to Product, Engineering, and Business leaders to inform prioritization, sequencing, and investment decisions. Ensures BI roadmaps balance business outcomes, technical complexity, and architectural alignment.

Job description

City Auto Glass, inc. is seeking a Senior Manager of BI Engineering and Data Products to lead enterprise analytics programs and build a high-performing BI organization.

You will set technical direction for scalable BI platforms, partner with Data Engineering and IT, and translate priorities into durable roadmaps delivering trusted analytics at scale. This role is office-based in Columbus, OH with a strong emphasis on governance and delivery.