IT BI Manager

TTI Consumer Power Tools, Inc.; United States; On-site; USD 120,000 - 160,000; Full time

Job summary

TTI Consumer Power Tools, Inc. seeks an IT BI Manager to lead enterprise analytics and AI-enabled reporting. You will own data pipelines, semantic models, and governance while partnering with the DAIE team to deploy AI-enabled solutions across the organization.

Responsibilities include designing scalable data architectures, building Power BI dashboards, and mentoring the DAIE team to mature dbt and Snowflake practices. Strong SQL, Power BI, and governance experience are required.

Qualifications

• Proficiency with SQL for reporting, analytics and data preparation.
• Proficiency with Power BI for report and dashboard development.
• Experience with AI coding agents and AI-enabled business tools (e.g., GitHub Copilot, Snowflake Cortex Analyst/Agents).
• Experience applying data governance principles and establishing single-source-of-truth architectures.
• Project management experience coordinating complex multi-phase initiatives.
• Experience with Snowflake and dbt are strongly preferred.
• Knowledge of Python for automation scripts and integrations.

Responsibilities

• Plans, sequences, and delivers complex, multi-phase data analytics initiatives.
• Partners with business units to gather requirements and translate needs into scalable pipelines and reporting architectures.
• Implements AI-enabled solutions (Snowflake Cortex Analyst/Agents, Copilot) for business use.
• Ensures scalable, secure, enterprise-aligned solutions with IT and security teams.
• Develops advanced data models (dimensional, semantic, predictive) for enterprise analytics.
• Champions single-source-of-truth data architectures and consolidates reports.
• Establishes data governance, quality, access controls, and documentation.
• Writes and optimizes complex SQL queries for data access and transformation.
• Builds and maintains Power BI reports, dashboards, and semantic models.

Skills

Project management

Stakeholder collaboration

AI-enabled solutions

SQL

Power BI

Data governance

Data modeling

Snowflake Cortex

dbt

Python

Azure Data Factory

Docker

Kubernetes

Copilot agents

Education

Bachelor’s degree in CS/Data Engineering/ related field

Master’s degree (preferred)

Tools

Snowflake

dbt

GitHub Copilot

Power BI

Azure Data Factory

Docker

Kubernetes

Job description

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%

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.
• Technical Curiosity — genuine interest in emerging data engineering tools, automation, AI-assisted development, and evolving best practices; willingness to learn quickly and apply new capabilities.

EDUCATION AND EXPERIENCE

• Bachelor’s degree along with 5–10 years of relevant experience in data engineering, analytics, or a related field is preferred; 3–5 years of experience is acceptable for candidates holding a bachelor’s degree in computer science, data engineering, or a closely related discipline. Master’s degree is a plus.
• Proficiency with SQL is required, including the ability to write, troubleshoot, and optimize complex queries for reporting, analytics, and data preparation.
• Proficiency with Power BI is required, including report and dashboard development, data modeling, and DAX in a business setting.
• Experience with advanced data modeling techniques — such as dimensional modeling, semantic modeling, or predictive/statistical modeling — and building single-source-of-truth data architecture is required.
• Experience using AI coding agents and AI-enabled business tools (e.g., GitHub Copilot, Snowflake Cortex Analyst/Agents, Copilot agents, or similar conversational/agentic solutions) is required.
• Experience applying data governance principles (e.g., data quality standards, access controls, documentation practices) is strongly preferred.
• Project management experience or demonstrated ability to plan and coordinate complex, multi-phase technical initiatives is strongly preferred.
• Experience with Snowflake and dbt is strongly preferred.
• Experience with Python is preferred, including the ability to build, test, and maintain automation scripts and integrations.
• Experience with Azure Data Factory, Docker, Kubernetes, and Prefect (or similar orchestration tools) is a plus.
• Ability to manage multiple priorities across enterprise-wide initiatives while maintaining consistent, high-quality technical delivery.
• Strong verbal and written communication skills with the ability to manage multiple priorities and perform well under pressure.
• Ability to work independently and as an integral part of a cross-functional team, acting as a collaborative team player and mentor to others.

OTHER REQUIREMENTS

• Ability to travel (post-COVID) up to 10%.
• It is anticipated this position will travel 0-10%.

PHYSICAL REQUIREMENTS

PHYSICAL REQUIREMENTS: if applicable, select one & change pounds Prolonged periods of sitting at a desk and working on a computer. Must be able to lift up to 30 pounds at times.

TTI is a world-class leader in design, manufacturing and marketing of Power Tools, Hand Tools, Outdoor Power Equipment, and Floor Care and Appliances for consumers, professional and industrial users in the home improvement, repair and construction industries. Our unrelenting strategic focus on Powerful Brands, Innovative Products, Operational Excellence and Exceptional People drives our culture. TTI was founded by Mr. Horst Julius Pudwill and Prof. Roy Chi Ping Chung BBS JP in 1985, yet the history of TTI's unique and growing portfolio of world-famous brands stretches back at least one hundred and fifty years. Through a clear and consistent strategy of acquiring and developing established brands, TTI has grown to become a clear market leader in power tools, outdoor power equipment, hand tools and floor care appliances worldwide. TTI is proud of its own history, and proud, too, of the huge legacy of tradition and excellence that we have inherited from the brands that make up our Company today. TTI actively promotes a strong corporate culture of respect and ethical integrity. Our Values are our beliefs, principles and standards that do not change over time. Values are the resources we draw on when asked to make decisions. They form the groundwork for our ethical behavior. All that we do at TTI must be consistent with the values to which we subscribe.