ETL Developer
Summary
Build and support ETL pipelines and data warehousing: maintaining inbound/outbound data feeds, designing and coding warehouse solutions, testing and troubleshooting data transfers. Core stack is advanced SQL/T-SQL on SQL Server and Snowflake, with ETL tools like Azure Data Factory, SSIS, Talend, or Domo.
Responsibilities:
Support inbound/ outbound data feeds from the data platform. The resource will also help support various groups (like reporting, devops, testing team, etc.) to help populate data structures
In certain instances, the resource will need to build a solution from scratch and make sure the solution follows the same architecture without over-engineering. There will be both scenarios where existing ETL will need to be modified to add/remove data elements
Designing and coding the data warehousing system to desired company specifications.
Conducting preliminary testing of the warehousing environment before data is extracted.
Extracting company data and transferring it into the new warehousing environment.
Testing the new storage system once all the data has been transferred.
Troubleshooting any issues that may arise.
Requirements:
Holds a college degree in any discipline
Minimum of 2 years just working on various ETL tools. If the resource has advanced experience in Azure Data Factory (1+ years), it's a plus point
Having a minimum of 2 years of experience is a pretty good start as the resource will have had enough exposure on developing in an ETL tools like SQL Server Integration Services (SSIS), Talend, or Domo
Highly skilled in SQL/building stored procedures in both SQL Server and Snowflake (which is a similar skillset). Advanced SQL Skills; T-SQL (MSSQL scripting language)
As for BI, the resource should have an understanding of any methodology
Advanced parameterization skills to dynamically change aspects of the ETL job
Debugging/ Problem Solving skill is a must
Nice to have scripting languages like Python, Perl, or Bash
Data Privacy Consent
By submitting your application for this job, you are authorizing JWay Group to: a) collect and use your personal data, and to disclose such data to any third party with whom JWay Group or any of its related corporations has service arrangements, in each case for all purposes in connection with your job application, and employment with JWay Group or its clients; and b) retain your personal data for consideration of future job opportunities (where applicable for relevant unsuccessful job applicants).