Data Integration Engineer

Denver, CO, United States

Firm Overview

Northwood Investors LLC (“Northwood”) is a leading, privately held, global real estate private equity investment advisor that invests alongside institutional and private clients in a broad range of real estate opportunities, with $7 billion of equity capital currently under management.

Northwood was founded in 2006, by John Z. Kukral, the former President and CEO of Blackstone Real Estate Advisors. The Northwood team is comprised of over 200 real estate professionals with deep experience in sourcing, executing, and managing real estate transactions worldwide, ranging from office buildings and shopping centers to hotels and residential investments.

Northwood has locations in the US in Denver, New York, Dallas, Los Angeles, and Charlotte.

Additionally, the firm has professional teams located in the United Kingdom, Luxembourg, and Paris.

For more information, visit Northwood’s website at www.northwoodinvestors.com.

Position Overview

This position of Data Integration Engineer is based in Denver reporting to the Director of Data & Analytics. This role is invested in the data warehousing project to further Northwood reporting and analysis for decisions management. The Data Integration Engineer will be involved in a variety of areas inclusive of integration development, business application workflows, process automation, and delivering Northwood business data application requirements and reporting.

The ideal candidate has Data Integration / Business Systems / Finance related experience and is looking for the opportunity to get broad exposure and grow their current skill set within an industry leading dynamic organization.

Key Responsibilities

Data Integration Development

Responsible for ETL workflow solutions to build historical data layers of new datasets, production deployments of complex loads and support of metadata framework methodologies.

Works with internal stakeholders and third-party vendors to develop and maintain data pipelines sourcing data from disparate source systems.

Builds and maintains python pipeline development and manages infrastructure monitoring.

Collaborate with internal business systems and external vendors to aggregate, transform, and interpret data from multiple sources to help structure data in a centralized data warehouse

Analyze processes and data to identify problem areas and assist with making recommendations for system modifications or other improvements.

Business Data Management

Assist in supporting project teams to deliver solutions to optimize business efficiencies for Northwood and participate in special project initiatives to support technology needs for the business.

Maintains documentation best practices for written code/procedures including mapping documents.

Supports the development and deployment of business intelligence and data visualization tools.

Supports change management around existing data warehouse reports and deliverables based on business feedback.

Education And Required Experience

Bachelor degree in Information Systems, Software Engineering, or similar technical discipline

Experience writing complex SQL and takes initiative in SQL script tuning/performance optimization, including debugging and error checking.

Experience using Office 365, specifically Excel (Power Pivot, Power Query) and Power Automate

Experience using ETL tools such as SSIS, Alteryx, Informatica, DataStage, Pentaho, DBT, Azure Data Factory

Experience preparing user-facing reports with Power BI or similar tool

Desired Skills

Experience developing and deploying AWS Microservices, specifically with Lambda and EC2

Experience developing/supporting/troubleshooting Visual Basic code, Shell Scripting, Python/JavaScript

Knowledge and experience of cloud architecture patterns, and the cloud platforms, especially AWS

Knowledge of the financial industry and investment data management concepts

Knowledge of Business Intelligence Tools (SSRS, Power BI, OBIEE, Tableau, etc.)

Knowledge of Snowflake Data Warehousing environments, Oracle DB, MySQL, Postgres SQL.

Knowledge of MRI, Yardi, Investran, or similar ERP systems

Skills & Other Qualifications Considerations

Excellent interpersonal, leadership, presentation, and collaborative skills to work effectively within a team with other teams throughout organization.

Excellent written/verbal communication and presentation skills to best translate technical into business understandable terminologies.

Promotes a culture of excellence, data driven discussions, healthy skepticism, intellectual curiosity, knowledge sharing, and teamwork, while maintaining an environment that is upbeat and fun.

Energetic intellectual curiosity with an earning for learning and expanding skill set who knows how to ask the right questions.

Highly analytical mode of thinking that balances creativity and organization when problem-solving.

Effectively handle multiple deliverables with full ownership and responsibility.

Ability to self-manage time and accurately prioritize workloads.

Ability to promote process improvement and be highly adaptable to evolving business needs.

#J-18808-Ljbffr