Data Warehouse Architect

Company Description

ABOUT STREAM REALTY PARTNERS

Founded in 1996, Stream Realty Partners (Stream) began with a vision. Not one focused on bricks and mortar, but with people at its foundation. With 215+ million square feet of assignments and more than $5.8 billion in annual transactions, we are one of the fastest-growing, full-service commercial real estate services organizations in the country. We’ve grown from our two original partners to 1,200+ talented individuals that come together to create our distinct culture, best summarized by our firm’s core values: smart, honest, nice, and passionate.

IMMEDIATE IMPACT. MEANINGFUL CAREER.

At Stream, we know our success begins and ends with our people. It’s the reason we work hard to attract and retain the best and brightest talent. From day one, you will be an integral member of our high-caliber, collaborative team. We will empower you to apply your energy, expertise, and creativity to meet our clients’ needs while instilling you with unsurpassed market knowledge and development opportunities to succeed. When you join Stream, you won’t simply start a new job—you will build a meaningful and impactful career.

Job Description

The Data Warehouse Architect role involves strategically designing and implementing data warehouses, data marts, and data stores as well as requisite ETL (Extract, Transform, Load) and visualization (reporting) development while ensuring high levels of data availability. This individual is also responsible for collaborating to define enterprise data standards and models for warehouse architectures. The Data Warehouse Architect will also evaluate and provide input on infrastructure components such as software, hardware, database management systems, and networking capabilities.  The individual is expected to have expertise in the underlying technology and function effectively at collaboratively defining business solutions and technology policies, while remaining hands-on within the technology environment.  This position will office in Stream’s Dallas, Texas corporate office, and report to the SVP, Technology Business Solutions.

PRIMARY RESPONSIBILITIES

Strategy & Planning

• Assess and cultivate long-term strategic goals for data warehousing in conjunction with IT architect(s), data users, department managers, clients, and other key stakeholders.
• Coordinate and work with other technical staff to develop database architectures, coding standards, and quality assurance policies and procedures.
• Plan and implement capacity and resource expansion to ensure data warehouse scalability.
• Design and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective availability, protection, and integrity of data assets.

Acquisition & Deployment

• Conduct research and make recommendations on data warehouse products, services, protocols, and standards in support of procurement and development efforts.
• Evaluate, recommend, and select data warehouse components, including hardware, database management systems, ETL (extract, transform, load) software, data mining tools, and meta data management tools.

Operational Management

• Oversee data collection and master data and database(s).
• Work with end users to identify, create, and deliver reports according to requirements.
• Create models for new data warehouse development and/or changes to existing data stores.
• Create and support relevant supporting ETL layer needed for enterprise data warehouse platform.
• Design and manage data warehouse improvement and growth projects.
• Identify inefficiencies and gaps in current data warehouses and leverage solutions to ensure data standards.
• Identify data discrepancies and data quality issues, and work to ensure data consistency and integrity.
• Diagnose and resolve data warehouse access and performance issues.
• Install and configure relevant components to ensure data warehouse access.
• Execute data warehouse configuration and performance tuning.
• Monitor system details within the data warehouse, including stored procedures and execution time, and implement efficiency improvements.
• Develop, implement, and maintain change control and testing processes for modifications to data systems.

Support Operations

• Troubleshoot and resolve Tier 2/3 domain system issues or malfunctions.
• Coordinate Tier 3 escalations to relevant vendor.
• Analyze the current business and IT environment to detect critical deficiencies and recommend solutions for improvement.
• Work with the SVP Technology Business Solutions and BSMs to ensure the successful delivery of key strategic projects.

Manage Projects