Please reply to:- Amit Agarwal / [email protected] / 609-606-9010 Ext.# 1309


Job Details:-
Job Title : Sr. Solutions Architect - BI
Location : Washington, DC
Expected Duration of Project : 12 Months
Start Date : 11/05/2012
Interview Type : Telephonic, Personal
Duties & Responsibilites :

Scope of Work

       WMATA seeks a Senior Solutions Architect skilled in designing and developing Business Intelligence capabilities using IBM’s Cognos 10.1. Working closely with WMATA’s Business Intelligence Program Manager, the Senior Solutions Architect for BI leads WMATA’s BI team in designing and developing the architected solution for enterprise BI services at Metro. He/she works with stakeholders to determine strategy and requirements, determines technical approach, maintains the project schedule, and manages priorities for WMATA’s BI team. The team consists of the Cognos Administrator, three to four BI Analysts/Report Developers, one PeopleSoft EPM developer, and one to two database developers. The role is also responsible for ensuring close coordination with applications development teams working in the areas of Safety, Law Enforcement, and Paratransit services.

       Primary objectives for FY13 include development of data marts and management dashboards for Safety, Metro Transit Police Department, and MetroAccess, extensive financial metrics reporting, requirements analysis for Metro’s Key Performance Indicators, and development of Metro’s strategic BI data strategy.

 

Tasks

       Create and maintain the project schedule

       Manage the day to day work of the Cognos BI team to ensure consistent technical direction and maintain best practices in all phases of the project lifecycle

       Analyze, document and communicate data integration requirements related to WMATA BI needs and objectives, and coordinate requirements with data owners and custodians

       Assess and propose solutions to improve the BI delivery architecture to evolve with business needs, including recommending data marts and data warehouse structures

      Establish and enforce standards to avoid redundancy and encourage standardization and consistency among reporting products and processes

      Design and build data marts for BI reporting

      Design and build graphs, charts and advanced SQL statements, implement intricate calculations, develop scorecards and portlets, write and implement ETL scripts, tunetables and scripts for performance

Knowledge, skills and experience

     At least 10 years of progressive accomplishment as an expert Cognos designer and developer, defining and implementing requirements across multiple information technology platforms using Framework Manager, Transformer, Analysis, Query, Reporting and Metrics Studios.
Demonstrated versatility in assuming a variety of responsibilities on BI projects, including hands-on project management, customer communication, requirements analysis and coordination, architecture design, and technical lead
Proficiency and demonstrated ability to design and develop numerous graphs, charts and advanced SQL statements, implement intricate calculations, develop scorecards and portlets, create data structures to support requirements, write and implement ETL scripts, tune tables and scripts for performance, and manage Cognos administrative and configuration management tasks.
At least 10 years experience in various forms of data modeling, including relational and star schema
At least 10 years experience developing ETL scripts for BI products
At least one year experience implementing Cognos 10.1.
Strong client communication skills and team mentoring skills
Experience in two or more of the following functional areas: transit BI, financial BI, Federal/State Government BI



Click here to see details and upload resume for this job.

Click here to see all jobs on jobs.compunnel.com.

--
You received this message because you are subscribed to the Google Groups "American Vendor--IT Consulting" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to [email protected].
For more options, visit this group at http://groups.google.com/group/sap-vendor?hl=en.

Reply via email to