Fully Remote Data Engineer 2


Premium Job From Nigel Frank International

Recruiter

Nigel Frank International

Listed on

25th July 2022

Location

Tampa

Salary/Rate

£77916 - £118925

Type

Permanent

Start Date

ASAP

This job has now expired please search on the home page to find live IT Jobs.

Data Engineer 2

Permanent, Full Time

100% Remote

$95k - $145kEssential Job Functions:

Design, implement, and maintain complex ETL/ELT solutions on-premise and in Azure that will support business requirements.

Model and develop databases, schemas, and data structures to ensure high performance for high volume OLTP or OLAP databases as required

Assist Web and enterprise systems software developers with best practices for writing queries, query tuning and schema refinement, particularly for soap services

Solve complex requirements using advanced-level SQL techniques such as window functions, CTEs, CROSS APPLY statements, etc.

Incorporate appropriate tools, technologies, techniques and design patterns to create maintainable, scalable, high-performance database solutions.

Design, implement, and maintain code in development, test, and production environments both on prem and in the cloud. Design solutions to support systematic promotion between environments.

Perform work of high difficulty in writing, modifying, tuning, and debugging database indexes, queries, stored procedures, views, user-defined functions, and other database entities.

Assist Web and enterprise systems software developers with best practices for writing queries, query tuning and schema refinement, particularly for web services.

Automate complex processes using Databricks, SSIS and SQL Agent jobs.Qualifications:

Use of Microsoft Azure Data Lake, Data Factory, and Data Warehouse

Proficiently in SSIS, Databricks, Data Factory, SQL Server Data Tools, Visual Studio and SQL Server Management Studio 2016+

Experience in SQL performance analysis and optimization (tuning / optimization).

Excellent data modeling and schema design skills, including normalization and de-normalization.

Fluent in C# and/or Python

Experience in Data Sage, Data Mirror, CDC Infosphere a plus

Ability to write and maintain reports using SQL Server Reporting Services (SSRS) and Power BI a plus

You are currently using an outdated browser.

Please consider using a modern browser such as one listed below: