Business Intelligence Developer/Analyst

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

Founded in 1966, Heitman LLC is a global real estate investment management firm with over $36 billion in assets under management. Heitman’s real estate investment strategies include direct investments in the equity or debt capitalization of a property or in the securities of listed and publicly traded real estate companies. Heitman serves a global client base with clients from North American, European, Middle Eastern and Asia-Pacific institutions, pension plans, foundations and corporations and individual investors. Headquartered in Chicago, with offices in Los Angeles, London, Luxembourg, Frankfurt, Munich, Warsaw, Hong Kong, Seoul, Tokyo, and Melbourne, Heitman’s over 300 employees offer specialized expertise – from a specific discipline to local insight.

Job Description

• Develop custom solutions using Microsoft BI Stack (SSIS, SSRS)
• Develop, support, and maintain ETL solutions to accommodate a data warehouse
• Work with Excel, Power Pivots, or VBA to provide various automation and analytic solutions
• Excellent analytical and problem-solving skills, adept at identifying root cause and championing solutions
• Create and maintain requirement documentation, requirements analysis, requirements status reporting
• Coordinate internal and external resources to accomplish requirements objectives, including requirements change management
• Work multiple projects concurrently and shift priorities as required to meet business requirements and deadlines
• Prepare and present requirements status/issues to project manager
• Second line of support for various internal and 3rd party systems
• Interact with users and 3rd party vendor Helpdesk to raise and resolve issues and deploy solutions
• Minimal off hours support

Qualifications

• Must have at least four (4) years of experience designing, developing, testing and implementing ETL solutions. (Specifically Microsoft SSIS)
• Excellent T-SQL skills including stored procedures, functions, & views
• Bachelor's degree (or equivalent work experience or specialized training) in Information Technology (IT), Computer Science (CS), Software Engineering, or related discipline
• Must be able to work both independently and as a team member, support several projects simultaneously and prioritize effectively
• Experience working in a fast pace agile environment
• Ability to effectively prioritize and execute tasks while under pressure
• Excellent listening, interpersonal, written, and oral communication skills
• Ability to document requirements, processes and functional specification using Visio
• Some experience with VB.NET, and SSAS is a plus Familiarity with Trading and back office accounting, and finance software operations is a plus

Equal Employment Opportunity

Heitman is an equal employment opportunity employer and complies with all applicable laws prohibiting discrimination based on race, color, creed, religion, sex, age, national origin or ancestry, physical, medical or mental disability or condition (including, without limitation, HIV and AIDS), developmental disability, handicap, denial of family and medical care leave, denial of pregnancy leave, domestic partner status, status as a victim of sexual or domestic violence (or familial relationship to such victim), veteran status, marital status, sexual orientation, arrest records, citizenship status, criminal history that has been expunged, unfavorable discharge from the military, or any other basis protected by federal, state or local laws.