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 Dallas, TX corporate office, and report to the SVP, Technology Business Solutions.
• This position offices in Dallas, TX and is a hybrid role (onsite to start).
QUALIFICATIONS • 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 Power BI. • 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 and Agile) experience. • Good knowledge of applicable data privacy practices and laws.
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.
**FOR IMMEDIARE CONSIDERATION, PLEASE SEND A COPY OF YOUR UPDATED RESUME.