SQL Server Database Architect

Chicago, Illinois


Company Description

Founded in 1966, Heitman LLC is a global real estate investment management firm with over $44 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 additional offices in North America, Europe, and Asia-Pacific, Heitman’s more than 325 employees offer specialized expertise – from a specific discipline to local insight.

Job Description

Our Chicago office is seeking a SQL Server Database Architect to join their dynamic Global Information Technology team! The ideal candidate will have experience developing and architecting Business Intelligence solutions in data warehousing environment.

The responsibilities of a SQL Server Database Architect include, but are not limited to:

  • Extensive knowledge of data modeling techniques including relational database modeling and star schema
  • Experience in performance tuning, understanding explain and execution plans
  • Evangelize self-service BI and visual discovery while helping to change Excel based culture.
  • Knowledge of Microsoft SQL Server Stack (SSIS, SSRS, SSAS and Power BI).
  • Understanding and working experience of Database Materialized Views/Snapshots.
  • Experience working in Microsoft Azure Cloud environment with knowledge of Azure Data Factory , Azure Data Lake and Azure SQL Data warehouse, Azure Analysis Services and Azure ML
  • Build technical documentation
  • Design, develop, tune and maintain ETL jobs and SSAS Tabular Models
  • Design, develop, tune and maintain SSAS Tabular Models
  • Analytics Solution: Azure Analysis Services, Azure Analysis Services


  • Minimum 10 years of Database Architecture experience in SQL Server environment
  • Minimum 6 years performance tuning in SQL Server environment
  • Minimum 6 years of experience with Microsoft SSIS, SSRS, SSAS
  • Minimum 1 year experience with Microsoft Azure Cloud
  • Experience with Investment data warehouse is a plus
  • Strong problem solving, time management, interpersonal and organizational skills
  • Bachelor’s Degree in related field or equivalent experience

Additional Information

Interested professionals should apply via our website at 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.

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.