IT BI Manager

About this role

Job Description:

The IT BI Manager is a senior, full-stack member of the Data Analytics & Information Engineering (DAIE) team, responsible for reporting, analytics, and AI-enabled solutions across TTI’s business units. This role combines data analytics expertise with strong collaboration skills —SQL-based data preparation and Power BI reporting that delivers valuable solutions to the business. The position works across the enterprise rather than being tied to a specific business unit, and partners with the broader DAIE team to implement AI-enabled solutions — such as Snowflake Cortex Analyst and Cortex Agents, Copilot agents, and related conversational or agentic tools — for business consumption. This role also implements advanced data modeling and single-source-of-truth data architecture efforts, champions data governance standards, and applies project management discipline to complex, multi-phase initiatives. This is a senior individual contributor role requiring deep technical expertise across the full data stack, from pipeline development through reporting and decision-support delivery.

RESPONSIBILITIES / SKILLS • Applies project management discipline to plan, sequence, and deliver complex, multi-phase data engineering and analytics initiatives, coordinating timelines, dependencies, and stakeholder expectations.

• Partners with business stakeholders and DAIE team members across business units to gather requirements, define technical solutions, and translate business needs into scalable pipeline and reporting architecture.

• Assists in implementing AI-enabled solutions for business consumption, such as Snowflake Cortex Analyst and Cortex Agents, Copilot agents, and related conversational or agentic tools, in partnership with the broader DAIE team.

• Collaborates with IT, data engineering, security, and business stakeholders to ensure solutions are scalable, supportable, secure, and aligned to enterprise standards.

• Implements advanced data modeling efforts — including dimensional modeling, semantic models, and predictive/statistical modeling — to support accurate, scalable analytics across the enterprise.

• Champions single-source-of-truth data architecture, consolidating redundant reports and legacy BI environments into unified, trusted enterprise data models.

• Establishes and reinforces data governance practices, including data quality standards, access controls, and documentation, to ensure solutions are secure, consistent, and auditable.

• Writes, tests, and troubleshoots complex SQL queries to access, transform, validate, and prepare data across multiple source systems.

• Builds, maintains, and enhances Power BI reports, dashboards, and semantic models — including enhanced visualizations — that support enterprise-wide business decision-making.

• Uses AI coding agents and related tools (e.g., GitHub Copilot) to accelerate development, testing, debugging, and documentation of pipelines, queries, reports, and automation.

• Assists with Snowflake data preparation, transformation, and semantic model development; contributes to and helps mature dbt-based transformation practices across the team.

• Monitors, troubleshoots, and optimizes scheduled data refreshes, pipeline jobs, and automated processes to minimize business disruption and technical debt.

• Serves as a technical resource and team player, sharing best practices in data engineering, automation, and analytics development, and supporting the professional growth of the broader team.

• Performs other related duties as assigned.

EXPECTED ALLOCATION OF TIME • Data Discovery: 5%

• Data Ingestion: 10%

• Data Transformation: 15%

• Semantic Modeling: 20%

• Report/AI Solution Building/Maintenance: 20%

• Collaboration: 30%

This job description is intended to be illustrative of the position's duties and should not be construed to be an exhaustive statement of the essential functions of the job.

CRITICAL SUCCESS FACTORS • Problem Solving — ability to break down ambiguous, enterprise-scale data problems, troubleshoot root causes, and design solutions that are scalable and sustainable; the single most valued trait for this role.

• Team Player & Collaboration — ability to share technical knowledge, support the growth of all team members, and work effectively alone or with cross-functional teams; highly valued by the team.

• Advanced Modeling & Data Architecture — ability to design and lead advanced data models (dimensional, semantic, predictive/statistical) and single-source-of-truth architecture that the enterprise can rely on.

• AI Fluency — genuine interest and hands-on ability in applying AI coding agents and AI-enabled business solutions (e.g., Copilot, Snowflake Cortex Analyst/Agents); a top must-have for this role.

• Project Management — ability to plan, sequence, and manage complex, multi-phase technical initiatives, balancing timelines, dependencies, and stakeholder expectations.

• Data Governance — ability to establish and enforce data quality, security, access, and documentation standards across pipelines and reporting solutions.

• Technical Depth — strong experience across the full data stack, including pipeline engineering, orchestration, containerization, SQL, and Power BI reporting.

• Analytical Skills — ability to understand data, write and interpret complex SQL, evaluate data quality, build reporting logic, and translate findings into practical recommendations.

• Business Partnership — ability to build credibility with stakeholders across the enterprise, understand functional needs, and manage expectations without being tied to a single business unit.

• Ownership & Follow-Through — ability to take end-to-end responsibility for complex, enterprise-wide pipeline and reporting projects from design through production support.

• Communication Skills — ability to explain technical architecture, project updates, and data issues clearly to audiences with varying levels of technical knowledge.

• Tec

Similar jobs

• Business Intelligence Delivery Manager — AIG · NJ-Jersey City
• Sr. BI Developer — Helenoftroy · Remote
• Business Intelligence Cnslt — Austintexas · Austin Energy Headquarters
• Sr. BI Engineer — Myfitnesspal · Remote
• Principal Business Intelligence Manager — Zillow · Remote
• Business Intelligence Developer — Bloomberg · Arlington, VA - 1801 S Bell (INDG)
• Business Intelligence Developer — Auto-Owners Insurance · Lansing, MI
• Senior BI Analyst — Torcrobotics · Remote