Sr Reporting & Data Analyst at Lee Contracting in Pontiac, MI
- Company: Lee Contracting
- Location: Pontiac, MI
- Posted: Sep 21, 2026
- Type: Full-time
- Experience: 5+ years
Overview
This position is based in Pontiac, Michigan and requires full on-site attendance. Founded in 1989, Lee Industrial Contracting is a 100% employee-owned company based in Pontiac, Michigan. We are the premier industrial contractor of choice for a broad variety of equipment installation, construction, a…
Job description
- This position is based in Pontiac, Michigan and requires full on-site attendance.
- Founded in 1989, Lee Industrial Contracting is a 100% employee-owned company based in Pontiac, Michigan. We are the premier industrial contractor of choice for a broad variety of equipment installation, construction, and service projects. As employee-owners, we all strive to demonstrate the core values of Safety, Teamwork, Integrity, and Dedication each and every day. As a team, our mission is to provide our customers with the finest people, material, and equipment available. We encourage anyone who shares our values to apply today!
Responsibilities
- Daily & Operational
- This is an on-site position in Pontiac, MI
- Remote and hybrid arrangements are not available
- Develop, maintain, and troubleshoot Power BI semantic models, reports, and dashboards, monitoring scheduled refreshes and resolving data or performance issues as they arise.
- Gather and document reporting requirements from business stakeholders, translating them into clear specifications for new or updated reports.
- Build, test, and optimize DAX measures, calculated columns, KPIs, and visualizations for accuracy, performance, and usability.
- Validate and reconcile data across source systems to ensure reports remain accurate, timely, and trustworthy.
- Analyze data to identify trends, anomalies, and business opportunities, and communicate findings in a clear, actionable format.
- Respond to day-to-day ad hoc reporting requests and support end users with reporting questions, access issues, and troubleshooting.
- Leadership & Collaboration
- Serve as the go-to subject matter expert for Power BI and reporting best practices, mentoring less experienced analysts and business users on data modeling and report design.
- Partner with IT and Business Systems teams to improve, automate, and govern reporting capabilities, including data source integration and semantic model architecture.
- Lead requirements-gathering and design sessions with business leaders across departments, balancing competing priorities and setting realistic timelines for deliverables.
- Develop and deliver training and documentation to help business users interpret dashboards, self-serve on reporting tools, and adopt data-driven practices.
- Strategic & Continuous Improvement
- Define and evolve the roadmap for enterprise reporting and analytics, aligning Power BI and Microsoft Fabric initiatives with broader business goals.
- Establish and champion data governance standards, including naming conventions, security roles, and consistent metric definitions across reports.
- Identify opportunities to consolidate, automate, and modernize legacy reporting processes, reducing manual effort and improving data reliability.
- Evaluate emerging tools and capabilities within the Microsoft data ecosystem and recommend adoption where they add business value.
- Advocate for a data-driven culture by proactively surfacing insights and recommendations to leadership, rather than waiting for requests.
Requirements
- 5+ years of Business Intelligence, Reporting Analyst, or Power BI experience.
- Strong Power BI Data Modeling, DAX, and SQL Skills.
- Experience creating dashboards and data visualizations.
- Understanding of Data Warehouse and Data Engineering concepts.
- Ability to translate business needs and questions into reporting solutions.
- Strong communication and problem-solving skills.
- Experience with Microsoft Fabric, NetSuite, Salesforce, UKG, or Procore is a plus.
- Construction, manufacturing, industrial services, engineering, or project-based industry experience strongly preferred.
- Bachelor's degree in Analytics, Computer Science, Information Science, or a related STEM field, or equivalent experience in a related field.
Skills
Required
- Power BI Data Modeling
- DAX
- SQL
- Data visualization
- Data Warehouse concepts
- Data Engineering concepts
- Communication
- Problem-solving
Preferred
- Microsoft Fabric
- NetSuite
- Salesforce
- UKG
- Procore
Benefits
- Apprenticeship and Comprehensive Training Programs
- Paid Holidays Upon Hire
- Competitive Medical, Dental, and Vision Insurance
- HSA with Employer Contribution
- Paid Time Off
- Company Paid Short-Term Disability & Life Insurance
- Employee Stock Ownership Program
- Holiday Bonus
- And so much more!