Intermediate to expert experience in Microsoft SQL Server, including writing complex queries and debugging stored procedures
Experience with Power BI and Excel (VBA, lookups, pivots, etc.)
Working knowledge of Azure stack (Synapse, Spark/Python, SQL Azure, Azure Data Factory) with ability to ramp up quickly
Experience with Azure DevOps (ADO) and JIRA; excellent analytical, problem-solving, and stakeholder communication skills in an Agile environment
Requirements:
Write, test, and schedule audits for data validation reports using SQL stored procedures, views, and functions
Collect, analyze, and validate large/complex data sets; ensure data accuracy and completeness; perform ad-hoc analyses to derive actionable insights
Monitor ETL jobs, respond to failures, troubleshoot data discrepancies, and provide development support for platforms and applications
Document knowledge base articles for Tier-1 and Tier-2 support; collaborate with stakeholders on performance improvements and automation; ramp up on Azure skills as needed
Job description
Position- Data Analyst Location- Remote (Pst Timezone)
Duration- Contract Rate- DOE
Team Info: MS Sales business operations team, oversees Microsoft's revenue reporting process, collaborating with source data partners, business users to address data or functional issues. They are responsible for overseeing the entire end-to-end process of revenue publishing, pinpointing and resolving data and code issues in collaboration with the technical team. The business operations team not only manages reporting but also engages in functional and code testing of new features, play a crucial role in educating external users, addressing their queries, and ensuring a clear understanding of the processes. The team conducts thorough data analysis to guarantee the precision and efficiency of reporting procedures.
Job description:
Write, test and schedule audits for data validations reports using SQL Stored Procedures, Views and Functions
Collecting and analyzing large and complex data sets
Validating data to ensure accuracy and completeness.
Conducting ad-hoc analysis, solving data discrepancies, and generating actionable business insights.
Extending support on production issues during non-business hours as needed.
Understand data lineage, data quality and relationships.
Monitor ETL jobs and respond to any job failures.
Perform data engineering related activities e.g. developing and enhancing tools/solutions/processes based on data analysis and/or new customer requirements.
Development support for platforms and applications assigned.
Ability to work on Level 2 Service Requests from business users.
Document knowledge base articles for Tier-1 and Tier-2
Dedicate 20%-30% of time for Development efforts – Automation of operational activities, data quality checks, application feature development, develop tabular models, bug fixes and reporting.
Work with customer stakeholders and team members for performance improvement and suggestions.
Ramp-up on new Azure skills as per the project demands.
Required skill set:
Intermediate to expert level experience in Microsoft SQL Server - Writing Complex Queries; Debug existing Stored procedure; DB Performance improvement; Developing quality audits
Intermediate level experience in PowerBI and Excel (VBA, Lookups, pivots, etc.)
Working knowledge on Azure stack – Synapse, Spark/Python, SQL Azure, Azure Data Factory (ADF) - Ability to quickly ramp up on Azure
Experience working on project management tools like Azure DevOps (ADO), JIRA, etc.
Excellent analytical and problem solving skills
Ability to work in Agile environment, deal with ambiguity and critical thinking to achieve the expected results within SLAs
Excellent communication skills and ability to work with customer stakeholders and cross-functional teams by effectively understanding the business requirements
Preferred skills:
Prior experience in Microsoft landscape or corporate finance space is preferred.
Experience working with multi-geographical teams and in onshore-offshore model
