Junior Data Engineer with SQL

Join us, and develop your data competencies

Opportunity with the possibility to work 100% remotely!

As a Junior Data Engineer with SQL, you will be working for our client, a prominent retail company specializing in home furnishings and decor. The client is undertaking a significant project focused on enhancing their data infrastructure and reporting capabilities. In this role, you will play a crucial part in supporting their data initiatives, particularly by leveraging your SQL and Excel expertise to extract, transform, and analyze data. This position offers a unique opportunity for growth and development within the dynamic field of data engineering, allowing you to contribute to meaningful data-driven decisions that impact the company's operations and strategic direction. You will also assist in streamlining some current data processes, taking on tasks that support other teams.

Your main responsibilities:

1. Create complex SQL queries for data extraction, transformation, and analysis
2. Develop and maintain advanced Excel spreadsheets, including those with macros and VBA
3. Assist in the design and implementation of data models for reporting
4. Support the integration of data from various sources into the data warehouse
5. Collaborate with other teams to understand data requirements and deliver solutions
6. Identify and resolve data quality issues
7. Contribute to the continuous improvement of data processes
8. Learn and apply new data engineering tools and technologies

You're ideal for this role if you have:

1. Excellent knowledge of Excel, with macros and VBA being a strong asset
2. Strong SQL skills focused on data analysis, including the ability to create queries for extraction, transformation, and analysis (SELECT, JOIN, GROUP BY, CTE, subqueries)
3. Familiarity with relational databases, understanding data structures, table relationships, primary, and foreign keys
4. Knowledge of data warehousing concepts, including star schema, facts, dimensions, and data modeling basics for reporting
5. A keen interest in data engineering and a desire for further development in this area
6. Basic knowledge of ETL tools (e.g., SSIS, Azure Data Factory, Airflow or similar)
7. Foundational Python skills for working with flat files (e.g., CSV, Excel, JSON, Parquet)
8. Experience with any cloud platform