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.
