Data Warehouse ETL Developer

$125,000 - $125,000/Yr

Itnova - Jersey City, NJ

Full-time - Mid Level

Jersey City, NJ

Professional, Scientific, and Technical Services

About the position

ITnova is seeking a Data Warehouse / ETL Developer with over 8 years of experience in designing, developing, and supporting Data Warehouse and ETL processes. The role requires strong technical skills in SSIS, SSAS, SSRS, and T-SQL, along with experience in Azure data platforms and business intelligence tools like Power BI or Tableau. The developer will be responsible for maintaining ETL jobs, optimizing query performance, and independently resolving issues.

Responsibilities

• Design, develop, and support Data Warehouse and ETL processes.
• Maintain and monitor ETL jobs to ensure timely completion.
• Optimize query performance and work with Reporting and DBA teams for tuning.
• Write complex T-SQL Queries, Stored Procedures, and Views.
• Work with Azure SQL database, Azure Data Factory, and related Azure services.
• Act independently to resolve issues and communicate effectively with team members.

Requirements

• 8+ years of experience in Data Warehouse and ETL processes.
• Strong experience with SQL Server Integration Services (SSIS), SSAS, and SSRS.
• Proficient in writing complex T-SQL Queries, Stored Procedures, and Views.
• Experience with Azure data platforms and business intelligence tools like Power BI or Tableau.
• Excellent communication and interpersonal skills.

Nice-to-haves

• Experience with Cognos BI environment or similar business intelligence tools.

Benefits

• 401(k)
• Dental insurance
• Health insurance
• Paid time off
• Tuition reimbursement
• Vision insurance