Data Engineer

Georgia Tek Systems

Seattle, WA, United States

9 days ago

Apply on www.careerbuilder.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Job source

www.careerbuilder.com

Tech stack

Microsoft Excel Agile Methodology Data Analysis Microsoft Azure Databases Extract Transform Load (ETL) Data Mining Microsoft Software Microsoft SQL Server SQL Azure Online Analytical Processing Platform as a Service (PAAS)

+13 more

Powerpivot Power BI Microsoft SharePoint SQL Databases SQL Server Integration Services Transact-SQL Scripting Vba Programming Language Data Analytics Data Management Azure Service Fabric Visual Basic Language Databricks

Job description

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.

Requirements

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., 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, Microsoft Excel, Microsoft Product Family, Microsoft SharePoint, Microsoft Transact-SQL (T-SQL), Microsoft Visual Basic for Applications (VBA), Microsoft Windows Azure, OLAP Cubes, Platform as a Service (PaaS), Power BI, Production Support, SQL Server Integration Services (SSIS), Scripting (Scripting Languages), Support Documentation