Construction Data Analyst - Entry Level

The KENPAT, N-RG, and Architectural Glass, ELRO Companies are Industry-Leading, Integrated Specialty Subcontractors. We provide design assistance, manufacturing, and installation services for drywall, exterior envelope, commercial glazing, acoustical, and related construction products-delivering the highest level of safety, quality, reliability, and convenience for our customers. In doing so, we provide exceptional opportunities for the personal and financial growth of our employees, business partners, and shareholders. KENPAT stands ready to provide the highest service and skill for your next project.

Our Core Values:

• Customer Focus – Providing our customers with the highest level of service and reliability.
• Innovation – We search for new and better ways to improve our products, processes, and services.
• Integrity and Honesty – Integrity and honesty among our team members and in all of our dealings.
• Quality – The highest level of quality in all that we do.
• Safety – A working environment where all our employees return home safely daily.
• Teamwork – Working together, with our internal and external partners, as a team, in a caring, loyal, respectful, and professional manner while maximizing mutual success.

We are seeking a detail-oriented and process-driven Junior/ Entry Level Data Analyst to support our construction operations. This role involves managing project data, ensuring accurate time and attendance records, and assisting with project coordination. The ideal candidate will play a crucial role in ensuring data accuracy, creating insightful Power BI dashboards, and improving overall data management processes.

This position reports to the Business Intelligence Analyst and works closely with Project Managers and Superintendents to optimize project productivity and data

• Track manpower and project progress to meet goals and deadlines.
• Develop and maintain Power BI dashboards to visualize key performance indicators (KPIs) such as productivity and work-in- progress.
• Process and manage subcontractor pay certificates (pay certs), ensuring timely and accurate payments.
• Collaborate with teams to ensure the correct collection of data from various sources.
• Conduct data quality checks and troubleshoot discrepancies.
• Maintain employee database and verify accurate time entries.
• Review and resolve discrepancies in timesheets for timely wage processing.
• Input project data into Kenpat’s management software and resolve reporting issues.
• Assist in creating and updating dashboards for project tracking and performance analysis.
• Monitor project performance, track productivity with AI tools, and create weekly plans for crew and material management.
• Strong communication, organizational, and problem-solving skills.
• Ability to work under pressure, meet deadlines, and contribute to a collaborative team environment.
• Advanced proficiency in Microsoft Excel, including complex formulas, pivot tables, and macros.
• Strong experience in creating and managing dashboards in Power BI.
• Familiarity with data transformation tools and techniques.
• Excellent attention to detail and process-oriented thinking.
• Ability to analyze and interpret data to provide actionable insights.
• Experience in construction or a related industry is a plus.

Physical Requirements:

Prolonged periods of sitting at a desk and working on a computer.

Must be able to lift 15 pounds at times.

Must be able to access and navigate each department at the organization's facilities