CONTRACT ADMINISTRATOR (Capital Projects Data Analytics)

POSITION OVERVIEW

Applications Accepted from:  All Persons Interested
Job Title: Contract Administrator – Data Analytics 

Division:  Design & Construction
Location:  900 Bagby, Houston, Tx*
Workdays & Hours:  Monday - Friday, 8am – 5pm *Subject to change*
 
DESCRIPTION OF DUTIES/ESSENTIAL FUNCTIONS

The General Services Department is looking for a creative, enthusiastic, self-directed, and organized Contract Administrator. This role requires strong analytical thinking and proficiency with a range of data tools.  The Capital Projects Contract Administrator performs professional level data analysis and contract administration duties.  Candidates should possess a thorough understanding of contracts, demonstrate strong communication and coordination skills and the ability to develop and implement processes. The selected candidate will perform professional data analysis and process implementation in Capital Projects contracts as well as monitor and resolve problems and disputes related to compliance with contracts.   This role will optimize project performance, ensuring timely and cost-effective project completion.  The ideal candidate will have experience developing Power BI dashboards from scratch, including data modeling and visualization, as well as creating solutions using other Microsoft Power Platform apps, such as Power Apps and Power Automate.

This position will be responsible for the following duties:

RESPONSIBILITIES/DUTIES

• Develop and implement processes and procedures for capital projects management.
• Create procedures, checklists, and templates for the Design & Construction Division.
• Utilize Power BI and Power Apps to create dashboards and tools that support processes and procedures.
• Track project-related data and produce regular reports on project status, timelines and key metrics.
• Draft and review Request for Council Actions (RCAs), Request for Proposal (RFP and RFQ) packets for the solicitation of vendors, contract amendments, Ordinances, Professional Services Contracts and Construction Contracts.
  • Identify opportunities for process improvement and contribute to continuous enhancement of analytics practices.
  • Review the work of others to check for errors and omission of information.
  • Reviews and approves progress payments and other disbursements.
  •  Follow-up with management on contract compliance issues.
  • Reviews and verifies insurance and bond documents for city contracts. 
  • Works with Finance Department and other City departments to resolve problems regarding agreements and create Project Budget Justification Forms.
  • Works with Project Managers to ensure compliance with agreements.
  • Performs other duties as assigned.

WORKING CONDITIONS
There are no major sources of discomfort, i.e., essentially normal office environment with acceptable lighting, temperature and air conditions.  Requires the ability to make simple gross motor responses within large tolerances.

MINIMUM REQUIREMENTS

EDUCATIONAL REQUIREMENTS
 Requires a Bachelor's degree in Public Administration, Business Administration, Government or closely related field.
 
EXPERIENCE REQUIRMENTS

Two years of contract compliance or other related professional analytical compliance experience are required.

 Professional experience related to the type of work to be performed may substitute for the education requirement on a year-for-year basis.
 
LICENSE REQUIREMENTS
 None.

PREFERENCES

PREFERENCES

Preference will be given to candidates with the following experience as well as eligible veteran applicants: 

• 3 years’ demonstrable experience with data analytics tools such Power BI and Advanced Microsoft Excel
• Strong planning, documentation, and process-tracking skills
• 3 years’ experience with software such as Microsoft Project Management, CPMS, and CMMS systems
• General understanding of City procurement and contracting processes
• Demonstrable experience with contract terminology
• Experience with SAP – setting up funding 
• Experience using One Drive

**Preference shall be given to eligible veteran applicants provided such persons possess the qualifications necessary for competent discharge of the duties involved in the position applied for, such persons are among the most qualified candidates for the position, and all other factors in accordance with Executive Order 1-6. **

GENERAL INFORMATION

SELECTION/SKILLS TESTS REQUIRED
The department may administer a skills assessment test.
 
SAFETY IMPACT POSITION   YES
If yes, this position is subject to random drug testing and if a promotional position, candidate must pass an assignment drug test.
 
SALARY INFORMATION
Factors used in determining the salary offered include the candidate's qualifications as well as the pay rates of other employees in this classification.
 
Pay Grade 22
 
APPLICATION PROCEDURES
Only online applications will be accepted for this City of Houston job and must be received by the Human Resources Department during active posting period. Applications must be submitted online at: www.houstontx.gov . To view your detailed application status, please log-in to your online profile by visiting: http://agency.governmentjobs.com/houston/default.cfm . or call 832-393-6051.
 
 If you need special services or accommodations, call 832-393-6051. (TTY 7-1-1)
  
 If you need login assistance or technical support call 855-524-5627.
  
 Due to the high volume of applications received, the Hiring Department will contact you directly, should you be selected to advance in our recruitment process.
  
 All new and rehires must pass a pre-employment drug test and are subject to a physical examination and verification of information provided.
  
EOE Equal Opportunity Employment 
The City of Houston is committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, genetic information, veteran status, gender identity, or pregnancy.

Salary : $2,471 - $2,980