Reporting Analyst

What we are looking for

Aldridge is seeking an Reporting Analyst to join our dynamic and energetic team in Libertyville, IL.

The Reporting Analyst will design, build, and maintain the reports and dashboards that operations and leadership teams rely on daily, translating raw data from across the business into clear, accurate, and actionable reporting. This role owns the reporting lifecycle end to end — from gathering requirements and writing the underlying queries, to designing the visualization and maintaining it over time — and works closely with IT and business stakeholders to keep reporting reliable and consistent.

What You'll Do

• Design, develop, and maintain reports and dashboards in Tableau for operations, finance, and executive audiences.
• Write and optimize complex SQL queries against SQL Server and BigQuery to source, join, and aggregate data for reporting.
• Gather and translate business reporting requirements into clear technical specifications.
• Maintain and enhance existing report suites, ensuring data accuracy through routine validation and testing.
• Build and schedule automated report distribution and data refreshes.
• Troubleshoot and resolve report and dashboard issues, including data discrepancies and performance bottlenecks.
• Document report logic, data sources, and definitions to support consistency and knowledge transfer.
• Partner with data and IT teams to ensure reporting data models align with source systems and integrations.
• Apply data-visualization best practices to make reports intuitive and easy to interpret.
• Fulfill ad-hoc reporting requests from operations and leadership teams.
• Perform other duties as assigned and directed.

Who You Are

• Bachelor's degree in Data Science, Computer Science, Information Systems, or a related field; OR equivalent experience
• Proven experience as a Reporting Analyst, BI Developer, or Data Analyst, preferably in the construction industry
• Strong proficiency in SQL, with hands-on experience writing and tuning queries in SQL Server and BigQuery
• Demonstrated experience building and maintaining reports and dashboards in Tableau
• Solid understanding of relational data models, joins, and data validation techniques
• Strong analytical skills with attention to detail and accuracy
• Excellent communication and relationship-building skills, with the ability to translate business needs into technical solutions
• Strong organizational and time-management skills, with the ability to manage multiple reporting requests and deadlines
• Ability to work in high-pressure situations
• Customer-service orientation with a strong sense of responsibility and accountability for assigned tasks and projects

Who we are

At Aldridge, we invite you to be a part of our dynamic team, where your skills are not only valued but crucial to our success. As we pursue our vision to be the First Choice for Energy and Transportation infrastructure projects, we welcome fresh perspectives and prioritize teamwork to drive our industry-leading safety, innovation, and execution.

Our culture is rooted in family-centeredness, with third-generation leadership guiding our unwavering spirit of innovation and entrepreneurship. With over 2,000 industry experts dedicated to our vision, we actively contribute to and uplift the communities impacted by our infrastructure projects and our Aldridge family.

Built on collaboration and a commitment to mental wellness, our core values create an unparalleled sense of unity and camaraderie within our organization. Through team-building events, open-door policies, and visible executive presence, we foster an environment where everyone can thrive, innovate, and make a meaningful difference. Join us in building the infrastructure that keeps the world moving and connected – become a part of the A-team to start building and strengthening your career today!

What we offer

The annual base pay for this role is between $75,000.00 - 105,000.00. The actual pay is dependent upon many factors, including: location, work experience, education, training, transferable skills, business needs, and market conditions. The base pay range is subject to change and may be modified in the future. The role may also be eligible for a bonus. Aldridge provides a comprehensive benefits package that includes the following:

Health Insurance

Dental Insurance

Vision Insurance

Wellness Incentive Programs

Short and Long Term Disability

Flexible Spending Accounts

Life Insurance

Legal Assistance

Identity Protection

Accident & Critical Illness Insurance

Company 401(k) Matching Contributions

Paid Time Off (PTO)

Employee Assistance Program (EAP)

This job-specific task list covers only the most important job duties. Employees assigned to this position title will also perform other occasional work assignments not mentioned above, including temporary assignments, training assignments, and other related duties. Aldridge is an EEO Employer and will recruit, hire, train, and promote people in all job classifications without regard to race, color, national origin, age, religion, disability status, gender, sexual orientation, gender identity, genetic information, veteran status, marital status, or any other characteristic protected by law.

#LI-SW1

#LI-DNP