[Remote] Data Engineer-W2_Remote

Note: The job is a remote job and is open to candidates in USA. ExecutivePlacements.com is looking for a Data Engineer with expertise in EDW, Data Lake, AI/ML, and Omni-Channel experience. The role involves performing Data Development functions, designing and maintaining enterprise database systems, and architecting ETL functions while collaborating with a dynamic team focused on Digital Transformation.

Responsibilities

• Work with a highly dynamic team focused on Digital Transformation
• Understand the domain and business processes to implement successful data pipelines
• Provide work status, and coordinate with Data Engineers
• Manage customer deliverables and regularly report the status via Weekly/Monthly reviews
• Design, develop and maintain ETL processes as well as Stored Procedures, Functions and Views
• Program in T-SQL with relational databases including currently supported versions of Microsoft SQL Server
• Write high performance SQL queries using Joins, Cross Apply, Aggregate Queries, Merge, Pivot
• Design normalized database tables with proper indexing and constraints
• Perform SQL query tuning and performance optimization on complex and inefficient queries
• Provide guidance in the use of table variable, temporary table, CTE appropriately to deal with large datasets
• Collaborate with DBA on database design and performance enhancements
• Leading in all phases of the software development life cycle in a team environment
• Debug existing code and troubleshoot for issues
• Design and provide a framework for maintaining existing data warehouse for reporting and data analytics
• Follow best practices, design, develop, test and document ETL processes

Skills

• Experience with EDW, Data Lake, AI/ML and Omni-Channel
• Strong in Databricks and Azure Data Factory
• Strong in Data Development
• Strong programming skills
• Design of new or enhancement of existing enterprise database systems
• Maintenance and/or development of critical data processes
• Unit and system testing
• Support and help desk tasks
• Defining and adopting best practices for data development functions
• Visualization and ETL processes
• Architecting ETL functions between relational databases and external data files
• Work with a highly dynamic team focused on Digital Transformation
• Understand the domain and business processes to implement successful data pipelines
• Provide work status and coordinate with Data Engineers
• Manage customer deliverables and report status via Weekly/Monthly reviews
• Design, develop and maintain ETL processes as well as Stored Procedures, Functions and Views
• Program in T-SQL with relational databases including currently supported versions of Microsoft SQL Server
• Write high performance SQL queries using Joins, Cross Apply, Aggregate Queries, Merge, Pivot
• Design normalized database tables with proper indexing and constraints
• Perform SQL query tuning and performance optimization on complex and inefficient queries
• Provide guidance in the use of table variable, temporary table, CTE appropriately to deal with large datasets
• Collaborate with DBA on database design and performance enhancements
• Leading in all phases of the software development life cycle in a team environment
• Debug existing code and troubleshoot for issues
• Design and provide a framework for maintaining existing data warehouse for reporting and data analytics
• Follow best practices, design, develop, test and document ETL processes

Company Overview

• Online recruitment It was founded in 2011, and is headquartered in Johannesburg, NA - South Africa, ZAF, with a workforce of 11-50 employees. Its website is https://executiveplacements.com.