Associate Business Intelligence Specialist - Construction Industry

HKA Global•Las Vegas, NV

About The Position

HKA is seeking an Associate Business Intelligence Specialist to join their growing data and technology team. This role supports PMWeb, a leading construction program and project management platform. The position is designed for an early-career professional with strong SQL and relational data concepts, offering hands-on experience in building reporting and data solutions for live client environments. The specialist will collaborate with experienced BI Developers, Data Engineers, and Implementation Consultants to translate business needs into database objects, reports, and dashboards. This is a growth-oriented role with opportunities to advance in data engineering, systems integrations, or Power BI development.

Requirements

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.

Nice To Haves

Exposure to SSRS, Power BI, PowerShell, or Python is a plus but not required.

Responsibilities

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.