Business Intelligence Analyst
Garver Business Intelligence Analyst
Position Overview
We are seeking a motivated Business Intelligence Analyst to join our growing analytics team. This role is designed for someone who is eager to build hands-on experience with modern data visualization and analytics tools on real infrastructure projects.
Working under the direction of senior developers and the Business Analytics Manager, you will help build and maintain Power BI reports and dashboards, prepare and validate data from a variety of source systems, and support client deliverables. We are looking for strong fundamentals, attention to detail, and genuine curiosity.
Key Responsibilities
Report and Dashboard Development
- Build and maintain Power BI reports and dashboards under the direction of senior team members, following established team standards for data modeling and design.
- Write and troubleshoot SQL queries to extract, join, and validate data from client and internal source systems.
- Assist in developing data models, measures, and calculated columns using DAX and Power Query.
- Apply design principles for layout, color, and readability so dashboards are clear, intuitive, and consistent with Garver standards.
- Support ongoing maintenance of existing reports, including scheduled refreshes, issue resolution, and enhancement requests.
Data Preparation and Quality
- Gather, clean, transform, and validate data from multiple sources, including spreadsheets, databases, ERP systems, project management platforms, and GIS data.
- Perform quality checks to confirm the accuracy and integrity of data and calculations before deliverables go to review.
- Document data sources, transformation logic, assumptions, and known limitations.
- Identify data discrepancies and anomalies, raise them promptly, and help research root causes.
Project and Client Support
- Complete assigned project tasks within budgeted hours and schedule, tracking your own progress and communicating status and obstacles early.
- Participate in requirements gathering sessions and client working meetings, capturing notes and documenting requests.
- Assist in preparing materials for client presentations, program reporting, and training sessions.
- Coordinate with engineering staff and project managers to understand the data behind the deliverable.
Learning and Development
- Build technical skills through mentoring, structured training, certifications, and hands-on project experience.
- Learn Garver's markets — transportation, aviation, water, buildings, and federal — and how analytics supports infrastructure planning and delivery.
- Contribute to team knowledge sharing, standards documentation, and process improvement ideas.
- Stay current on business intelligence and data visualization best practices.
Qualifications
- Bachelor's degree in Data Analytics, Information Systems, Computer Science, Business, Engineering, Mathematics, Statistics, or a related field.
- 1–3 years of professional experience in analytics, business intelligence, or a related role. Internships, co-ops, and substantial academic or personal projects count.
- Working knowledge of Power BI or a comparable data visualization tool such as Tableau.
- Foundational SQL skills, including the ability to write and modify queries with joins, filters, and aggregations.
- Proficiency with Microsoft Excel, including formulas, pivot tables, and working with large data sets.
- Strong attention to detail and a habit of checking your own work.
- Clear written and verbal communication skills, with the ability to ask good questions and explain what you built.
- Ability to take direction, manage assigned deadlines, and collaborate as part of a project team.
- Curiosity and a demonstrated willingness to learn new tools and subject matter.
Preferred Qualifications
- Project experience in business intelligence, data analytics, or reporting.
- Experience with DAX and Power Query/M.
- Exposure to data modeling concepts such as star schemas, relationships, and dimensional design.
- Familiarity with Python, R, or another scripting language for data preparation and analysis.
- Exposure to GIS tools such as ArcGIS, or interest in geospatial data.
- Interest in the civil engineering and infrastructure industry, particularly transportation, aviation, or water.
- An eye for graphic design and data storytelling.
- Familiarity with descriptive and diagnostic analytics, and interest in growing toward predictive and prescriptive work.
Grow With Us
Garver offers its employees programs such as company-paid professional memberships, company support for industry licenses and continuing education opportunities that foster a progressive atmosphere. Garver provides the tools, resources, and environment to develop leaders, stimulate ideas, and accomplish projects. By offering highly competitive salary packages, attractive benefits, and a comprehensive wellness program; Garver walks the talk when it comes to work-life balance.
Founded in 1919, Garver is an employee-owned engineering, planning, and environmental services firm focused on aviation, transportation, buildings, federal, water and wastewater services; surveying; advisory services; and construction engineering and inspection. In the top 100 of Engineering News-Record’s Top 500 Design Firms list, with more than 1,400 employees, Garver provides an exceptional level of client service that reflects our people-first culture, which has achieved Zweig Group Best Firm to Work For Legacy Status. Learn how Garver invests in people and places they call home at GarverUSA.com.
Garver is committed to providing equal employment opportunities to all applicants and employees. Our employment practices are based upon an individual's capabilities and qualifications without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status, or any other category protected by law.
#LI-SM1