Senior ETL Developer - SQL/SSIS & Data Warehouse

Quantum Technologies. LLC; Illinois; On-site; USD 90,000 - 130,000; Full time

Job summary

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.

Responsibilities

• 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.

Skills

Batch ETL/ELT

SQL Server

SSIS

Data Pipelines

T-SQL

Data Modeling

Data Warehousing

Auditing & Controls

Education

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

Tools

SQL Server

SSIS

ETL Tools

Job description

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.