Data Analyst

Data Analyst Westminster, CO Job Details Full-time $75,000 - $110,000 a year 1 day ago Benefits Paid holidays Disability insurance Health insurance Dental insurance Paid time off Employee assistance program Vision insurance 401(k) matching Qualifications Performance dashboard reports Data model design Dashboard development Stakeholder engagement Power BI Data Integration (Data management) Automation Data modeling projects Safety regulations Mid-level 3 years SQL Data quality management Analysis skills Usability Workplace health and safety regulatory compliance Excel formulas Power Pivot Ad-hoc reporting Stakeholder relationship building Excel data analysis Stakeholder management Database software proficiency

Full Job Description Job Title:

Data Analyst Company:

Loenbro, LLC Business Unit/Department:

People /

HR Location:

Westminster, on-site Reports to:

Human Resources Manager, Data Employment Type:

Full-Time FLSA Classification:

Exempt About Loenbro 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. At Loenbro, we don't just offer jobs—we build careers grounded in integrity, teamwork, excellence, and purpose. Join a team where your expertise is valued, your growth is supported, and your work helps maintain and enhance the critical infrastructure that powers communities across the nation. Job Summary We are seeking a Data Analyst with strong Excel and Power BI expertise to transform business data into actionable insights. This role will support business leaders by building dashboards, analyzing operational trends, and improving visibility into key performance metrics. The ideal candidate is analytical, detail-oriented, and comfortable working with large datasets, with the ability to translate data into clear visualizations and insights that support decision-making. This position sits at the mid-level of the analytics function, meaning the individual can independently manage analysis projects, build scalable dashboards, and partner with stakeholders to answer business questions. Essential Job Responsibilities Data Analysis & Reporting 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 Dashboard Development (Power BI) 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 Excel-Based Analytics 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 Data Integration & Management 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 Stakeholder Partnership Partner with operational leaders to define reporting requirements Translate business questions into analytical solutions Provide insights and recommendations that improve business performance

Minimum Qualifications Required:

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 Experience working with relational data and data modeling Ability to communicate insights clearly to non-technical stakeholders Strong problem-solving and analytical thinking skills

Preferred:

Experience with SQL or data querying Familiarity with Power Query or Power Pivot Experience integrating multiple data sources into Power BI Experience supporting operations, finance, or business performance reporting Physical Demands and Work Environment 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.

Work Environment:

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. Benefits Loenbro offers a competitive salary, comprehensive benefits package, and rewards to those who join our team: Medical, dental, and vision insurance 401(k) retirement plan with company match Paid time off (PTO) and holiday pay Life and disability insurance Professional development and training opportunities Employee assistance program (EAP) Benefits eligibility may vary based on employment classification and hours worked. Guided by Core Values (LEAD) , grounded in grit and a commitment to excellence , Loenbro betters our families, customers, and local communities. If you're ready to be part of a company that LEADS by: L iving with Integrity E xceeding Expectations A cting with Urgency D elivering Excellence …we want to hear from you. Loenbro is an Equal Opportunity Employer