Innovations technological

Skill Set

Excellent PM(Program Manager) skills with exceptionally strong technical background.

Work Location

REDMOND, WA

Job Description

· 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).
· 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