Associate Business Intelligence Specialist - Construction Industry

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., 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.

Do you have experience in Scalability?, Do you have a Bachelor's degree?, * 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.

3.93.9 out of 5 stars 3721 Douglas Bl, Roseville, CA 95661 Hybrid work $75,000 - $92,500 a year, Pulled from the full job description

• Health insurance
• Retirement plan
• Paid time off
• Vision insurance
• Dental insurance, 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.

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.