Database Intern – Transportation Funding (Summer)

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 is seeking a summer Intern to provide assistance in the development and maintenance of databases for federal, State, and local transportation projects contained in the Transportation Improvement Program (TIP) for the Dallas-Fort Worth area.  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 career objectives, as well as a current resume.

Ideal candidates should live within the Dallas-Fort Worth region and be able to work at least 25 hours a week from approximately mid-May to mid-August 2024. Continuing employment opportunities may be available for Interns who are successful in this position.

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

• Assisting with database-related activities, including the development of services and systems needed to better track funded and constructed projects
• Assisting with the integration of information with other database systems (e.g., merging data from other sources, adding data fields, populating other databases, etc.)
• Entering data and assisting supervisor with programming, analyzing, manipulating, querying, and updating the data
• Assisting with ensuring data accuracy by cross-referencing historical data
• Assisting with analyzing, revising, and correcting issues related to historical data
• Creating/updating tables, queries, forms, reports, macros, VBA scripts in Microsoft Access
• Creating/updating tables, views, stored procedures, indexes, and constraints in SQL Server Management Studio
• Creating/updating SQL Server Reporting Services (SSRS) reports
• Assisting in the development, maintenance, and expansion of Web-based applications

Required Skills

• Working knowledge of Microsoft Access, Word, Outlook, Excel, and PowerPoint
• Working knowledge of SQL Server Management Studio, including writing queries and stored procedures and creating/updating reports in SQL Server Reporting Services (SSRS)
• Working knowledge of Visual Studio.NET, C#, ASP.NET MVC architecture, jQuery, JavaScript, VBA, ClosedXML, and Pivot Tables
• Good communication and interpersonal skills, with ability to listen to and follow instructions, coordinate with other team members, and present ideas
• Ability to work independently and in a team environment
• 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
• Strong analytical skills, with ability to identify funding discrepancies
• Ability to assess historical actions, interpret communications, compile documentation, and summarize findings

Required Education and Experience

• Must be attending an accredited college or university in a degree-seeking program during employment
• No work experience required

Starting Salary

Minimum of $16.00 per hour

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