Associate Business Intelligence Specialist - Construction Industry

HKA is a global leader in risk mitigation, dispute resolution, and expert witness services. We tackle complex challenges with our multi-disciplinary expertise.

As trusted consultants and advisors, we deliver solutions in uncertain and disputed situations, ensuring the best outcomes for clients worldwide. Our experts have testified globally on major cases spanning across a wide range of industries and sectors.

As Part Of The HKA Team You Can Expect

• A strong collaborative culture with a mutual pursuit of your success alongside the success of our teams.
• The opportunity to solve problems creatively, contribute to our innovative direction, and be valued as an individual
• The ability to leverage HKA’s strong network and presence in various industries and reputation for exceptional expert witnesses to accelerate career development and connections.

The Opportunity:

HKA is seeking an Associate Business Intelligence Specialist to join our growing data and technology team that supports PMWeb, a leading construction program and project management platform used on large, complex capital programs worldwide.

This role is designed for an early‑career professional who is strong in SQL and relational data concepts and wants hands‑on experience building real reporting and data solutions for live client environments. You will work closely with experienced BI Developers, Data Engineers, and Implementation Consultants to translate business and project controls needs into reliable database objects, reports, and dashboards.

This is a growth‑oriented role. As your technical foundation develops, you will have the opportunity to deepen your expertise and progress toward more advanced work in data engineering, systems integrations, or Power BI development, depending on your interests and strengths.

Responsibilities

Working as part of a collaborative delivery team, responsibilities include:

• Build, maintain, and enhance SSRS reports against the PMWeb SQL Server database, translating functional requirements into accurate, well‑structured reporting outputs.
• Develop and optimize SQL database objects including views, stored procedures, functions, and triggers to support client‑specific reporting, workflows, and integrations.
• Partner directly with implementation consultants and, as appropriate, client stakeholders to clarify requirements, troubleshoot issues, and communicate technical solutions.
• Manage assigned work queue items with increasing independence, including estimating effort, meeting deadlines, and owning quality of deliverables.
• Participate in solution design discussions, contributing ideas around data structure, performance, and scalability as technical experience grows.
• Follow internal standards for code quality, documentation, and deployment to ensure consistency across client environments.

As experience increases, the role may expand into one or more of the following areas:

• Scripting & Integrations: Supporting data exchanges between PMWeb and external systems using SQL, PowerShell, and REST APIs.
• Data Engineering: Assisting with the design and development of dimensional models and data warehouse layers, including work within Microsoft Fabric–based architectures.
• Power BI Development: Designing and delivering Power BI datasets, reports, and dashboards that surface actionable insights for project and executive stakeholders.

Qualifications and Experience:

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field preferred; equivalent practical experience will also be considered.
• Strong working knowledge of SQL, including joins, aggregations, subqueries, and an understanding of relational database design principles.
• Ability and willingness to learn new technologies, tools, and client environments in a consulting setting.
• Clear written and verbal communication skills, with the ability to explain technical concepts to non‑technical audiences.
• Strong organizational skills with the ability to prioritize and manage multiple tasks concurrently.
• Attention to detail and a commitment to producing accurate, high‑quality work.
• Ability to take guidance while progressively working more independently.
• Exposure to SSRS, Power BI, PowerShell, or Python is a plus but not required.

What We Offer

Compensation - HKA offers a salary range of $75,000 - $92,500 for this role depending upon skills, qualifications and overall evaluated fit. We also offer eligibility for our full benefits package including but not limited to health/dental/vision insurance, 20 days pto + holidays + wellness days, retirement plan with company match and much more.

At HKA we recognize that our people are critical to our ongoing success. Our priority is to provide an inclusive and collaborative culture aimed at providing the best opportunities for our people to thrive and develop in their chosen career path.

Our Global Recruitment team is committed to providing an authentic candidate experience for all those who take the time to apply to HKA. We are committed to providing an efficient and insightful recruitment process giving candidates a true reflection of life at HKA.

Fairness And Equality At HKA

HKA works hard to provide a welcoming environment for all of our employees. We are committed as a business on the continued improvement of our fairness and equality strategy. Please visit our careers page for further information or feel free to ask our recruitment team for further information.

All HKA employment decisions shall be made in accordance with controlling laws and based on merit.

Stay Alert: Protect Yourself from Phishing Scams

Please be aware that HKA only publishes official job postings on our website (Join Us | HKA) and on verified job boards. We will never ask for sensitive personal information during the job application process. If you have any doubts, we recommend you visit our website to verify job listings before applying. If you would like more confirmation, please feel free to email us at [email protected] to check the authenticity of a job posting.