Home       |     Overview      |     Candidate Login      |     Post Resume       |     Contact us
 
  
     
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     
SQL Excel Cognos 10 Analyst
(Jobs in ARLINGTON, VA)
Apply
 
Requirement id 19605
Job title Analyst
Job location in ARLINGTON, VA
Skills required Data Warehouse, Cognos Business Intelligence System, Powerpoint, SQL Excel Cognos 10
Open Date 09-Jul-2014
Close Date
Job type Contract to Hire
Duration 6 Months
Compensation DOE
Status requirement ---
Job interview type ---
   Email Recruiter: coolsoft
Job Description Analyst: Data Warehouse, Cognos Business Intelligence System, Powerpoint, SQL Excel Cognos 10

[Note: must be our own w2]

Description:

Minimum Required:
Bachelors degree in related field and 8+ years experience in Business Intelligence (BI) or Data Warehouses.
Solid experience as a COGNOS Framework Manager 10.x and BI Administrator
Knowledge of the COGNOS Business Intelligence (BI) to assist in report generation and data verification.
Minimum of a Secret Interim clearance to start (Day 1 requirement).
Security + certification required to start (Day 1 requirement).
Adept at using Access, Excel, Power Point, SQL
General Data Warehouse / Business Intelligent knowledge, including Dimensional Data Modeling, star and snowflake schema design, OLAP, dashboards, and KPIs preferably in COGNOS environment

Responsibilities:
This Analyst will prepare and verify reports that routinely are presented to Upper Management. This position requires a highly qualified and skilled person, with excellent technical qualifications who is experienced at communicating and portraying complex data from multiple sources at the operational and strategic level. This person will routinely interact with senior staff and the contractor designated to support the application.

Specific duties are listed below:
Develops programs for the system to record, track and store data from the Integrated Disability Evaluation System (IDES).
Primary developer for developing applications (document stores, document transfer, data stores, data transfer) that go beyond this specific Agency.
Produce documentation on the data migration, write and revise programs to mirror present workflow and case processing.
Assist in the data pushes and data structure that support both
COGNOS reports and the eMEB application.
Must be thoroughly familiar with Access, PowerPoint, Excel and SQL to develop the required reports from the data warehouse and associated external sources (VTA data extract, eMEB, DFAS, TRANSPROC, AWCTS, etc).
Prepare/develop all required reports including ad hoc, daily, weekly, monthly, quarterly, and annual reports as well as user reports.
Serve as contract team lead for the contract data base team, supervising both the administrative and technical aspects of the data analysts assigned.
Required to have systems knowledge of data warehouses, data stores, extract transfer and load functions (ETL) and efficient data stores.

Maintains the COGNOS reports file.
Constructs the recurring reports in COGNOS.
Converts the existing quarterly reports package from the Legacy application to COGNOS 10.
Compiles and writes documentation of the COGNOS Reports structure and development, maintains the report and request library.
As directed or required constructs data base queries using COGNOS to supply requested information to Senior Leadership.
Consults with staff as to clarify the programs intent and validity, identify and present the management dash board.
Required to maintain access to the system.
Provides analysis of application data to identify trends and ensure data accuracy and currency
Maintains a written record of data requests, queries for future use
Maintains and transfers the electronic archives to the new application.
Creates reports from legacy systems data using Microsoft Access
Maintains the data log, suspense and queries.


Preferred Qualifications:
COGNOS Business License
COGNOS Framework Manager Certification
Experience and thorough understanding of case processing at the Client site and the legacy data base to insure the migration accounts for all the existing elements.
Hands-on experience with COGNOS Report Development and Report Migration.
Strong background in COGNOS Framework Manager data modeling, and the development of packages accessing various data sources
 
Call 502-379-4456 Ext 100 for more details. Please provide Requirement id: 19605 while calling.
 
Other jobs in VA: Alexandria (1), Ashburn (3), Cardinal (1), Charllottesville (1), Charlottesville (6), Chesapeake (2), Chester (2), Dulles (3), Fredericksburg (1), Fremont (1), Glen Allen (2), Reston (4), Richmond (45), Roanoke (14), Virginia Beach (14),
 
 Data Warehouse job openings in other states
Jobs List

Certified Project Manager IV/Sr. -136881(REBID)
Create date: 31-Oct-2024
No of Submissions : 1

Start date : 11/18/2024

End Date : 06/30/2025

Submission deadline : 11/4/2024 4:00:00 PM

Client Info : ETF

Note:

* Interview Process: MS Teams

* Duration of Contract: 6/30/2025, with potential for extension

