BI Data Engineer - ETL/SSIS & Analytics

Heitman; Chicago (IL); On-site; USD 80,000 - 120,000; Full time

Job summary

Heitman, based in Chicago, is seeking a skilled ETL Developer to design, develop, and implement ETL solutions using Microsoft BI Stack. The ideal candidate will have over 4 years of experience with SSIS and excellent T-SQL skills. This position demands strong problem-solving abilities and the capacity to manage multiple projects effectively.

Responsibilities include supporting various internal systems and creating requirement documentation while interacting with users to resolve issues. Join our dynamic team where your expertise can make an impact!

Qualifications

• 4+ years of experience designing, developing, testing, and implementing ETL solutions, specifically Microsoft SSIS.
• Excellent T-SQL skills, including stored procedures and functions.
• Ability to work independently and on multiple projects simultaneously.

Responsibilities

• Develop custom solutions using Microsoft BI Stack (SSIS, SSRS).
• Maintain ETL solutions for data warehouse.
• Communicate status of requirements and issues to project manager.

Skills

ETL solutions design and implementation

T-SQL skills

VBA

Microsoft BI Stack (SSIS, SSRS)

Documentation skills using Visio

Education

Bachelor's degree in Information Technology, Computer Science, Software Engineering, or related discipline

Tools

VB.NET

SSAS

Job description

Heitman, based in Chicago, is seeking a skilled ETL Developer to design, develop, and implement ETL solutions using Microsoft BI Stack. The ideal candidate will have over 4 years of experience with SSIS and excellent T-SQL skills. This position demands strong problem-solving abilities and the capacity to manage multiple projects effectively.

Responsibilities include supporting various internal systems and creating requirement documentation while interacting with users to resolve issues. Join our dynamic team where your expertise can make an impact!