Proficient in SQL Server 2019 / Azure SQL with strong ETL skills; expert in T-SQL; working knowledge of SSIS and Azure Data Factory (ADF).
Strong Excel skills (Pivot, PowerPivot, VBA) and working knowledge of Power BI; data quality experience and ability to derive business insights.
Experience working in an Agile/Sprint environment; excellent communication skills with business users and stakeholders.
Understanding of data management/BI concepts; familiarity with Azure PaaS offerings (Databricks, ADLS/ADW/Synapse) is a plus; ability to deal with ambiguity.
Requirements:
Provides extensive troubleshooting and technical expertise to identify data issues that impact data metrics; implements measures to proactively track data quality issues.
Gathers and confirms project requirements by studying user requirements and collaborating with the project team; participates in requirements, user acceptance tests, and business functionality tests.
Provides support to users on data-related questions/issues; documents processes; supports partner teams and participates in user training.
Monitors ETL (extract, transform, load) jobs; responds to job failures; troubleshoots complex data issues escalated from Tier 1; communicates ongoing issues to the business community; maintains readiness for off-hours production support.
Job description
Azure/SQL Data Engineer/Analyst Location: Seattle, WA (Remote) Duration: 12+ Months Rate: DOE
US Citizens and Green cards are Preferred.
Technology:
SQL Server 2019 / Azure SQL, Good SQL & ETL skills.
Strong expertise on T-SQL and working knowledge on SSIS & ADF.
Strong knowledge on Excel – Pivots, PowerPivot, VBA .
Working knowledge of PowerBI.
Strong data analytical skills, understanding and experience in Data Quality.
Ability to make business conclusions from data, connect scenarios.
Background of working in an Agile / Sprint based work environment.
Knowledge on DAX scripting and BPC-Standard & Expense – recommendation.
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.
