Financial Data Analyst – Intern

THIS IS A NON-CIVIL SERVICE POSITION

CITY OF BALTIMORE, OFFICE OF THE COMPTROLLER

FINANCIAL ANALYST INTERN – FALL 2025

SALARY RANGE:  $15.00/Hourly – NO BENEFITS

WORK SCHEDULE: Up to 20 hours per week on site, with flexible scheduling based on academic commitments.

Get to Know Us

Welcome to the City of Baltimore! Experience the reward of a fulfilling career and enjoy the added element of excitement in a vibrant, diverse atmosphere. The City of Baltimore offers limitless opportunities to help drive social impact, both on the job and in the community, while serving its citizens. Join us in making Baltimore a great place to live and work. In the City of Baltimore, we hire great people and provide them with the skills and opportunities to grow toward their career aspirations. If you are looking for a career change or interested in learning more, explore our opportunities. We are excited to have you as a part of the City of Baltimore Team!

JOB SUMMARY

We are seeking a detail-oriented and analytical University Intern to support the financial operations of the City's Telecommunications Department. The intern will assist with invoice processing, vendor communications, data validation, financial analysis, and reporting. This role is ideal for a student with strong Excel skills and an interest in finance, data analytics, or telecommunications.

ESSENTIAL FUNCTIONS

Invoice & Vendor Management

• Review and process incoming invoices from a variety of city vendors daily.
• Match and process invoices in Workday, ensuring accuracy and timeliness.
• Contact vendors to correct invoice discrepancies and follow up as needed.
• Investigate historical invoices using vendor and City systems to confirm proper payment.
• Resolve issues related to delinquent accounts involving thousands of dollars over a six-month period.
• Communicate with vendor representatives via email to resolve payment discrepancies and ensure timely responses.

Billing & System Reconciliation

• Review billing accounts in WinBill to ensure correct departmental charges for equipment.
• Compare records across WinBill, Workday, and Mitel systems to verify billing accuracy.
• Investigate and resolve error reports when discrepancies arise.
• Collaborate with the Chief of Fiscal Services to ensure accuracy in Month-End Closing procedures.

Financial Reporting & Analysis

• Deliver weekly financial reports and billing summaries to supervisors.
• Review telecommunications billing reports to identify potential cost-saving opportunities.
• Analyze usage and financial data and convert them into statistical measures and insights.
• Develop and present visual reports using graphs and charts to illustrate trends, such as:
  • Trouble ticket activity (received vs. completed)
  • Open vs. closed invoices and requisitions
  • Circuit usage trends (VoIP, analog, DSL, 800 numbers)

MINIMUM QUALIFICATIONS

• Current university student pursuing a degree in Finance, Accounting, Business, Information Systems, or related field.
• Strong proficiency in Microsoft Excel (including pivot tables, VLOOKUP/XLOOKUP, formulas, and data visualization).
• Strong attention to detail, organization, and analytical thinking.
• Excellent written and verbal communication skills.
• Ability to manage multiple tasks and meet deadlines.
• Comfort working with confidential or sensitive financial data.

KNOWLEDGE, SKILLS AND ABILITIES

• Familiarity with Workday, WinBill, or similar financial and billing systems.
• Experience or coursework in telecommunications, billing operations, or public sector finance.
• Knowledge of statistical data analysis or business reporting tools (e.g., Power BI, Tableau).

LEARNING AND DEVELOPMENT OPPORTUNITIES

• Hands-on experience with public sector financial operations and telecom billing systems.
• Exposure to enterprise systems (Workday, WinBill, Mitel).
• Strengthen skills in data analysis, vendor management, and financial reporting.
• Collaborate with cross-functional teams, including fiscal services and IT

ADDITIONAL INFORMATION

Background Check                                        

Eligible candidates under final consideration for appointment to positions identified as positions of trust will be required to complete authorization for a Criminal Background Check and/or Fingerprint must be successfully completed. 

Baltimore City Government is an Equal Employment Opportunity Employer, and we are committed to a workplace that values diversity, equity, and inclusion. The City of Baltimore prohibits discrimination on the basis of race, color, religion, age, sex, ancestry, creed, national origin, disability status, genetics, marital status, military service, sexual orientation, gender identity/expression or any other characteristic protected by federal, state or local laws. Applicants requiring accommodations during the hiring process should contact the Department of Human Resources directly. Do not attach your request for accommodation to the application. 

BALTIMORE CITY IS AN EQUAL OPPORTUNITY EMPLOYER