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

Plan and Manage SharePoint and Teams project schedules, resources, budgets, and manage stakeholder expectations, providing timely communications and reporting.

Technical projects and upgrades Business functional projects

Qualifications

Knowledge & Experience

Working technical experience with designing, building, installing, configuring and supporting multi-terabyte data warehouses. Experience with database platforms, including SQL Server and/or Azure. Experience developing analytics within PowerBI. Experience transforming data via ETL concepts. Strong understanding of relational database structures, theories, principles, and practices. Hands-on experience with data architecting, data mining, large-scale data modeling, and business requirements gathering/analysis. Knowledge of Windows operating system, as well as Power BI, and Office 365 including diagnostic tools preferred. Experience with data processing flowcharting techniques. Proven project management (Waterfall+Agile) experience. Good knowledge of applicable data privacy practices and laws. Formal Education & Certification

College diploma or university degree in the field of computer science, information systems, or computer engineering and 5+ years of relevant work experience. Certifications in architecture frameworks such as Zachman or TOGAF is a plus. Certifications in Agile/Scrum methodology is a plus. Experience in Commercial Real Estate (CRE) Industry is a plus. Personal Attributes

Exceptional analytical, conceptual, and problem-solving abilities. Continuous improvements and scalability focused - not simply an 'order taker' Strong written and oral communication skills. Excellent technical architecture and technical support documentation skills. Strong presentation and interpersonal skills. Ability to conduct research into database issues, standards, and products as required. Ability to present ideas in user-friendly language. Ability to effectively prioritize and execute tasks in a high-pressure environment. Experience working in a team-oriented, collaborative environment. This position offices in Dallas, TX and is an in-person, in-office role.

Additional Information

Stream Realty Partners offers competitive salaries, annual bonuses, medical, dental, and vision insurance, 401(k) with company matching, pharmacy benefits, flexible spending accounts, health savings account, vacation pay, volunteer & community involvement paid time off, and holiday pay.

All information is held in compliance with EEOC guidelines. Stream is an equal-opportunity employer committed to fostering an inclusive environment. We are committed to equal employment opportunity regardless of race, color, religion, religious creed, national origin, ancestry, citizenship, physical or mental disability, medical condition, genetic information, marital status, sex, gender, gender identity, age, sexual orientation, veteran and/or military status, or any other status protected by federal, state, or local laws. If you have a disability or special need that requires accommodation, please contact us at Recruiting@streamrealty.com.

Note: Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time.

#LI-OnSite #J-18808-Ljbffr