Business Intelligence Developer/Analyst

Company: Heitman

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.

• 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

Requirements

• 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

Interested professionals should apply via our website at www.heitman.com. Please make sure to select “careers” under the About tab to submit your cover letter and resume. If you are a Heitman employee, please make sure to apply using your Heitman email address.

NO PHONE CALLS PLEASE

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.