Azure/SQL Data Engineer/Analyst-Seattle, WA (Remote)
Azure/SQL Data Engineer/AnalystLocation: Seattle, WA (Remote)Duration: 12+ MonthsRate: DOEUS 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 bolthires 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. RemoteSkills:Acceptance Testing, Agile Programming Methodologies, Analysis Skills, Business Intelligence, Business Skills, Communication Skills, Customer Support/Service, Customer/Client Research, Data Analysis, Data Management, Data Quality, Database Extract Transform and Load (ETL), Detail Oriented, Functional Testing, Identify Issues, Metrics, bolthires Excel, bolthires Product Family, bolthires SharePoint, bolthires Transact-SQL (T-SQL), bolthires Visual Basic for Applications (VBA), bolthires Windows Azure, OLAP Cubes, Platform as a Service (PaaS), Power BI, Production Support, SQL (Structured Query Language), SQL Server Integration Services (SSIS), Scripting (Scripting Languages), Support DocumentationAbout the Company:Georgia Tek Systems Apply tot his job