Reporting AnalystWhat 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
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.
#LI-SW1
#LI-DNP
