SQL Server & SSIS ETL developer

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

Location - Warren, NJ - Resource should be In person 3 days a week at client office (Hybrid)

Job Description -

Lead and guide developers responsible for ETL development, data pipelines, and data warehouse loads.

Design, develop, and optimize complex SQL queries, stored procedures, functions, and views.

Build and maintain workflows for data ingestion, cleansing, transformation, and transfer using SQL Server Integration Services (SSIS) and SQL.

Demonstrated Experience with Microsoft SQL Server 2019 and above including managing databases.

• Demonstrated experience working with Microsoft SSIS to create and deploy packages and deploy for ETL processes.
• Demonstrated experience around writing and troubleshooting T-SQL statements, creating stored procedures, views, and SQL functions.
• Understands different data models like normalized, de-normalized, stars, and snowflake models.
• Strong SQL coding experience with performance optimization experience for data queries.
• Ability to multi-task and thrive in fast paced, rapidly changing, and complex environment.
• Work with team members to identify and resolve technical issues in a timely fashion.
• Analyse problems and communicate with stake holders to assess needs and determine optimal solutions.
• Deep understanding of data warehousing concepts
• Experience using Azure Devops and CICD pipeline for deployments
• Strong understanding of data structures and formats such as JSON and XML and SSIS Scripting.

ETHEREUM TECHNOLOGIES LLC is an equal opportunity employer inclusive of female, minority, disability and veterans, (M/F/D/V). Hiring, promotion, transfer, compensation, benefits, discipline, termination and all other employment decisions are made without regard to race, color, religion, sex, sexual orientation, gender identity, age, disability, national origin, citizenship/immigration status, veteran status or any other protected status. ETHEREUM TECHNOLOGIES LLC will not make any posting or employment decision that does not comply with applicable laws relating to labor and employment, equal opportunity, employment eligibility requirements or related matters. Nor will ETHEREUM TECHNOLOGIES LLC require in a posting or otherwise U.S. citizenship or lawful permanent residency in the U.S. as a condition of employment except as necessary to comply with law, regulation, executive order, or federal, state, or local government contract