[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.
Apply tot his job Apply To this Job