FMS REPORTING and BUSINESS INTELLIGENCE ARCHITECT

The primary role of the FMS Reporting and Business Intelligence Architect is to:
- Identify end user data access and reporting needs and help business users towards defining detail requirements.
- Analyze data and reporting requirements to recommend and design solutions through the creation of appropriate database structures, reports and query structures.
- Gain proficiency with FISA and FMS application data models and data dependencies to provide the best possible assistance to business users and owners in their data access needs.
- Design and develop new reporting structures, BO universes, reports and queries to support the business data access needs of the FMS project as well as FISA and city agency personnel.
- Adopt creative approach methodology in troubleshooting BO & data issues, assist end user queries in a timely manner, proactively address and appraise management of any reporting related technical issues.
- Review and identify any pitfalls in the data integrity and schema designing issues, and suggest improvements over any existing designs.
- Review technical designs for FMS BO reporting solutions, identify and be able to remedy any design related issues, independently come up with better design strategies and solutions.
- Work collaboratively with larger groups and diversified teams as necessary, should be extremely comfortable working in a large information technology environment, and be capable of independently building partnerships with diversified business and technical teams.
- Some understanding of the Data Warehousing Architecture is required, in order to troubleshoot and recommend appropriate design improvements, should be capable of redesigning the business data structure and relational models.
- Very strong Business Objects reporting background in designing & developing complex Reports and Universes is a must. Major emphasis is laid on Business Intelligence \ reporting areas and subject matter understanding of business and its data.
- Collaborate with vendor query and reporting team to assure that requirements and timelines are met. As a party responsible for the design, creation and  review of reporting strategies, the FMS Reporting and Business Intelligence Architect will participate in the design, development testing and implementation of reporting structures required to support end users of the FMS project systems.
- Additionally, the candidate will be responsible for interacting with FISA's development Vendors from an oversight perspective, as well as interacting with different levels throughout the organization: developers, architects, business analysts and business owners.

The FMS Reporting and Business Intelligence Architect will perform the following tasks:
- Develop and maintain reporting structures including data structures, Business Objects Universes and related structures, SQL queries and reports to support the needs of the FMS Project as well as on-going needs of business owners.
- Work closely with vendor’s query and reporting team as well as FISA’s internal reporting organization to ensure a compliant and consistent reporting strategy and environment. 
- Provide guidance and leadership to business staff and other FISA staff members in the use of query and reporting tools.
- Assist in the establishment and maintenance of query and reporting environments.
- Responsible for participating in the design, development, testing, implementation and support of required reporting structures, queries and reports to support needs of the FMS project, FISA organization and other involved city agencies 
- Maintain detailed documentation for query and reporting design and development for the FMS project.
- Should be willing to work independently as a self-starter, with minimal direction.
- Strong competence in the Business Analysis area is required, should be able to perform extensive business requirements analysis/reviews, should be capable of capturing business requirements and write detailed Technical design documents from a reporting and business intelligence perspective. – a must have skill.
- Review reports and supporting SQL and other code, test scenarios, test scripts and proactively address any gaps and identify any potential pitfalls. – a must have skill.
- Work with FISA FMS reporting staff to provide detailed insight to improvising processes and build efficiencies as applicable.

1. A master's degree in computer science from an accredited college and three years of progressively more responsible, full-time, satisfactory experience using information technology in computer applications programming, systems programming, computer systems development, data telecommunications, database administration, planning of data/information processing, user services, or area networks at least 18 months of this experience must have been in an administrative, managerial or executive capacity in the areas of computer applications programming, systems programming, computer systems development, data telecommunications, data base administration, or planning of data processing or in the supervision of staff performing these duties; or
2. A baccalaureate degree from an accredited college and four years of experience as described in "1" above; or
3. A four-year high school diploma or its educational equivalent approved by a State's department of education or recognized accrediting organization and six years of experience as described in "1" above; or
4. A satisfactory combination of education and experience equivalent to "1", "2" or "3" above. However, all candidates must have at least a four-year high school diploma or its educational equivalent approved by a State's department of education or recognized accrediting organization and must possess at least three years of experience as described in "1" above, including the 18 months of administrative, managerial, executive or supervisory experience as described in
"1" above.
Qualification Requirements (continued)
NOTE: The following types of experience are not acceptable: superficial use of preprogrammed software without complex programming, design, implementation or management of the product; use of word processing packages; use of a hand held calculator; primarily the entering or updating of data in a system; the operation of data processing hardware or consoles.

Preferred Skills
- Excellent communication and interpersonal skills and ability to work well in a team environment.
- Strong reporting development background, in a large data warehouse environment.
- Extensive command in Business Objects Architect.
- Must have excellent business analysis skills, able to interact with senior business staff to derive and interpret business needs.
- Proven proficiency and understanding of end Business Intelligence systems architect  from the perspective of data extraction and Reporting.    
- Hands-on proficiency with Oracle SQL, SQL Server, PL/SQL (DB2 a plus).
- Proven experience in balance multiple tasks. High level flexibility is required to be able to quickly adapt to management directions, to address any ongoing or changing business needs.   
- BO SDK Development experience and related 3rd-party software technologies as well as AIX, shell scripting, and XML is a plus.
- Understanding of ETL, processes and Data Warehousing Architecture & Design.
- Experienced person that can assume responsibility and work with little direction.
- Minimum 3 years hands-on development experience working with Business Object versions 6.5, XI R2/R3.1.
- Strong background in relational database technologies - Oracle, SQL Server, DB2 and writing SQL, PL/SQL
- Good understanding of SDLC having worked through at least one full iteration of a complete SDLC on a major large scale project including reporting, ETL and data warehousing.
- Quick learner with ability to understand and become a SME in the business data definitions and requirements in order to understand reporting requirements.
- Candidate should be experienced in working with senior business managers,
- Candidate should be a self-starter, willing to work on directives given thereof, with very little supervision. Candidate should be a mature individual and be willing to multi task, wear multiple hats and be quick to adapt to management directives or as the project demands.