Microsoft Corporation Data Analyst in Redmond, Washington

The ideal candidate should be self-directed, passionate about data, and focused on delivering the right results. The candidate should be able to apply programming acumen and a breadth of tools, data sources and analytical techniques to answer a wide range of high-impact business questions and present the insights in a concise and effective manner. Technical aptitude and programming skills are necessary in this role. The candidate should also be an effective communicator capable of independently driving issues to resolution and communicating insights to both technical and non-technical audiences. The role requires incubating, developing, testing and iteratively improving on BI capabilities to understand the product(s) in depth so as to provide key insights to shape product and marketing actions, thereby improving customer experience and usage of the product(s).

Responsibilities

  • Build a holistic understanding of our product features, its customer, the BI data infrastructure & environment, and business goals

  • Develop powerful visualization on customer behavior and usage and become SME for the product(s)

  • Analyze and validate data using statistical tools to answer product and business questions, to drive product and marketing actions

  • Build and maintain Learning Plans for the product(s) with key analytical questions to address and investigations on data quality

  • Interface with business users and engineering teams to bridge the gap in terms of data needs and business term/logic understanding

  • Leverage industry best practices in establishing repeatable BI practices, principles & processes

  • Leverage team members across BI, for data & analysis needs

  • Refine, improve and centralize team capabilities and share to the broader business and analytical community

  • Manage external vendor relationships onshore & offshore, as needed

Qualifications

  • Unique mix of technical, development, project and program management skills

  • Ability to understand, translate and map business and product questions into analyses projects

  • Expertise in database technology with solid understanding and hands-on skills with SQL Server, SSIS, solid understanding of SSAS / n-dimensional cubes

  • Experience in analyzing big data using statistical tools such as SQL, C# and statistics

  • Experience with unstructured datasets (Hadoop and/or Cosmos)

  • Solid experience building business intelligence solutions (data warehouse, datamart, ETL, Reports, Powerpivots) and ability to understand instrumentation and devise technical solutions

  • Proficiency in advanced Excel functions (e.g., creating formulas, pivot tables) and PowerBI

  • Knowledge of SAS, SPSS, Tableau, Adobe Insights or similar analytic software

  • Strong business acumen

  • Excellent collaborative skills, consultative and customer-facing skills, strong client services orientation

  • Ability to influence diverse audiences and build strong partnerships with stakeholders

  • Strong ability to articulate vision, requirements & benefits, providing a solid rationale to multiple business and technical partners

  • Self-motivated, agile and driven to think out-of-the-box on key initiatives

  • Experienced professional and education in computer science. College degree required