Tolling Business Intelligence Developer I

This opportunity entails being responsible for supporting the development of business intelligence solutions by designing reports, writing queries, and assisting in data modeling and visualization. You will work with structured data to build dashboards and support decision-making processes. This role focuses on developing foundational skills in BI tools, SQL, and data storytelling while working in a collaborative environment.

Additionally, this position is responsible for providing toll technology support and analysis at a base or intermediate level. Supports implementation and operations for HNTB clients and offices. Provides support during phases of toll revenue collection system and operations life cycle from assessing current state to planning for the future. Provides assistance and supports the process from developing concept of operations through procurement of systems and services, and subsequently during operations.

Other essential functions include:

• Supports planning activities such as assisting in the development of feasibility studies, assessments, concept of operations documents, procurement documents, implementation planning documents, and business/data analysis to support ongoing operations.

• Assists with toll system implementation including support for oversight of design, testing, installation.

• Supports project control activities related to toll projects, including schedule management, document management, version control, etc. May provide general analysis for cost estimates or other projections such as project analyst tasks including supporting project budgets (internal or for client), project status, and general support.

• May assist with toll system implementation including support for oversight of design, testing, installation, and operations.

• Develop, maintain, and optimize Python-based ETL processes to support automated data integration, transformation, and reporting.

• Develop and maintain C# applications, websites, system integrations, and database solutions, including troubleshooting, enhancements, and ongoing system support.

What You'll Do:

• Develops and maintains basic BI reports and dashboards using tools like Power BI or Tableau.

• Writes SQL queries to extract and transform data from relational databases.

• Assists in building and maintaining data models and data warehouse structures.

• Collaborates with analysts and business users to understand reporting requirements.

• Documents data sources, report logic, and technical processes.

• Learns and applies best practices in BI development and data visualization.

• Performs other duties as assigned., HNTB will recruit, hire, train, and promote individuals in all job titles, and will ensure that all other personnel actions are administered, without regard to an individual's protected veteran or disability status. All employment decisions will be based only on valid job requirements. In addition, employees and applicants shall not be subjected to harassment, intimidation, threats, coercion, or discrimination because they have engaged in or may engage in any of the following activities: (1) filing a complaint; (2) assisting or participating in an investigation, compliance evaluation, hearing, or any other activity related to the administration of any Federal, State, or local law requiring equal opportunity for protected veterans or individuals with disabilities; (3) opposing any act or practice made unlawful by Section 4212, Section 503, their implementing regulations, or any other Federal, State, or local law requiring equal opportunity for protected veterans or individuals with disabilities; or (4) exercising any other right protected by Section 4212, Section 503, or their implementing regulations.

The non-confidential portions of the affirmative action program for protected veterans and individuals with disabilities shall be available for inspection upon request by any employee or applicant for employment. These plans are available for review upon request during normal business hours. Any questions or requests to review should be directed to your Human Resources Partner.

As Chief Executive Officer, I fully support our affirmative action program and am committed to the implementation of the company's affirmative action policy. I have delegated overall responsibility for this policy to the Business Integrity Director. The Manager of HR Compliance & Immigration is responsible for the implementation, auditing, and reporting of this policy and program, assisted by the office's Human Resources Partner.

HNTB employees must comply with this policy and report any violations of illegal discrimination, as specified in the Integrity Reporting policy.

• Bachelor's degree in computer science or related field, or

• In lieu of education, 4 years of relevant experience.

What You'll Bring:

• Familiarity with SQL, SSIS, SSRS, SSAS, and Power BI or Tableau.

• Understanding of ETL processes and data modeling concepts.

• Strong analytical and communication skills.

What We Prefer:

• Master's degree in computer science

At HNTB, you can create a career that is meaningful to you while building communities that matter to all of us. For more than a century, we have been delivering solutions for some of the largest, most complex infrastructure projects across the country. With our historic growth, it is an exciting time to join our team of employee-owners., HNTB has implemented the following policy as part of its longstanding commitment to compliance with all applicable affirmative action requirements. HNTB agrees to post in conspicuous places, available to employees and applicants for employment, this Affirmative Action Policy. HNTB is a federal contractor subject to Section 4212 of the Vietnam Era Veterans' Readjustment Assistance Act of 1974, as amended ("Section 4212") and Section 503 of the Rehabilitation Act of 1973, as amended ("Section 503"). Accordingly, it is HNTB's policy to take affirmative action to employ and advance in employment protected veterans (disabled veterans, recently separated veterans, Armed Forces Service Medal veterans, or active-duty wartime or campaign badge veterans) and individuals with disabilities at all levels of employment, including the executive level. HNTB also will provide reasonable accommodation to known physical or mental limitations of an otherwise qualified employee or applicant for employment with a disability, unless the accommodation would impose undue hardship on the operation of HNTB. In order to request a reasonable accommodation, employees should contact the HR Solutions Center at General Policy Inquiry - Employee