Senior SQL BI Engineer — ETL & Data Warehousing

Inherent Technologies, Inc.; Jersey City (NJ); On-site; USD 110,000 - 140,000; Full time

Job summary

Inherent Technologies, Inc. in Jersey City, NJ seeks a Senior SQL BI Developer to design, develop, and maintain ETL processes powering data warehousing and analytics.

You will work with data analysts and data scientists to ensure accurate data availability and performant reports. Responsibilities include building and maintaining ETL pipelines with SQL and tools like SSIS, Informatica or Talend, optimizing queries, automating packages with SQL Agent, and documenting data flows.

Qualifications

• Bachelor's degree in computer science or related field.
• Extensive experience designing and maintaining ETL processes.
• Proficiency in SQL and ETL tools.

Responsibilities

• Design, develop, and maintain ETL processes using SQL and ETL tools.
• Extract, transform, and load data from various data sources into data warehouses and data marts.
• Write and optimize complex SQL queries for data extraction and reporting.
• Automate SSIS packages using SQL Agent.
• Monitor and optimize ETL performance and data quality.
• Collaborate with data analysts and data scientists.

Skills

SQL

ETL

Data Warehousing

Data Quality

Problem-solving

Communication

Independent work

Team collaboration

Education

Bachelor's degree in Computer Science

Tools

SSIS

Informatica

Talend

SQL Server

Oracle

MySQL

Tableau

Power BI

Python

C#

Job description

Inherent Technologies, Inc. in Jersey City, NJ seeks a Senior SQL BI Developer to design, develop, and maintain ETL processes powering data warehousing and analytics.

You will work with data analysts and data scientists to ensure accurate data availability and performant reports. Responsibilities include building and maintaining ETL pipelines with SQL and tools like SSIS, Informatica or Talend, optimizing queries, automating packages with SQL Agent, and documenting data flows.