Sr Reporting & Data Analyst

Lee Contracting; Pontiac (MI); On-site; USD 80,000 - 110,000; Full time

Benefits offered by this job

Health Insurance

Paid Holidays

HSA with Employer Contribution

Paid Time Off

Employee Stock Ownership Program

Holiday Bonus

Job summary

Lee Industrial Contracting in Pontiac, MI is seeking an experienced Business Intelligence professional to develop and manage Power BI reports and dashboards. You will gather requirements, build semantic models, and ensure data accuracy across sources to deliver actionable insights.

The role requires 5+ years in BI or Power BI, strong SQL/DAX skills, and the ability to translate business needs into reporting solutions.

Qualifications

• 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.

Responsibilities

• 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.

Skills

Power BI

DAX

SQL

Data Modeling

Data Visualization

Communication

Problem-Solving

Education

Bachelor's degree in Analytics/CS/IS or equivalent

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!

We Are Proud To Offer Our Employees

• 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!

What You'll Do

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.

What We're Looking For

• 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.

This job description reflects management’s assignment of essential functions, and nothing herein restricts managements right to assign or reassign duties and responsibilities to this job at any time.