# Harrison Street [Harrisonst](https://gurify.com/jobs?q=Harrisonst) · Chicago, IL · Posted yesterday Full-time [Data](https://gurify.com/jobs/data) [Apply on the original posting → (opens in a new tab)](https://jobs.lever.co/harrisonst/0738797d-e073-4517-ae86-918a817dbc27) ## Job description Data Engineer Company: Harrison Street Location: Chicago, IL Type: Full-Time Harrison Street Asset Management ("HSAM") is a leading global alternative investment management firm focused on real estate, infrastructure, and credit strategies across North America and Europe. Headquartered in Chicago, Toronto, and London with offices across North America, Europe, Asia and the Middle East, the firm has over $108 billion in assets under management on behalf of institutional investors and registered investment advisors globally. Founded on a culture of innovation, HSAM is an early mover in alternative real estate and mid-market infrastructure. Today, the firm’s global team, consisting of more than 520 professionals, is committed to creating long-term value through deep sector expertise and forward-thinking strategies. Under direction of the Head of Data Analytics & Architecture, Global, the successful Data Engineer candidate will be responsible for designing, building, and maintaining the data infrastructure and systems that support data-driven applications and analytics within Harrison Street. The candidate must have a broad understanding of the entire data & analytics ecosystem of tools and technologies, with hands on experience across the core data domains of business intelligence, data architecture, data science, data engineering, and data visualization. The candidate will analyze the data needs of Harrison Street Asset Management and use their skills in coding to develop and maintain secure data platforms. The successful candidate will be responsible for transforming data into formats that can be more easily analyzed by citizen analysts and data scientists alike. They will do this by developing, maintaining, and testing infrastructures for data generation that enable others within HSAM to more easily access in a secure way the data needed to derive data-driven insights and do their jobs. The Data Engineer will be responsible for the collection, storage, processing, and transformation of large volumes of data to make it accessible, reliable, and usable for analysis and decision-making purposes. The ideal candidate is an experienced data pipeline builder and data wrangler who enjoys optimizing data systems and building them from the ground up. The successful candidate must be self-directed and comfortable supporting the data needs of multiple teams and systems. The right candidate will be excited by the prospect of optimizing our company’s data to support our next generation of investments. Harrison Street requires candidates to have independent, long-term work authorization that does not require future sponsorship or reliance on a third-party immigration process. \n Responsibilities: 60% Data Engineering, Data Architecture, and ETL - Designing, building, and maintaining scalable and efficient data pipelines to extract, transform, and load (ETL) data from various sources into Enterprise Data Platform (EDP). - Designing and implementing data marts, including dimensional modeling, schema design, and optimization techniques. - Integrating and consolidating data from diverse sources, such as databases, sftp’s, APIs, and streaming platforms, ensuring data quality, consistency, and integrity. - Creating and maintaining data models, defining data structures, relationships, and data storage requirements, using techniques like entity-relationship diagrams and data flow diagrams. - Developing data transformation processes, including data cleansing, normalization, aggregation, and enrichment, to prepare data for analytics and reporting. - Identifying and resolving performance bottlenecks in data processing and storage systems, optimizing query performance, and improving overall data pipeline efficiency. - Implementing data quality assurance processes, performing data validation, testing data pipelines, and resolving data quality issues. - Monitoring data pipelines, diagnosing and troubleshooting issues, performing system upgrades and maintenance tasks to ensure data reliability and availability. - Collaborating with cross-functional teams, including Business Liaisons, analysts, and software engineers, and documenting data engineering processes, workflows, and best practices. Supports training of Harrison Street team members on how to properly organize findings and read data collected. - Partners with Technology Infrastructure and Support Operations team to identify, design, and implement internal process improvements: e.g., automating manual processes, optimizing data delivery, and redesigning infrastructure for greater scalability. - Partners with Technology Infrastructure and Support Operations teams to build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using Microsoft Fabric. - Understands how Harrison Street’s data platform integrates within the overall technical architecture. 20% Data Visualization - Solid understanding of data visualization principles, best practices, and design aesthetics. - Develop, maintain, and manage advanced reporting, analytics, dashboards using Tableau and Power BI. - Perform data analysis and validations. - Ability to translate business requirements into technical solutions and effectively communicate with stakeholders. - Experience in data analysis and interpretation to drive actionable insights. 10% Project Management - Work closely with stakeholders to define project goals, scope, and deliverables. - Create project plans, tasks, and timelines using Azure Dev Ops. - Monitor progress to ensure timely completion of milestones and deliverables. - Conduct meetings, provide progress reports, and manage expectations to ensure alignment and stakeholder satisfaction. - Develop risk mitigation and contingency plans to address potential setbacks. - Apply organizational and communication skills to ensure project objectives are met, and deliverables are of high quality within the defined constraints. 5% Cybersecurity Collaboration - Collaborate with the Cybersecurity team to adhere to organizational security standards, secure coding practices, and compliance requirements. - Work jointly with Cybersecurity teams on authentication, authorization, identity management, and secure Enterprise Data Platform development. 5% Miscellaneous - Stay current on emerging technologies for data architecture, data engineering, cloud services, security practices, and AI platform capabilities. - Document system configurations, platform architectures, processes, and operational procedures. - Participate in training, workshops, and internal knowledge-sharing sessions. - Perform other duties as assigned to support evolving business and technology needs. ### Requirements: - Microsoft Certified – Fabric Data Engineer or Azure Data Engineer. - Experience using Tableau and/or Power BI. - Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases. - Experience building and optimizing Azure data Factory pipelines, architectures, and data sets. - Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement. - Strong analytic skills related to working with unstructured datasets. - Build processes supporting data transformation, data structures, metadata, dependency, and workload management. - A successful history of manipulating, processing, and extracting value from large, disconnected datasets. - Strong organizational skills. - Experience supporting and working with cross-functional teams in a dynamic environment. - 5+ years of experience in a Data Engineer role. They should also have experience using the following software/tools: - Experience with Microsoft Fabric or Azure Data Factory. - Experience with relational SQL databases. - Experience with Azure cloud services. - Experience with object-oriented/object function scripting languages: Python, Java, C++, Scala, etc. - Able to compile and organize statistical information retrieved and present findings to management. - Experience working with private and sensitive personal information. - Confident in decision making and the ability to explain processes or choices as needed. - Strong computer skills and ability to use necessary databases and software. - Ability to complete milestones and work toward multiple deadlines simultaneously. - Proficient in data warehousing solutions and ETL tools. - Proficient in database design, data definition, data dictionary, and related concepts. - Understands Machine Learning. - Can leverage data APIs. - Understands app/dev & SDLC. - Knowledge of algorithms and data structures. - Must be able to evaluate technical problems and determine solutions. - Must have strong written and verbal communication skills. - Must be able to follow and apply established security policies, procedures, and standards. - Must be able to read and understand technical manuals and vendor documentation. - Must be able to manage multiple technical workstreams independently. - Must be able to maintain professional and effective working relations with supervisors and co-workers. - Must be able to work flexible hours, including weekends and evenings. - Must be able to learn new skills and technologies. \n$125,000 - $200,000 a year For Illinois Only: The expected base salary range for this position is $125,000 to $200,000. Actual salaries may vary based on a number of factors, including skills, experience, and qualifications. In addition to base salary, total compensation at Harrison Street includes a generous discretionary bonus, along with a comprehensive range of benefits — including medical, financial, and wellness programs — designed to support our employees both professionally and personally. \n Harrison S **Live in Harrisonst’s hiring system.** Read from the company's own applicant tracking system, not reposted from a job board — so it's a real, open requisition rather than an ad that outlived the role. We remove it as soon as it disappears at source. ## More jobs like this - TL [Staff Data Engineer - AI Platform](https://gurify.com/job/staff-data-engineer-ai-platform-at-trm-labs-d14041d83be8) TRM Labs · United States · last week - TL [Senior Data Engineer - AI Platform](https://gurify.com/job/senior-data-engineer-ai-platform-at-trm-labs-fb76e158eae8) TRM Labs · United States · last week - BI [Data Engineer](https://gurify.com/job/data-engineer-at-bioagilytix-7ba47adc4f86) Bioagilytix · Durham, NC · yesterday - JA [Data Engineer - Jane Street](https://gurify.com/job/data-engineer-jane-street-at-janestreet-55f9d6262b38) Janestreet · New York, United States · 5 weeks ago - AR [Data Engineer (.NET / Kafka / ETL)](https://gurify.com/job/data-engineer-net-kafka-etl-at-abra-rnd-412dfc01bf10) Abra RND · Center, Center District, IL · today - SD [Senior Data Engineer – 8+ Years Experience - Hudson Manpower](https://gurify.com/job/senior-data-engineer-8-years-experience-hudson-manpower-1c0c2536db60) New Jersey, United States · 2 days ago ```json {"@context":"https://schema.org/","@type":"JobPosting","title":"Harrison Street","description":"\u003Cp\u003EData Engineer\u003Cbr /\u003ECompany: Harrison Street\u003Cbr /\u003ELocation: Chicago, IL\u003Cbr /\u003EType: Full-Time\u003C/p\u003E\u003Cp\u003EHarrison Street Asset Management (\u0026quot;HSAM\u0026quot;) is a leading global alternative investment management firm focused on real estate, infrastructure, and credit strategies across North America and Europe. Headquartered in Chicago, Toronto, and London with offices across North America, Europe, Asia and the Middle East, the firm has over $108 billion in assets under management on behalf of institutional investors and registered investment advisors globally.\u003C/p\u003E\u003Cp\u003EFounded on a culture of innovation, HSAM is an early mover in alternative real estate and mid-market infrastructure. Today, the firm\u2019s global team, consisting of more than 520 professionals, is committed to creating long-term value through deep sector expertise and forward-thinking strategies.\u003C/p\u003E\u003Cp\u003EUnder direction of the Head of Data Analytics \u0026amp; Architecture, Global, the successful Data Engineer candidate will be responsible for designing, building, and maintaining the data infrastructure and systems that support data-driven applications and analytics within Harrison Street. The candidate must have a broad understanding of the entire data \u0026amp; analytics ecosystem of tools and technologies, with hands on experience across the core data domains of business intelligence, data architecture, data science, data engineering, and data visualization.\u003C/p\u003E\u003Cp\u003EThe candidate will analyze the data needs of Harrison Street Asset Management and use their skills in coding to develop and maintain secure data platforms. The successful candidate will be responsible for transforming data into formats that can be more easily analyzed by citizen analysts and data scientists alike. They will do this by developing, maintaining, and testing infrastructures for data generation that enable others within HSAM to more easily access in a secure way the data needed to derive data-driven insights and do their jobs.\u003C/p\u003E\u003Cp\u003EThe Data Engineer will be responsible for the collection, storage, processing, and transformation of large volumes of data to make it accessible, reliable, and usable for analysis and decision-making purposes. The ideal candidate is an experienced data pipeline builder and data wrangler who enjoys optimizing data systems and building them from the ground up.\u003C/p\u003E\u003Cp\u003EThe successful candidate must be self-directed and comfortable supporting the data needs of multiple teams and systems. The right candidate will be excited by the prospect of optimizing our company\u2019s data to support our next generation of investments.\u003C/p\u003E\u003Cp\u003EHarrison Street requires candidates to have independent, long-term work authorization that does not require future sponsorship or reliance on a third-party immigration process.\u003Cbr /\u003E\\n\u003C/p\u003E\u003Cp\u003EResponsibilities:\u003Cbr /\u003E60% Data Engineering, Data Architecture, and ETL\u003C/p\u003E\u003Cul\u003E\u003Cli\u003EDesigning, building, and maintaining scalable and efficient data pipelines to extract, transform, and load (ETL) data from various sources into Enterprise Data Platform (EDP).\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EDesigning and implementing data marts, including dimensional modeling, schema design, and optimization techniques.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EIntegrating and consolidating data from diverse sources, such as databases, sftp\u2019s, APIs, and streaming platforms, ensuring data quality, consistency, and integrity.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003ECreating and maintaining data models, defining data structures, relationships, and data storage requirements, using techniques like entity-relationship diagrams and data flow diagrams.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EDeveloping data transformation processes, including data cleansing, normalization, aggregation, and enrichment, to prepare data for analytics and reporting.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EIdentifying and resolving performance bottlenecks in data processing and storage systems, optimizing query performance, and improving overall data pipeline efficiency.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EImplementing data quality assurance processes, performing data validation, testing data pipelines, and resolving data quality issues.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EMonitoring data pipelines, diagnosing and troubleshooting issues, performing system upgrades and maintenance tasks to ensure data reliability and availability.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003ECollaborating with cross-functional teams, including Business Liaisons, analysts, and software engineers, and documenting data engineering processes, workflows, and best practices.\u003C/li\u003E\u003C/ul\u003E\u003Cp\u003ESupports training of Harrison Street team members on how to properly organize findings and read data collected.\u003C/p\u003E\u003Cul\u003E\u003Cli\u003EPartners with Technology Infrastructure and Support Operations team to identify, design, and implement internal process improvements: e.g., automating manual processes, optimizing data delivery, and redesigning infrastructure for greater scalability.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EPartners with Technology Infrastructure and Support Operations teams to build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using Microsoft Fabric.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EUnderstands how Harrison Street\u2019s data platform integrates within the overall technical architecture.\u003C/li\u003E\u003C/ul\u003E\u003Cp\u003E20% Data Visualization\u003C/p\u003E\u003Cul\u003E\u003Cli\u003ESolid understanding of data visualization principles, best practices, and design aesthetics.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EDevelop, maintain, and manage advanced reporting, analytics, dashboards using Tableau and Power BI.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EPerform data analysis and validations.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EAbility to translate business requirements into technical solutions and effectively communicate with stakeholders.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EExperience in data analysis and interpretation to drive actionable insights.\u003C/li\u003E\u003C/ul\u003E\u003Cp\u003E10% Project Management\u003C/p\u003E\u003Cul\u003E\u003Cli\u003EWork closely with stakeholders to define project goals, scope, and deliverables.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003ECreate project plans, tasks, and timelines using Azure Dev Ops.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EMonitor progress to ensure timely completion of milestones and deliverables.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EConduct meetings, provide progress reports, and manage expectations to ensure alignment and stakeholder satisfaction.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EDevelop risk mitigation and contingency plans to address potential setbacks.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EApply organizational and communication skills to ensure project objectives are met, and deliverables are of high quality within the defined constraints.\u003C/li\u003E\u003C/ul\u003E\u003Cp\u003E5% Cybersecurity Collaboration\u003C/p\u003E\u003Cul\u003E\u003Cli\u003ECollaborate with the Cybersecurity team to adhere to organizational security standards, secure coding practices, and compliance requirements.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EWork jointly with Cybersecurity teams on authentication, authorization, identity management, and secure Enterprise Data Platform development.\u003C/li\u003E\u003C/ul\u003E\u003Cp\u003E5% Miscellaneous\u003C/p\u003E\u003Cul\u003E\u003Cli\u003EStay current on emerging technologies for data architecture, data engineering, cloud services, security practices, and AI platform capabilities.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EDocument system configurations, platform architectures, processes, and operational procedures.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EParticipate in training, workshops, and internal knowledge-sharing sessions.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EPerform other duties as assigned to support evolving business and technology needs.\u003C/li\u003E\u003C/ul\u003E\u003Ch3\u003ERequirements:\u003C/h3\u003E\u003Cul\u003E\u003Cli\u003EMicrosoft Certified \u2013 Fabric Data Engineer or Azure Data Engineer.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EExperience using Tableau and/or Power BI.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EAdvanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EExperience building and optimizing Azure data Factory pipelines, architectures, and data sets.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EExperience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EStrong analytic skills related to working with unstructured datasets.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EBuild processes supporting data transformation, data structures, metadata, dependency, and workload management.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EA successful history of manipulating, processing, and extracting value from large, disconnected datasets.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EStrong organizational skills.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EExperience supporting and working with cross-functional teams in a dynamic environment.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003E5\u002B years of experience in a Data Engineer role. They should also have experience using the following software/tools:\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EExperience with Microsoft Fabric or Azure Data Factory.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EExperience with relational SQL databases.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EExperience with Azure cloud services.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EExperience with object-oriented/object function scripting languages: Python, Java, C\u002B\u002B, Scala, etc.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EAble to compile and organize statistical information retrieved and present findings to management.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EExperience working with private and sensitive personal information.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EConfident in decision making and the ability to explain processes or choices as needed.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EStrong computer skills and ability to use necessary databases and software.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EAbility to complete milestones and work toward multiple deadlines simultaneously.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EProficient in data warehousing solutions and ETL tools.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EProficient in database design, data definition, data dictionary, and related concepts.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EUnderstands Machine Learning.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003ECan leverage data APIs.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EUnderstands app/dev \u0026amp; SDLC.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EKnowledge of algorithms and data structures.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EMust be able to evaluate technical problems and determine solutions.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EMust have strong written and verbal communication skills.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EMust be able to follow and apply established security policies, procedures, and standards.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EMust be able to read and understand technical manuals and vendor documentation.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EMust be able to manage multiple technical workstreams independently.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EMust be able to maintain professional and effective working relations with supervisors and co-workers.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EMust be able to work flexible hours, including weekends and evenings.\u003C/li\u003E\u003C/ul\u003E\u003Cul\u003E\u003Cli\u003EMust be able to learn new skills and technologies.\u003C/li\u003E\u003C/ul\u003E\u003Cp\u003E\\n$125,000 - $200,000 a year\u003C/p\u003E\u003Cp\u003EFor Illinois Only: The expected base salary range for this position is $125,000 to $200,000. Actual salaries may vary based on a number of factors, including skills, experience, and qualifications.\u003C/p\u003E\u003Cp\u003EIn addition to base salary, total compensation at Harrison Street includes a generous discretionary bonus, along with a comprehensive range of benefits \u2014 including medical, financial, and wellness programs \u2014 designed to support our employees both professionally and personally.\u003C/p\u003E\u003Cp\u003E\\n\u003C/p\u003E\u003Cp\u003EHarrison S\u003C/p\u003E","identifier":{"@type":"PropertyValue","name":"Gurify","value":"harrison-street-at-harrisonst-cc974cd7ce52"},"url":"https://gurify.com/job/harrison-street-at-harrisonst-cc974cd7ce52","datePosted":"2026-08-18","validThrough":"2026-10-03T23:59:59Z","hiringOrganization":{"@type":"Organization","name":"Harrisonst","sameAs":"https://jobs.lever.co/harrisonst"},"directApply":false,"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressCountry":"US","addressLocality":"Chicago"}},"employmentType":"FULL_TIME"} ``` ```json {"@context":"https://schema.org/","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Jobs","item":"https://gurify.com/jobs"},{"@type":"ListItem","position":2,"name":"United States","item":"https://gurify.com/jobs/united-states"},{"@type":"ListItem","position":3,"name":"Harrison Street","item":"https://gurify.com/job/harrison-street-at-harrisonst-cc974cd7ce52"}]} ```