Job Description

Are you looking to join an award-winning organization with a culture built on innovation and public service?

The Transportation Department of the North Central Texas Council of Governments (NCTCOG) is seeking a Fiscal Database and Reporting Specialist to support the Department’s Fiscal Management Team. This position will assist with developing and maintaining information systems, tools, and reports vital to grant management, as well as invoice processing, billings for reimbursement, budgeting, and fund management, related to transportation projects. Applicants wishing to be considered for this position should apply online at https://www.nctcog.org/Careers. All submittals should include a cover letter summarizing your interest in the position and work experience as well as a current resume.

Responsibilities may include, but are not limited to, the following:

Developing and maintaining information systems to record, monitor, and report data
Identifying and investigating data discrepancies and/or inconsistencies and working with staff to resolve them
Developing an understanding of the Transportation Department processes and how information systems are and/or can be used to support these processes
Identifying potential improvements to information systems and ensuring appropriate and timely implementation of these improvements
Developing flowcharts and/or visual tools to assist with conceptualizing information system improvements
Documenting and communicating information system changes
Assisting staff the development and update of processes to ensure information systems are incorporated appropriately into processes
Providing training to staff on the use of information systems, including developing training materials
Responding to inquiries, suggestions, and problems from staff regarding information systems
Working with department and/or Agency management and staff to develop schedules and timelines, as well as obtain necessary approvals, for information system development, improvements, and review of data

Required Skills

Functional knowledge of Microsoft Excel, Access, Word, PowerPoint, and Outlook
Working knowledge of SQL and SQL Reporting Builder/SQL Reporting Services
Working knowledge of Visual Basic
Ability to process and analyze large amount of detail, particularly in financial reports
Detail-oriented, highly organized, with an ability to manage multiple assignments/tasks and work well in a deadline-driven environment without diminishing quality of work
Good communication skills, both verbal and written, and interpersonal skills
Ability to work independently and in a team environment

Required Education and Experience

Bachelor’s degree in computer science, computer programming, business administration, information technology, accounting, or a related field of study
At least one year of job-related experience

Starting Salary Range

$59,390.00 – $71,268.00 annually

The North Central Texas Council of Governments (NCTCOG) is a voluntary association of, by and for local governments, and was established to assist local governments in planning for common needs, cooperating for mutual benefit, and coordinating for sound regional development. NCTCOG's purpose is to strengthen both the individual and collective power of local governments and to help them recognize regional opportunities, eliminate unnecessary duplication, and make joint decisions. Since 1974, NCTCOG has served as the Metropolitan Planning Organization for transportation in the Dallas-Fort Worth Metropolitan Area and is responsible for developing transportation plans and programs that address the complex needs of the rapidly growing area. The planning area for transportation includes the 12 counties of Collin, Dallas, Denton, Ellis, Hood, Hunt, Johnson, Kaufman, Parker, Rockwall, Tarrant, and Wise.

The agency offers generous benefits, a friendly atmosphere with open communications for cooperative decision making, and challenging opportunities. The environment encourages both individual and team growth, responsibility, and innovation.

NCTCOG is recognized as a military-friendly employer and values the knowledge, experience, and skills acquired during a military service career. All qualified veterans are invited to apply.

Equal Employment Opportunity Employer:

NCTCOG is an equal opportunity employer/program. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, age, national origin, disability, veteran status, and other classifications covered under federal, state, or local laws. Auxiliary aids and services are available upon request to individuals with disabilities.

Background Check & Drug Testing:

All selected candidates must undergo a pre-employment background check and drug screening. Background checks include national criminal background check, employment history, motor vehicle record check, social security verification, education verification, and other elements as needed. NCTCOG is committed to a safe and drug free workplace and performs pre-employment substance abuse testing. All new hires are required to undergo a drug test which detects the presence of illegal drugs for months prior to testing. We appreciate your cooperation in keeping NCTCOG safe and drug free. In order to receive an offer of employment from NCTCOG, selected candidates must successfully pass the pre-employment background check and drug screening.

E-Verify:

The North Central Texas Council of Governments participates in the federal E-Verify program in order to verify a new employee's authorization to work in the United States. Applicants must be lawfully authorized to work in the U.S.

Job postings are kept open for a minimum of 10 calendar days and may close anytime thereafter at the discretion of the hiring manager.

Data analysis jobs

Fiscal Database and Reporting Specialist – Fiscal Management