City of Cincinnati Job Opportunity
Exceptional Appointment - Announcement #09-050A
(Open to the Public and to City Employees)
Salary: $62,519 - $84,020 annually
APPLICATION, TRANSCRIPT & DETAILED RESUME DEADLINE:
Priority Deadline Date: Friday, November 6, 2009, 5:00 p.m.
Final Deadline Date: Wednesday, December 23, 2009, 5:00 p.m.
NOTICE TO APPLICANTS REGARDING DEADLINE DATES
It is in your best interest to apply early. You are advised that we may select a qualified applicant or applicants at any time after the Priority Deadline. This means a candidate may be appointed prior to the Final Deadline date. For the greatest chance of consideration, it is in your best interest to apply as early as possible.
The Metropolitan Sewer District (MSD) is seeking two talented and motivated individuals to fill Technical Systems Analyst (TSA) positions. These employees will employ and manage complex Business Intelligence and Decision Support technology solutions that incorporate information across enterprise systems such as PeopleSoft Project Costing, PeopleSoft Program Management, PeopleSoft Financials, and Human Capital Management systems, and across various other systems such as Maximo, CityWorks, Altiris, and Primavera. These TSAs will be responsible for solutions that will extract, analyze, summarize, and present information in a manner that provides transparency and enables strategic decision making. The skills and abilities needed to implement and manage these high level BI/DS solutions are highly technical, requiring advanced skills in SQL, Oracle, .Net, and enterprise application development. These individuals must be self-starters, work well in a team environment, and be able to demonstrate the following:
- Experience in working with enterprise business intelligence and decision support systems, such as Business Objects, PeopleSoft EPM, SharePoint Reporting, MS Portfolio Server.
- Experience in documenting functional requirements for BI and DS systems.
- Ability to manage and perform BI and DS system configuration according to industry best practices.
- Experience in monitoring, troubleshooting, and performing system diagnostics on newly implemented architecture for Business Intelligence.
- Experience in the use of data mining tools and data cube analysis to present, summarize, and monitor critical business information for enterprise performance management.
- Knowledge of system and network architecture to manage and document system upgrades.
- Ability to identify the need for system upgrades, evaluating the life cycle cost vs. upgrade benefit.
- Experience in developing and implementing ETL programs for data warehousing, ensuring best practices for coding and data transformation.
- Ability to perform feasibility/gap analysis on potential future data implementations.
- Experience in the use of .Net to develop product enhancements in the areas of BI and DS.
- Ability to use SQL and Oracle to optimize reporting and to perform ETL tasks.
- Ability to use knowledge of web based application development to support and maintain BI and DS solutions.
APPLICATION, TRANSCRIPT AND DETAILED RESUME:
There are three ways to apply for this position at MSD.
- ONLINE – Apply online by visiting https://jobs.msdgc.org/. Be sure to read and follow the instructions carefully, and upload supporting documentation as required. All required supporting documents must be received in order for your application to be considered complete. If you are experiencing technical difficulties, email msdhelpdesk@cincinnati-oh.gov.
- IN PERSON – Download application forms from this site http://www.cincinnati-oh.gov/cityhr/pages/-4284-/, OR obtain hard copy forms at the office of the City of Cincinnati Human Resources Department, Two Centennial Plaza, 805 Central Avenue, Suite 200, Cincinnati, Ohio 45202. Complete the forms, and return personally to the Human Resources office. Application and supporting documents must be received no later than the closing date. You may submit your detailed resume in lieu of the Work Experience Form.
- BY U.S. MAIL – Download application forms from this site http://www.cincinnati-oh.gov/cityhr/pages/-4284-/, complete them, and return them by first class U.S. Mail to the City of Cincinnati Human Resources Department, Two Centennial Plaza, 805 Central Avenue, Suite 200, Cincinnati, Ohio 45202. Application and supporting documents must be postmarked no later than the closing date. You may submit your detailed resume in lieu of the Work Experience Form. Please enclose a copy of your driver’s license with your mailed application package.
TRANSCRIPTS showing your qualifications for this position must be submitted by the deadline date. The City does not maintain a transcript file; you must submit transcripts with each application you submit. You may submit a readable photocopy of your official transcripts in lieu of requesting a new copy from the school for each application. Please note: copies of unofficial versions or internet printouts of transcripts are NOT acceptable.
QUALIFICATIONS: Each applicant must have three years of paid professional experience using .Net, and SQL languages for Oracle and Microsoft SQL database plus a Bachelor degree from an accredited university or college, with a major in computer science, information technology, computer programming, or a related field. OR Each applicant must have five years of paid experience using .Net, and SQL languages for Oracle and Microsoft SQL database plus an Associate degree with a major in computer science, information technology, computer programming, or a related field. All required experience must have occurred within the last (5) five years. You are required to show your valid driver's license to the Human Resources Department staff NO LATER THAN THE DEADLINE DATE FOR FILING APPLICATIONS. Must be a Hamilton County resident at the time of appointment.
CONTACT PERSON: Kathy Allen, 513.557.7197
TDD: 513.352.2419
City of Cincinnati, Human Resources Department
Two Centennial Plaza
805 Central Ave., Suite 200
Cincinnati, Ohio 45202
Date Released: October 26, 2009
“Applications for City positions are considered public records under Ohio’s Public Records Act. As a public record, applications maintained by the City shall be made available to any person requesting to view them.”
AN EQUAL OPPORTUNITY EMPLOYER
Reasonable accommodation for qualified people with disabilities. To help us achieve the City’s goal to recruit qualified persons with disabilities, please self-identify at the time of application and at employment interviews. Help the City help you!
