Data is everywhere. Data is essential to our customers. We need their data in our systems. That’s where you come in. We are currently seeking a SQL developer to design and implement ETL processes to inject customer data into our Products. We are looking for someone who is passionate about data, someone who enjoys looking and dissecting new data sets, and understanding the stories that they tell. Your main responsibility will be to leverage your SQL expertise to feed data from heterogeneous sources into our systems.

𝗥𝗲𝗾𝘂𝗶𝗿𝗲𝗺𝗲𝗻𝘁𝘀

Design, develop, and implement ETL processes to extract data from diverse sources, transform it according to business requirements, and load it into databases.

Collaborate with Project Managers to understand data requirements and design the procedures.

Execute data assessments and migrations for customers assigned to you.

Write complex SQL queries, stored procedures, and scripts to manipulate and cleanse data during the ETL process per client’s expectations.

Optimize ETL workflows for performance, scalability, and reliability, ensuring efficient data extraction, transformation, and loading.

Conduct thorough testing and validation of ETL processes to ensure accuracy, completeness, and data integrity.

Troubleshoot and resolve issues related to data quality, performance, and ETL failures in a timely manner.

Document ETL processes, data mappings, and technical specifications to facilitate knowledge sharing and ensure maintainability.

𝗗𝗲𝘀𝗶𝗿𝗲𝗱 𝗦𝗸𝗶𝗹𝗹𝘀 𝗮𝗻𝗱 𝗘𝘅𝗽𝗲𝗿𝗶𝗲𝗻𝗰𝗲

Strong experience with ETL and database technologies

In depth experience with MS SQL Server, incl. SQL Server Management Studio Superior SQL knowledge (stored procedures, user defined functions, etc.) as well as an intimate understanding of database structure

Familiarity with an IDE and a version control management tool, preferably Visual Studio, Azure DevOps and Git

Knowledge of various SQL/NoSQL data storage mechanisms

Nice to have knowledge with scripting and programming, including SQL, shell scripting, or Python

Ability to adapt to a rapidly changing product and respond strategically to customer needs, and work in a fast-paced environment

𝗡𝗼𝘁𝗲: Ideal candidates might also possess one or more of the following:

Paralegal or equivalent legal experience

C# prior programming experience