Please send your Resumes to : sajith.nair@ampcus.com
Please send your Resumes to : sajith.nair@ampcus.com
Hi,
Greetings from Ampcus Inc
We are looking for a Senior Business Intelligence Analyst to support world's leader in providing IT consulting and software services to the finest global organizations client.
This is a 6 Months to Long term Contract extendible Position based in Washington DC
Position: Senior Business Intelligence Analyst
Locations: Washington DC
Duration: 6 Months to Long term Contract
Skills Must Have:ETL
Pentaho PDI (Kettle)
Dataware House
Data modling
Job Description:
OVERALL PURPOSE OF POSITION:
Serves as technical team leader in the development of business intelligence solutions and other reports and analysis across all divisions of the organization. Writes complex SQL scripts to extract data from various databases and systems to make data available for enterprise reporting. Provides day-to-day management of overall reporting environment. The results provide ongoing support to USAC decision-makers, the FCC, Congress, and other interested parties.
ESSENTIAL DUTIES:
The position's essential duties include the following:
· Serve as technical team lead in the development of business intelligence reports and analysis, providing mentoring, guidance and troubleshooting to analysis team members in solving complex reporting and analytical problems
· Manage reporting environment including report data sources, security, subscriptions and metadata
· Assist in initiative towards data normalization and data integrity across the enterprise
· Assist Data Warehouse Engineer in identifying and revising enterprise reporting requirements
· Evaluate, test and implement new or upgraded software
· Troubleshoot reported problems pertaining to reports and the reporting database environment, working closely with other IT members, especially DBAs, Systems Analysts and Systems Engineers, identifying the cause and designing or developing an approach for resolution
· Assess impact of changes and updates to source production systems, planning and implementing resulting changes to reports
· Conduct end user training on reporting system
Below is additional information I have received from the hiring manager:
1. Please identify the key requirements (must-haves) for this candidate.
a. ETL
b. Pentaho PDI
2. Provide a brief description of the project in which they will be working on.
a. Project is for the development of datamarts using Pentaho Data Integration (PDI) for data analytics for Client ongoing Enterprise Data Strategy program. Specific OLTP (Oracle) databases will be used and ETL jobs will be developed. The project involves the technical documentation of the ETL jobs developed also.
3. Provide any pre-screen questions for the vendors to use in sourcing candidates.
a. Years of experience with ETL - 4
b. Tools – Pentaho, PDI, MS-SSIS, Erwin
TECHNICAL EXPERIENCE:
Type of Experience Years of Experience
· Knowledge of Relational Databases 7 years
· Requirements Gathering 7 years
· SQL Programming 7 years
· Microsoft SQL Server 2005 or above 5 years
· Microsoft Reporting Services 5 years
· SQL Server Management Studio 4 years
· SQL Server Integration Services 4 years
· SQL Server Analysis Services 2 years
· Oracle 10G or above 4 years
· Microsoft Excel 4 years
· Microsoft Access 1 year
· Microsoft Visio 2 years
· Microsoft SharePoint 2007 or above 2 years
· Financial Reporting 4 years
NOTE: In addition, please list any desired experience.
· Microsoft SQL Server 2008
· SQL Server Business Intelligence Studio
· Visual Studio 2010
· Team Foundation Server
· ERwin
· TOAD for Oracle
· Creating visual displays for data analysis and presentation
SPECIAL SKILLS:
· Ability to track records in entity relationship and dimensional modeling.
· Ability to translate logical models into physical implementation.
· Excellent verbal and written communication skills are an absolute must.
· Ability to work well under pressure and work on multiple tasks simultaneously.
· Outstanding analytic skills—in particular, an ability to translate an unstructured strategic question into a structured program of research, to disaggregate potential drivers of performance, to explore relationships between multiple pieces of data, and to test and identify the drivers underlying performance measures
· Outstanding ability to synthesize research results into actionable strategies and recommendations
· Advanced verbal and written communication skills and the ability to present effectively to small and large groups.
· Energetic, organized, detail-oriented
· Consistent ability to meet deadlines in a fast-paced environment
· Must be strong self-starter able to work independently under limited supervision
· Ability to build consensus and to work through others in achieving desired results and objectives.
· Consistent ability to set and deliver against a work plan in a fast-paced environment
· Ability to foster a cooperative work environment and to freely give and receive feedback
· Strong interpersonal skills and the ability to work effectively with a wide range of constituencies in a diverse community.
· Ability to lift 15 – 25 pounds
· General computer and presentation skills
· Customer and results oriented
If you find it interesting do send the following details:
| Checkpoint | |
| Full Name of the Candidate | |
| Contact number |
|
| Email ID |
|
| Salary/Rate |
|
| Last 5 digits of SSN |
|
| Current Location |
|
| Openness to relocate OR Travel |
|
| Total years of experience | |
| Relevant experience |
|
| Reason for Change |
|
| Availability/Notice Period |
|
| Highest Educational qualification with Year of Passing and Institute | |
| Certifications if any |
|
| Immigration Status - If H1B- name of the employer and H1B Validity | |
| Best Time to reach for a pre-screen/Interview | |
Please send your Resumes to : sajith.nair@ampcus.com
Please send your Resumes to : sajith.nair@ampcus.com
Thanks & Regards,
Sajith Nair
Ampcus Inc
14900 Conference Center Dr,
Suite #230, Chantilly, VA- 20151
703-722-6051 (Direct)
703-637-7299 (Ext) 164
281 404 9091(Fax)
SBA 8(a) Certified; ISO 9001:2008; ISO 27001:2005; ISO 20000:2005; SEI CMMi Level 3 Company
Certified by NMSDC, WBENC, SWAM, USPAACC
20th on the Fastest 50 Women Owned Growing Businesses in CONUS
#1 fastest growing women owned company in VA
Awarded 50 fastest growing Asian American business by Diversitybusiness.com and USPAACC
Inc 500/5000 Listed
Please consider the environment before printing this email unless mandatory.
This is a PRIVATE message. If you are not the intended recipient, please delete without copying. The information in this e-mail, and any attachments, may contain confidential information and is intended solely for the attention and use of the named addressee(s). It must not be disclosed to any person(s) without authorization. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are not authorized to, and must not, disclose, copy, distribute, or retain this message or any part of it. If you have received this communication in error, please notify the sender immediately.
NOTE 1: Regardless of content, this e-mail shall not operate to bind AMPCUS to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose.
NOTE 2: The sender believes that this electronic mail transmission and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Neither the sender nor his or her employer is liable for any loss or damage arising in any way from this message or its attachments
Please send your Resumes to : sajith.nair@ampcus.com
Please send your Resumes to : sajith.nair@ampcus.com
You received this message because you are subscribed to the Google Groups "US_Jobs&Consultants" group.
To unsubscribe from this group and stop receiving emails from it, send an email to us_jobsnconsultants+unsubscribe@googlegroups.com.
To post to this group, send email to us_jobsnconsultants@googlegroups.com.
Visit this group at http://groups.google.com/group/us_jobsnconsultants.
For more options, visit https://groups.google.com/d/optout.
No comments:
Post a Comment