Job Title: SQL Data Analyst Location: Remote Duration: Contract Rate: DOE 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 bility 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 dditional 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 bility to deal with ambiguity and work in agile environment. Excellent communications skills with business users / stakeholders ttention 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
databricks Business Intelligence (BI) Microsoft SharePoint charts pivot Azure ADLS Power Pivot Writing reports and proposals SQL Server Integration Services (SSIS) SQL cubes Analytics ETL synapse Microsoft Excel Power BI