Prior Experience Working With Microsoft - Sql Data Analyst

SQL Data Analyst – must have prior experience working with Microsoft

Location – Redmond, WA (remote)

Duration – 12 months +

Must have 6-8 years of related experience.

Technology:

• SQL Server 2019 / Azure SQL, Good SQL & ETL skills

• Good knowledge of SSIS and strong on SQL

• Working knowledge of PowerBI

• Strong data analytical skills, understanding and experience in Data Quality

• Ability to make business conclusions from data, connect scenarios

• Strong knowledge on Excel – Pivots, PowerPivots, Charts

• Background of working in an Agile / Sprint based work environment

Additional skills:

• Understanding Data Management & BI concepts, Data Analysis, Analytics, Cubes, Reporting Technologies, ETL

• Working knowledge/ concepts in Azure PaaS technologies – Databricks, ADLS / ADW / Synapse is a big plus

• Prior experience in Microsoft landscape is a big plus

• Ability to deal with ambiguity and work in agile environment.

• Excellent communications skills with business users / stakeholders

• Attention to detail

• Strong troubleshooting skills

• Hands on experience with SharePoint

Responsibilities include:

• Provides extensive troubleshooting and technical expertise in identifying data issues that impact data metrics.

• Implements measures / solutions to proactively track data quality issues

• Gather and Confirms project requirements by studying user requirements; conferring with others on project team.

• Participate in requirements / user acceptance tests/ business functionality tests

• Provides support to the users on any data related questions/issues reported.

• Documenting processes, supporting partner teams, participating in user training

• Solving data discrepancies and providing business intelligence insights.

• Monitor data extract, transform, and load (ETL) jobs and respond to any job failures.

• Troubleshoot complex data related issues escalated from Tier 1

• Flexibility to support production issues during off hours

• Communication of ongoing issues / incidents to business community