Apply on Employer Site

Milwaukee Tool · 20 hours ago

Sr Business Intelligence Engineer(Promo Analytics)

Menomonee Falls, WI

Full-time

Onsite

Senior Level

5+ years exp

Milwaukee Tool is a leading brand in the construction industry, dedicated to innovation and empowering its employees. The Senior Business Intelligence Engineer will design and deliver analytics products to support promotional planning and execution, collaborating with various departments to ensure reliable access to data and insights.

Consumer GoodsElectronicsIndustrialManufacturingSoftware

Growth Opportunities

No H1B

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

Qualification

Power BISQLData ModelingPromotions & Pricing ExpertiseCloud PlatformsRetail POS ExperienceDevOps & Version ControlBusiness AcumenAgile Project ExecutionStakeholder CommunicationStorytelling & Insight DeliveryBasic Python SkillsMentorship & Coaching

Required

Applicants must be authorized to work in the U.S.; Sponsorship is not available for this position

Bachelor's degree in Computer Science, Information Systems, Data Analytics, or related field (or equivalent experience)

5+ years of experience in BI development, analytics engineering, or data visualization roles

Deep experience with Power BI (DAX, dataflows, dataset management), and familiarity with Tableau or Looker a plus

Demonstrated experience analyzing promotional data (promo events, promotional pricing, promo calendars) and communicating results to business partners

Experience working with multiple forms of retailer POS data and syndicated data sources such as vendor drill, IRI, NPD, Stackline, etc

Strong skills in SQL (window functions, CTEs, performance tuning), and experience building star/snowflake schemas

Experience with cloud environments such as Azure, Snowflake, or Databricks for data transformation and modeling

Familiarity with Azure DevOps, Git, and automated deployment processes for BI solutions

Ability to frame insights clearly using compelling visuals and narratives tailored to business audiences

Demonstrated understanding of how BI solutions impact decision-making and drive value

Preferred

Familiarity with Azure DevOps for managing workflows, integrating with Power BI, and streamlining project pipelines

Ability to use Power Automate to enhance reporting processes by automating repetitive tasks and improving data workflows within the Microsoft ecosystem

Familiarity with tools like Databricks Unity Catalog or Azure Purview for managing data governance, lineage, and quality across the organization's data assets

Experience creating or implementing custom visuals in Power BI to deliver more tailored and impactful reports

General knowledge of Python for enhancing data workflows or performing advanced analytics when needed

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