Senior SQL Server & SSIS ETL Lead (Hybrid)

Ethereum Technologies LLC; New Jersey; Hybrid; USD 100,000 - 150,000; Full time

Job summary

Ethereum Technologies LLC is seeking a hands-on ETL/Data Warehouse Engineer to lead developers on ETL pipelines and data loads. You will design and optimize complex SQL queries, build SSIS workflows, and manage databases. Strong T-SQL, data modeling, and CI/CD deployments are essential in a fast-paced environment.

Hybrid work from Warren, NJ with in-person collaboration 3 days per week at the client office. Experience with Azure DevOps, JSON/XML, and modern data warehousing concepts is required.

Qualifications

• Experience with Microsoft SQL Server 2019 and above.
• Proficient in SSIS packages for ETL processes.
• Strong T-SQL development and performance tuning skills.
• Knowledge of data models: star/snowflake and normalization.
• Experience with JSON and XML data formats.
• Azure DevOps and CI/CD deployments experience.
• Ability to multitask in a fast-paced, complex environment.
• Communicate with stakeholders to determine needs and solutions.

Responsibilities

• Lead and guide developers responsible for ETL development and data pipelines.
• Design, develop, and optimize complex SQL queries, stored procedures, functions, and views.
• Build and maintain workflows for data ingestion, cleansing, transformation, and transfer using SSIS and SQL.
• Manage databases and ensure performance and reliability.
• Collaborate with team to identify issues and deploy timely resolutions.
• Analyze problems and translate requirements into scalable data solutions.
• Apply data warehousing concepts and model structures for reporting needs.
• Utilize Azure DevOps and CI/CD pipelines for deployments.

Skills

SQL development

Data warehousing

Stakeholder communication

Multi-tasking

Problem solving

Analytical thinking

Tools

SSIS

Azure DevOps

CI/CD deployments

SQL Server 2019+

JSON

XML

Job description

Ethereum Technologies LLC is seeking a hands-on ETL/Data Warehouse Engineer to lead developers on ETL pipelines and data loads. You will design and optimize complex SQL queries, build SSIS workflows, and manage databases. Strong T-SQL, data modeling, and CI/CD deployments are essential in a fast-paced environment.

Hybrid work from Warren, NJ with in-person collaboration 3 days per week at the client office. Experience with Azure DevOps, JSON/XML, and modern data warehousing concepts is required.