Business Intelligence Analyst
Campbellsport • Information Technology
Job Type
Full-time
Description

*THIS IS NOT A REMOTE POSITION. ROLE WILL BE BASED OUT OF  CAMPBELLSPORT, WI. THIS ROLE DOES NOT SUPPORT SPONSORSHIP.*


The Drexel Way:

We don’t just sell lumber; we Supply. Happiness. Drexel is Team Member-owned and community-driven. With six retail hubs and three manufacturing plants across Wisconsin, we’ve been a Top Workplace every year since 2011 (and a USA Top Workplace in 2023!). Why? Because we hire for heart and train for skill. When you join Team Blue, you aren't just a team member—you’re an owner. We live and operate around our 11 core values, which form the DNA of our success.


The Mission:

As our Business Intelligence Analyst, you won’t just be sitting behind the scenes writing queries; you will be an active, collaborative partner to teams across the company. You will work directly with department leaders and end users to understand their challenges, translate business needs into technical specifications, and deliver reliable, high-impact data solutions from concept to completion. You will own the entire solution lifecycle: gathering requirements, designing data models, building pipelines, and rigorously testing and validating reports before they hit the business.


Defining the Role:
  • Partner Directly with the Business: Work cross-functionally with team members and leaders to gather requirements, uncover core business needs, and define project scope.
  • End-to-End Solution Ownership: Lead initiatives through the complete lifecycle: requirement gathering, architectural design, build, thorough data testing, and final validation with stakeholders.
  • ETL & Data Transformation: Design, automate, and optimize robust ETL/data pipelines using tools like EasyMorph and SQL to ensure clean, consistent data flow across systems.
  • Visualization & Reporting: Build, maintain, and enhance interactive, user-friendly dashboards and reports in PowerBI and our ERP that drive informed operational decisions.
  • Data Quality & Validation: Own data integrity by implementing validation checks and testing protocols, ensuring reports are accurate and dependable.
  • Translate Technical to Plain English: Communicate complex technical concepts clearly and approachably to non-technical team members, fostering strong collaboration and trust.
What Success Looks Like: 

Performance is measured by your direct impact on data reliability, pipeline efficiency, and stakeholder enablement:

  • Data Integrity: Maintaining a relentless standard for testing, QA, and validation so business reports are accurate every time.
  • User Adoption: Delivering highly utilized, user-friendly dashboards that actively drive daily business decisions.
  • Pipeline Stability: Ensuring automated ETL workflows run efficiently and consistently across systems.
  • Project Execution: Successfully shepherding data requests from initial stakeholder scoping through successful rollout.
The Essentials:
  • Proven Experience: Demonstrated background in data engineering, data modeling, ETL pipeline development, and database management.
  • Core Technical Stack: High proficiency in strong SQL skills (querying, stored procedures, joins, performance tuning), and hands-on experience with visual ETL/data preparation tools and data modeling, dashboard creation. Our current stack includes EasyMorph and PowerBI, though we welcome candidates with transferable experience in comparable tools who are eager to learn our environment.
  • Full-Lifecycle Execution: Experience gathering business requirements directly from end users and carrying projects through build, testing, user acceptance, and rollout.
  • Relentless Attention to Detail: A high standard for data accuracy and validation.
  • Communication & Problem-Solving: A proactive self-starter who looks at problems holistically, seeks root causes, and builds trusted relationships across departments.
  • End-to-End Project Ownership: Proven ability to project-manage data initiatives from start to finish—scoping requirements, managing timelines, leading the build, and driving final stakeholder rollout. 
  • Team Flexibility & Support: Pitch in on special projects, cross-departmental initiatives, and other duties as assigned to help support your fellow team owners. 
The Drexel Advantage:

The Wealth-Builder (Ownership)

  • ESOP Shares: We don’t just work here; we own the place. You’ll earn a real stake in the company’s success.
  • Profit Sharing: When Drexel wins, our team wins.
  • 401(k): A solid foundation for your long-term retirement goals.

Health & Well-Being

  • Comprehensive Coverage: Medical, Dental, and Vision insurance to keep you and your family "weather-proof."
  • Fitness Reimbursements: Annual funds dedicated to your physical health and family activities.
  • Employee Assistance Program (EAP): Confidential support when life gets complex.

Life & Legacy

  • Immediate Paid Time Off: Start with Holiday and Vacation pay from day one.
  • Scholarship Program: We’re invested in the next generation—educational support for the children of our team members.
  • Annual Charity Match: We’ll double your impact on the causes you care about most.

The "Drexel" Lifestyle

  • Birthday PTO: A paid day off to celebrate you.
  • Product Discounts: Special pricing on the high-quality materials we sell.
  • Plus More: A constant stream of "fun little perks" that make Drexel a great place to work!

PM85