Senior Data Warehouse Engineer at Stream Realty

STREAM’S CURRENT ENVIRONMENT

• In many ways, Stream operates as a complex matrix organization at the intersection of geographic markets and business functions. Due to the varying size and maturity of individual markets, the resources and processes present to support business functions vary across markets. This complicates the definition of data integrity and analytics.

• As Stream continues to grow an increased emphasis has been placed on quality data and enterprise analytics solutions that can support rapid growth and scale for the future. Speed, automation, accuracy, and self-service functionality will be key in achieving these goals.

• Stream utilizes a variety of domain-specific ERPs (Financial, CRM, HR, etc.) and it is vital for leadership to have the ability to evaluate datasets across multiple departments in a flexible and robust manner.

Position Overview

The Data Warehouse Engineer will play a critical role in advancing Stream Realty Partners’ enterprise analytics strategy by designing and implementing scalable, Azure-based data solutions. This individual will leverage Microsoft Azure Fabric and related technologies to modernize Stream’s data warehouse environment, ensuring speed, accuracy, and scalability.

Beyond technical delivery, this role will serve as a champion for Business Intelligence (BI) across the firm—empowering business units with trusted data, promoting self-service analytics, and training end users and colleagues to expand data literacy.

---

Primary Responsibilities
 

Strategy & Planning

· Develop long-term data warehouse strategies aligned with business goals, emphasizing Azure Fabric and cloud-first approaches.

· Define enterprise data standards, models, and architectures to support robust BI adoption.

· Drive automation, scalability, and self-service capabilities to support Stream’s growth.
 

Acquisition & Deployment

· Recommend and implement modern Azure data solutions (Azure Fabric, Synapse, Data Lake, Data Factory, Databricks, Snowflake, etc.).

· Select and configure optimal ETL/ELT tools to ensure seamless integration of enterprise data sources.

· Continuously evaluate emerging Azure services for innovation opportunities.
 

Operational Management

· Design and maintain efficient data pipelines and models to support Power BI and enterprise reporting.

· Proactively monitor, troubleshoot, and optimize warehouse performance.

· Ensure data integrity, security, and compliance across all environments.

· Collaborate with stakeholders to deliver dashboards, KPIs, and BI reports that drive actionable insights.
 

Training & BI Promotion

· Act as a trusted advisor and mentor for business stakeholders, analysts, and technical staff.

· Deliver training sessions and workshops on Power BI, self-service analytics, and data best practices.

· Foster a data-driven culture by promoting BI adoption and advocating for accessible, high-quality data across the firm.
 

Support & Project Delivery

· Support Tier 2/3 data issues, escalating to vendors as needed.

· Manage technical and functional projects—including SharePoint, Teams, and enterprise reporting initiatives.

· Partner with business leaders to ensure data and BI solutions directly support strategic priorities.