Job Seekers, Please send resumes to resumes@hireitpeople.com

Skill Set

 

excellent PM skills with exceptionally strong technical background.

 

Work Location

 

REDMOND, WA, USA

 

Special Instructions

 

NA

 

 

Job Description

 

Total Work Exp: min 6-8yrs 

Job Description: 

 

We have an immediate need for 1 Analyst. We are looking for program manager analysts with excellent PM skills with exceptionally strong technical background. Must have SQL experience, and experience in creating and maintaining conceptual, logical and physical data models. Must be an expert in cube development. Must assist with data profiling, modeling, quality analysis and authoring source to target mapping. 

 

Specialization: Data Warehousing , BI (Analyst with past experience working as a Software Engineer/Architect) 

SKILLS REQUIRED Technical Skills 

 

Expert in Microsoft SQL Server. Hands on s proficiency in SQL with strong querying skills,data profiling skills and troubleshooting skills .Familiarity with Informatica will be a brownie point. Designing and building complex data models (Dimensional and Tabular) Designing and developing cubes Ability to reverse engineer legacy SQL language code, identify the functional logic and author source to target mappings. Be able to understand complex data models. Quick at picking up and understanding new models and applications Identify and analyze data issues and provide recommended solutions based on business needs. Must be proficient writing and running SQL queries. Building simple pivot reports. Good troubleshooting skills. Familiar with MS BI stank -SQL and Office products Program Management Skills Project management skills in proactively managing schedules, risks, escalations and managing stakeholder communication Working in a fast paced environment with abilty to multi-task Handling escalations from multiple stakeholders. Ability to facilitate outcome driven discussions with multiple stakeholders. Good at working with multiple stakeholders with diverse backgrounds (technical and non-technical). Excellent verbal and written communication skills Build and manage project plans and schedule effectively Collect content for SDLC Milestone reviews. Schedule Milestone meetings proactively Facilitate accurate and proactive status reporting to stakeholders, including the publish of weekly project status report Business Analysis Skills Analyzing existing business process and reporting. Collecting and documenting new information needs (requirements collection) and functional requirements (Authoring functional specifications Logical Data Model, Source to Target Mapping, Functional requirement documents) Review technical design document and provide feedback. (Technical requirements documents, physical data models, master test plans). Forward issues to the Report team and Engineering appropriately. UAT Management Skills Execute backend test scripts (non-Field testing), write test scripts. This should include business facing process scripts and backend SQL query scripts. Update and manage test scripts working with Field IT after reviewing test scripts with stakeholders Support kick off and training meetings, Attend triage calls (Americas/Asia) Triage and assign issues raised in the triage. Experience(MUST HAVE) Experience as an analyst (at least 2 years) with experience authoring functional specifications, design documents and reviewing technical design documents. Past technical experience in cube development with expertise in designing and developing cubes. Experience working on modeling solutions in dimensional and tabular data models Experience in BI, Data warehousing, BI and Analytics domain. Experience managing UAT - triaging calls, issue resolution Experience in managing multiple stakeholders and handling escalations for enterprise scale programs. Completed at least one end to end V1 operational or analytical BI project