* Onsite or Remote: Candida.... (This job is for - BI Jobs in WI Madison Manager - (in Madison, WI))

GTRI Sr. Data Architect (748151)
Create date: 01-Oct-2024
No of Submissions : 2

Start date : 11/04/2024

End Date : 06/30/2025

Submission deadline : 10/04/2024

Client Info : GTRI-Enterprise Systems Department

Note:

* Agency Interview Type : Either Web Cam or In Person

* Hybrid

* Plans and schedules team resources, sta.... (This job is for - ArchitectingAnalytics Jobs in GA Atlanta Architect - (in Atlanta, GA))

QA Test Analyst Advanced -63258
Create date: 20-Sep-2024
No of Submissions : 2

start date : 10/14/2024

End date :10/31/2026

submission deadline : 09/24/2024

client info : NeDHHS

Note:

* Position Location: Remote

Description :

We are seeking a highly skilled ETL Test.... (This job is for - job Jobs in NE Lincoln Analyst - (in Lincoln, NE))

Database Administrator IV - 11119-24
Create date: 12-Aug-2024
No of Submissions : 1

start date : 09/16/2024

End date :09/12/2025

submission deadline : 09/01/2024

client info : DHS / OHA

Bill Rate :USD 35.50 Per Hour

Max Rate :USD 100.50 Per Hour


Note:
* Position Location : Remote
.... (This job is for - Cobol Jobs in OR Salem Administrator - (in Salem, OR))

Data Warehouse Developer III -130752
Create date: 21-May-2024
No of Submissions : 1

start date : 07/01/2024

End date : 06/30/2025

submission deadline : 5/22/24 at 4pm CST

client info : DCF

Note:

* INTERVIEW NOTES:
• Phone and web based interviews will be acceptable.
• However, an in--person interview may be required.
• Int.... (This job is for - job Jobs in WI Madison Developer - (in Madison, WI))
 
 Data Warehouse job openings in VA
Jobs List

Chesterfield County Data Warehouse Arch 2 (728556)
Create date: 31-Jan-2024
Hybrid

start date :02/15/2024

End date :06/18/2025

submission deadline :2/5/2024

client info :Chesterfield County

Description :

*local Richmond, VA candidates required for onsite work
*only submit candidates able to interview onsi.... (This job is for - Mapping Jobs in VA Chesterfield Consultant - (in Chesterfield, VA))

DBHDS-Business Analyst 4 (723348)
Create date: 26-Oct-2023
Hybrid

Start date : 11/13/2023

End Date : 03/29/2024

Submission deadline : 10/31/2023

Client Info : DBHDS

Description :
------------------------------------------------------
Pls ask your candidates to check their sent emails for RTRs they recently sent to other vendors with this job .... (This job is for - Implementation MS Excel Jobs in VA Richmond Analyst - (in Richmond, VA))

ELECT - Data Warehouse/BI Developer 3 - REMOTE (707815)
Create date: 29-Mar-2023
start date : 04/24/2023

End date : 12/31/2023

submission deadline : 4/3/2023

client info : ELECT

Note :

* Remote

Description :

Virginia Department of Elections (ELECT) is seeking a skilled and experienced Data warehouse and B.... (This job is for - Management Jobs in VA Richmond Developer - (in Richmond, VA))

ELECT - Data Warehouse/BI Developer 3 - REMOTE (706721)
Create date: 15-Mar-2023
Start date : 04/03/2023

End Date : 12/29/2023

Submission deadline : 3/20/2023

Client Info : ELECT

Note :

* Remote

* Web Cam Interview Only

Description :

Virginia Department of Elections (ELECT) is seeking a skilled and experienced Data warehouse and BI Developer.... (This job is for - Architecture Testing Jobs in VA Richmond Developer - (in Richmond, VA))

ELECT - Data Warehouse/BI Developer 3 (703828)
Create date: 22-Feb-2023
Hybrid

Start date :02/15/2023

End Date :08/15/2023

Submission deadline :2/27/2023



Description :
---------------------------------------------
Responsible for designing, developing, and maintaining data warehouse and analytics architecture to meet an enterprises business analysis and .... (This job is for - Architecture Jobs in VA Richmond Developer - (in Richmond, VA))
(Analyst: Data Warehouse, Cognos Business Intelligence System, Powerpoint, SQL Excel Cognos 10 in ARLINGTON, VA)
     
Search Jobs
     
Keywords,Title,Skills,Company  Location,City,State,Zip  
  Advanced Search
     

    About Us     Services    Privacy policy    Legal     Contact us