IIT Inc. Home

IIT Jobs Data Bank-Job Detail

Submit Resume For This Job (via email)
Follow us on LinkedIn or Twitter or Facebook
Follow us on Facebook Follow us on LinkedIn
ID Location Skills $$ Job Type Status
13927 Midtown Manhattan NY, NY 10001 Office of Payroll Administration: Oracle SQL, SQL Server, PL/SQL, Java, AIX, XML, ETL, SDLC DOE Contract OPEN
If you are unable to click on links above to submit resume, you may email your resume to

Subject=IIT Career Site/Resume for JobID=13927 (Office of Payroll Administration: Oracle SQL, SQL Server, PL/SQL, Java, AIX, XML, ETL, SDLC) in Midtown Manhattan NY NY 10001 (NON)

Estimated Length: Open Ended


The Client has a vacancy for an 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 Client 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 including Crystal Reports and queries to support the business data access needs of the FMS project as well as Client 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.

• 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.

The FMS Reporting and Business Intelligence Architect will perform the following tasks:
• Develop and maintain reporting structures including data structures, Business Objects Universes, Business Views and related structures, Crystal Reports, SQL queries and reports including Crystal 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 Client's internal reporting organization to ensure a compliant and consistent reporting strategy and environment.
• Provide guidance and leadership to business staff and other Client 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, Client 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 the Client FMS reporting staff to provide detailed insight into improvising processes and build efficiencies as applicable.

Required Knowledge, Skills & Abilities:
• 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 Architecture.
• 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 to end Business Intelligence systems architecture from the perspective of data extraction and Reporting.
• Hands on experience with Crystal Reports and Business views
• Hands-on proficiency with Oracle SQL, SQL Server, PL/SQL (DB2 a plus).
• Proven experience in balancing multiple tasks with critical timelines. High level flexibility is required to be able to quickly adapt to management directions, to address any ongoing or changing business needs.
• BO Java SDK Development experience a Plus
• Related 3rd-party software technologies such as BIRT Designer 4.x, AIX, shell scripting, and XML is a huge plus.
• Strong understanding of ETL processes, tools and Data Warehousing Architecture & Design.
• Experienced person that can assume responsibility and work with little direction.

Preferred Skills
• Minimum 3 years hands-on development experience working with Business Object XI (R3.1- R4.1 a Must –-- R4.2 a Plus)
• Minimum 2 years experience developing Crystal Reports and Business Views
• 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.

Minimum Qualification Requirements
1. A baccalaureate degree from an accredited college in computer science, information systems,
engineering, mathematics or related field and six years of satisfactory full-time experience related to enterprise architecture, solutions architecture, network architecture and/or IT infrastructure systems; or
2. A baccalaureate degree from an accredited college and ten years of satisfactory full-time experience related to enterprise architecture, solutions architecture, network architecture and/or IT infrastructure systems; or
3. Education and/or experience which is equivalent to "1" or "2" above.


Submit Resume For This Job (via email)
Don't See a Position Matching Your Skills?
Click here to Email / Register your resume and be notified of future job openings.
About IIT:

Founded in 1995, IIT is a leading provider of Workforce Solutions to Government and Fortune-1000 organizations. IIT is a winner of Inc-500 award. IIT's core services include:

  • Consulting for projects / IT Outsourcing
  • IT staffing (Contract / Temporary / Contingent / Consulting)
  • Custom Workforce Solutions
  • Recruitment Process Outsourcing (RPO)
  • Headquartered in New York, IIT has over 400 consultants deployed at Client Sites. Other IIT highlights include

  • Winner of Inc-500 award 2 consecutive years
  • Winner of Ernst & Young / USPAACC Fast-50 award 2 consecutive years
  • Winner of USPAACC Top-10 Award in the Northeast US
  • IBM Business Partner
  • Oracle Business Partner
  • Adobe Business Partner
  • NYSA Member - New York Staffing Association - Regional Affiliate of ASA / American Staffing Association
  • NYS MBE certified
  • Our Consultants love working for IIT

  • Competitive compensation
  • W2 or C2C
  • Biweekly Direct Deposit for W2 Consultants
  • Visa and Green Card sponsorship opportunities for qualified individuals
  • Local contact for you to meet and talk to anytime (not someone sitting overseas in a different time zone)
  • Follow us on LinkedIn or Twitter or Facebook

    IIT is an Equal Opportunity Employer