Data Analyst

Loenbro is a trusted, long-term construction lifecycle partner to thousands of customers across the U.S. Our market spans all industries and our service offerings include Critical Electrical, Mechanical & Structural, Soft Crafts, Inspection, Underground Maintenance and Installation, and Fabrication. Our expertise lies in simplifying the complex and establishing long-standing relationships with our partners. We have a national presence but a local approach—every customer benefits from our capabilities and our care.

• Analyze operational and business data to identify trends, risks, and opportunities
• Build recurring and ad hoc reports to support business decision making
• Interpret large datasets and communicate findings clearly to stakeholders

• Design and maintain interactive Power BI dashboards
• Build data models, relationships, and visualizations
• Optimize dashboard performance and usability
• Ensure data accuracy and reliability across reporting assets

• Use advanced Excel techniques to manipulate and analyze datasets, including:
  • Pivot tables and pivot charts
  • Advanced formulas (INDEX/MATCH, XLOOKUP, SUMIFS, etc.)
  • Data cleaning and transformation
  • Large dataset management
• Automate reporting workflows where possible

• Work with multiple data sources to create unified datasets
• Maintain data integrity and documentation for reporting processes
• Collaborate with IT or data teams on data pipelines when needed

• Partner with operational leaders to define reporting requirements
• Translate business questions into analytical solutions
• Provide insights and recommendations that improve business performance

• 3–6 years of experience in data analytics, business intelligence, or similar roles
• Strong proficiency in Microsoft Excel (advanced functions required)
• Experience building dashboards in Power BI/Tableau
• Experience working with relational data and data modeling
• Ability to communicate insights clearly to non-technical stakeholders
• Strong problem-solving and analytical thinking skills

• Experience with SQL or data querying
• Vista/Trimble experience
• Familiarity with Power Query or Power Pivot
• Experience integrating multiple data sources into Power BI
• Experience supporting operations, finance, or business performance reporting
• Advanced statistical analysis capabilities - Predictive analytics 

The physical demands and work environment described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

• In office, controlled climate.

This role requires compliance with all applicable safety regulations, personal protective equipment (PPE) requirements, and Loenbro's Environmental Health and Safety (EH&S) policies.