SQL BI Engineer: ETL, Data Warehouse & Automation

TechDigital Group; Jersey City (NJ); On-site; USD 95,000 - 135,000; Full time

Job summary

TechDigital Group in Jersey City, NJ is seeking a Skilled SQL BI Developer to design, develop, and maintain ETL processes that support data integration and warehousing for analysis. You will work with data analysts and data scientists to ensure data is available and accurate for reporting.

Responsibilities include building and maintaining SQL-based ETL workflows, automating SSIS packages, and optimizing complex queries for performance and reliability.

Qualifications

• Experience as a SQL ETL Developer or similar role.
• Strong proficiency in SQL and ETL tools (SSIS, Informatica, Talend).
• Experience with data warehousing concepts and technologies.
• Knowledge of database management systems (SQL Server, Oracle, MySQL).
• Familiarity with data visualization tools (Tableau, Power BI).
• Knowledge of scripting languages (Python, Shell, C#).
• Strong problem-solving and communication skills.

Responsibilities

• Design, develop, and maintain ETL processes to support data integration and warehousing.
• Extract, transform, and load data into data warehouses and data marts; ensure data quality.
• Automate SSIS packages and batch processing using schedulers.
• Write and optimize complex SQL queries; develop stored procedures, functions, and triggers.
• Monitor ETL performance, troubleshoot issues, and ensure high availability.

Skills

SQL proficiency

Analytical thinking

Communication

Team collaboration

Independent work

Tools

SSIS

Informatica

Talend

SQL Server

Oracle

MySQL

Tableau

Power BI

Python

Shell scripting

C#

Job description

TechDigital Group in Jersey City, NJ is seeking a Skilled SQL BI Developer to design, develop, and maintain ETL processes that support data integration and warehousing for analysis. You will work with data analysts and data scientists to ensure data is available and accurate for reporting.

Responsibilities include building and maintaining SQL-based ETL workflows, automating SSIS packages, and optimizing complex queries for performance and reliability.