5+ years of experience in Business Intelligence, Reporting, or Power BI roles
Proficient in Power BI Data Modeling, DAX, and SQL
Skilled in creating dashboards and data visualizations
Familiar with Data Warehouse and Data Engineering concepts
Capable of translating business needs into reporting solutions
Strong communication and problem-solving abilities
Experience with Microsoft Fabric, NetSuite, Salesforce, UKG, or Procore preferred
Background in the Construction Industry is a plus
Bachelor's degree in a STEM field or equivalent experience.
Responsibilities
Develop, maintain, and troubleshoot Power BI reports and dashboards
Gather and document reporting requirements from stakeholders
Build, test, and optimize DAX measures and visualizations
Validate and reconcile data across source systems
Analyze data to identify trends and communicate findings
Respond to ad hoc reporting requests and support end-user inquiries
Lead requirements-gathering and design sessions across departments
Champion data governance standards and practices
Advocate for a data-driven culture by surfacing insights proactively.
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!
Full Job Description
This position is based in Pontiac, Michigan and requires full on-site attendance.
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.
