Sr Business Intelligence Engineer(Promo Analytics)

Milwaukee Tool•Menomonee Falls, WI

About The Position

Senior Business Intelligence Engineer Applicants must be authorized to work in the U.S.; Sponsorship is not available for this position. INNOVATE without boundaries! At Milwaukee Tool, we firmly believe that our People and our Culture are the secrets to our success — so we give you unlimited access to everything you need to make a meaningful impact. Behind our doors, you’ll be empowered every day to own it, drive it, and do what it takes to support the biggest breakthroughs in the industry. Meanwhile, you’ll have the support and resources of the fastest-growing brand in the construction industry to make it happen. Your Role on Our Team: As a Senior Business Intelligence Engineer, you will design and deliver analytics products that enable the business to plan, execute, and measure promotions with confidence. You’ll partner closely with Pricing, Sales, Channel Marketing, and Finance to translate business needs into scalable models and visualizations, and ensure consistent, reliable access to trusted data. This role is hands-on and end-to-end: sourcing and modeling promotional data (e.g., promo calendars, promotional pricing, POS sell-through, and forecast/actual performance), building pre- and post-promotion analysis, and helping stakeholders understand promotional lift, ROI, and performance drivers. This role emphasizes strong technical craftsmanship, business acumen, and a growing ability to mentor others and drive data culture.

Requirements

Education: Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or related field (or equivalent experience).
Years of Experience: 5+ years of experience in BI development, analytics engineering, or data visualization roles.
BI Tool Expertise: Deep experience with Power BI (DAX, dataflows, dataset management), and familiarity with Tableau or Looker a plus.
Promotions & Pricing Domain Expertise: Demonstrated experience analyzing promotional data (promo events, promotional pricing, promo calendars) and communicating results to business partners.
Retail POS & Market Data Experience: Experience working with multiple forms of retailer POS data and syndicated data sources such as vendor drill, IRI, NPD, Stackline, etc.
SQL & Data Modeling: Strong skills in SQL (window functions, CTEs, performance tuning), and experience building star/snowflake schemas.
Cloud & Data Platforms: Experience with cloud environments such as Azure, Snowflake, or Databricks for data transformation and modeling.
DevOps & Version Control: Familiarity with Azure DevOps, Git, and automated deployment processes for BI solutions.
Storytelling & Insight Delivery: Ability to frame insights clearly using compelling visuals and narratives tailored to business audiences.
Business Acumen: Demonstrated understanding of how BI solutions impact decision-making and drive value.

Nice To Haves

Experience with Azure DevOps: Familiarity with Azure DevOps for managing workflows, integrating with Power BI, and streamlining project pipelines.
Knowledge of Power Automate: Ability to use Power Automate to enhance reporting processes by automating repetitive tasks and improving data workflows within the Microsoft ecosystem.
Data Governance Tools: Familiarity with tools like Databricks Unity Catalog or Azure Purview for managing data governance, lineage, and quality across the organization’s data assets.
Custom Visuals in Power BI: Experience creating or implementing custom visuals in Power BI to deliver more tailored and impactful reports.
Basic Python Skills: General knowledge of Python for enhancing data workflows or performing advanced analytics when needed.
Experience with Business Systems: Demonstrated experience working with enterprise platforms such as Oracle, SAP, POS systems, demand planning tools, supply chain execution systems, and general ledger or ERP systems to extract, model, and analyze data for reporting, operational performance, and strategic planning.

Responsibilities

Promotion Performance Measurement: Quantify lift, cannibalization, halo, and ROI using POS and sales data; define KPI/metric logic that becomes the single source of truth.
Promotional BI Development: Build and maintain a promotions reporting suite (scalable models, dashboards and reporting) including pre-promo readiness/forecast views and post-promo performance scorecards.
Collaborative Requirements Gathering: Partner with business users to translate analytics needs into data models and visualization requirements.
Semantic Layer and Data Modeling: Develop curated promotion-centric data models that connect promotion events to items/SKUs, customers, channels, pricing, funding, and outcomes balancing performance, flexibility, and governance.
Root Cause Analysis & Troubleshooting: Investigate and resolve issues in data pipelines and reports, using structured problem-solving and root cause techniques.
Agile Project Execution: Participate in sprint planning, estimation, reviews, and retrospectives. Break down work into manageable deliverables aligned with business priorities.
Stakeholder Communication: Communicate insights, progress, and blockers clearly and regularly with cross-functional partners.
Data Governance & Security: Implement and uphold best practices around data stewardship, security, and role-based access controls.
Self-Service Enablement: Develop documentation, training materials, and reusable assets that support business user adoption and self-service analytics.
Mentorship & Coaching: Provide feedback to peers and junior engineers through code reviews and design discussions.
Develop AI Solutions: Apply AI-driven techniques for anomaly detection, data quality checks, and predictive insights within dashboards and reporting solutions.