ETL Developer

Quantum Technologies. LLC; Illinois; Sur place; USD 90 000 - 130 000; Plein temps

Résumé du poste

Quantum Technologies LLC is seeking a data engineer with a strong background in SQL Server, SSIS and data warehousing to design and optimize large-scale data pipelines. You will move and transform data for ODS, staging, data warehousing and marts, implementing star/snowflake schemas and ensuring high performance.

Applicants should have a Bachelor's or Master's in CS, Engineering or a quantitative field and 3+ years of experience in ETL/ELT, data processing and analytics.

Qualifications

• Bachelor’s or Master’s degree in CS, Engineering, Math or another quantitative field.
• 3+ years of experience in developing Batch ETL/ELT processes using SQL Server and SSIS with high-performance pipelines.
• 3+ years writing and optimizing SQL queries and stored procedures for data processing and analytics.
• 3+ years designing and building data pipelines for ODS, Staging, DW and Data Marts using ETL technologies.
• 3+ years implementing Data Warehouse solutions (Star/Snowflake schemas) for reporting and analytics.

Responsabilités

• Design and optimize large-scale data pipelines and ETL/ELT processes.
• Move and transform data for ODS, Staging, Data Warehousing and Data Marts.
• Implement star/snowflake schemas for reporting and analytics.
• Ensure data quality, performance, and governance in data pipelines.

Connaissances

Batch ETL/ELT

SQL Server

SSIS

Data Pipelines

T-SQL

Data Modeling

Data Warehousing

Auditing & Controls

Formation

Bachelor’s or Master’s in CS/Engineering/Math or quantitative field

Outils

SQL Server

SSIS

ETL Tools

Description du poste

Bachelor’s or master's with 3+ experience in Computer Science, Engineering, Math or another quantitative field.

3+ Experience with developing Batch ETL/ELT processes using SQL Server and SSIS ensuring all related data pipelines meets best-in-class standards offering high performance.

3+ experience writing and optimizing SQL queries and stored Procedures for Data Processing and Data Analysis.

3 years of Experience in designing and building complete data pipelines, moving and transforming data for ODS, Staging, Data Warehousing and Data Marts using SQL Server Integration Services (ETL) or other related technologies.

3 + years' experience Implementing Data Warehouse solutions (Star Schema, Snowflake schema) for reporting and analytical applications using SQL Server and SSIS ,or other related technologies.

3+ years' Experience with large-scale data processing and query optimization techniques using TSQL.

2+ years' Experience with implementing audit, balance, and control mechanism in data solutions.

Strong understanding of DW concepts including 3NF and Dimensional data models.

Good understanding of Data Modeling techniques in Data Warehousing projects.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.