Technical System Analyst (Business Intelligence)

Title:Technical System Analyst (Business Intelligence)
Details:Salary: $62,519 - $84,020 annually
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 numerous business systems. 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, SharePoint Reporting, MS Portfolio Server, PeopleSoft EPM.
* 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.

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 resident of the State of Ohio at the time of appointment.

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.
Comments:APPLICATION, TRANSCRIPT AND DETAILED RESUME:
There are three ways to apply for this position at MSD.

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

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

3) 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.
Employer:City of Cincinnati
Contact:Yudora Flack
City of Cincinnati, Human Resources Department
Two Centennial Plaza
805 Central Ave, Suite 200
Cincinnati, Ohio 45202
Phone: 513-557-7087
Email: yudora.flack@cincinnati-oh.gov
Website:visit our website...