Reporting Analyst

Aldridge Group•Green Oaks, IL

9d•$75,000 - $105,000

About The Position

Aldridge is seeking a Reporting Analyst to join its team in Libertyville, Illinois. The Reporting Analyst designs, builds, and maintains reports and dashboards used by operations and leadership teams, translating business data into clear, accurate, and actionable reporting. The role owns the reporting lifecycle, from gathering requirements and writing queries through visualization design and ongoing maintenance, and partners with IT and business stakeholders to support reliable, consistent reporting. The position supports operations, finance, and executive audiences. It includes creating and optimizing queries in SQL Server and BigQuery, maintaining report suites, validating data, automating report distribution and refreshes, troubleshooting issues, documenting report logic and sources, and fulfilling ad hoc requests. Aldridge describes its culture as collaborative, family-centered, and committed to innovation, safety, execution, and mental wellness. The company has more than 2,000 industry experts and works on energy and transportation infrastructure projects. The annual base pay range is $75,000 to $105,000. The role may also be eligible for a bonus. Aldridge offers a comprehensive benefits package. The listed duties are not exhaustive; employees may also perform occasional assignments, including temporary or training assignments and related duties.

Requirements

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.
Strong proficiency in SQL, including 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 and attention to detail and accuracy.
Excellent communication and relationship-building skills, including the ability to translate business needs into technical solutions.
Strong organizational and time-management skills and ability to manage multiple reporting requests and deadlines.
Ability to work in high-pressure situations.
Customer-service orientation and a strong sense of responsibility and accountability for assigned tasks and projects.

Nice To Haves

Experience in the construction industry is preferred.

Responsibilities

Design, develop, and maintain Tableau reports and dashboards for operations, finance, and executive audiences.
Write and optimize complex SQL queries against SQL Server and BigQuery to source, join, and aggregate data.
Gather and translate business reporting requirements into technical specifications.
Maintain and enhance existing report suites, validating and testing data accuracy.
Build and schedule automated report distribution and data refreshes.
Troubleshoot 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 align reporting data models 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, including occasional related, temporary, or training assignments.