Public Finance​/Data Science Intern; Temporary - Part time

Position: Public Finance/Data Science Intern (Temporary - Part time)
Posting Details

Applicant View of Posting

Posting Number
1305T

Position Title
Public Finance/Data Science Intern (Temporary - Part time)

Department
Finance

Job Code
005

FLSA Status
Non-Exempt

Union Affiliation
Unrepresented

Pay Grade
T05

Job Description Summary

The intern will support the City of Columbia's finance operations while learning about a career in public service. Finance/Data Science interns will gain practical experience in the constantly evolving field of public finance. Regular duties and responsibilities for the intern, include reading & understanding of the public policy-related reports, analyzing & preparing reports, and assisting with City ERP software. The intern will work collaboratively with other Economic Division staff and the Finance Director.

The intern might also complete administrative work while observing different aspects of accounting, budgeting, procurement, treasury, economic, and business services.

Essential Job Functions

• Analyze the fiscal impact of proposed legislation and prepare fiscal notes.

• Provide support for general fund-related revenue analysis.

• Assist with time series analysis and other special projects.

• Prepare and present monthly/quarterly economic reports to the City of Columbia's Finance Audit and Advisory Committee.

• Provide support for Sales & Use Tax database development.

• Develop, maintain, and update Power

BI dashboards.

• Present data-driven recommendations to the finance team.

Ancillary Job Functions

• Assist Economic Division's regular activities.

• Help showcase the City of Columbia's financial performance.

• Run financial reports and collect data.

• Assist in developing GIS maps.

• Write and run SQL queries and reports.

• Developing application for internal users.

Knowledge & Skills

• Basic understanding of state and local (city and county) government.

• Knowledge of public finance, economics, statistics, mathematics, business, accounting, and computer science.

• Strong communication skills, including writing, oral, and data-driven storytelling.

• Understanding the principles of data and financial analysis reporting for public finance and budgeting.

• Excellent computer skills, including the use of Advanced Excel, Power

BI, and other programming software including R & Python.

• Ability to work independently and as part of a team, assisting peers with their responsibilities.

• Strong technical writing skills to prepare fiscal notes, financial analysis reports, and documents.

• Ability to develop and maintain positive relationships with staff, other city employees, vendors, citizens, and other contacts.

• Excellent attention to detail and commitment to accurate results.

Minimum Qualifications

Must be at least a Jr. in college
Have valid Driver's License

• Understanding of the principles of financial analysis and reporting, public finance, capital improvement, governmental accounting and budgetary control.

• Excellent computer skills including the use of Microsoft Office, Enterprise Resource Planning systems, and reporting tools.

• Ability to work independently and apply professional judgment and as part of a team with the ability to assist peers with their responsibilities.

• Above average technical writing skills to prepare financial analysis reports and documents.

• Ability to develop and maintain positive relationships with staff, other city employees, vendors, citizens and other contacts.

• Demonstrated attention to detail and commitment to accurate results

Supervision Exercised

None

Starting Salary
$18.00-$20.00 hr depending on qualifications and experience

Open Until Filled
Yes

Final date to receive applications

Number of Positions Available
1

Notice to Applicants

Individuals needing accommodation to apply may call

TTY: 711 (MO RELAY)

THE CITY OF COLUMBIA IS A MERIT, AFFIRMATIVE ACTION, EQUAL OPPORTUNITY

EMPLOYER:

MALE / FEMALE

THE CITY OF COLUMBIA REQUIRES PRE-EMPLOYMENT DRUG TESTING

The City of Columbia participates in the federal E-Verify work authorization program

Special Instructions to Applicants

A temporary employee position is one created and intended to exist for less than one thousand four hundred fifty (1,450) hours in any calendar year. Temporary employees have no seniority, grievance, or appeal privileges. Temporary employees shall have no benefits except as required by law.

A temporary employee position may be full-time, part-time, variable hour or seasonal
Temporary/Seasonal employees do not qualify for sick, holiday or vacation pay.
Pay checks are issued bi-weekly.

Hours

Hours vary