[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 Apply tot his job