Principal BI Architect

Yext is seeking a talented Principal Business Intelligence Architect in New York or San Francisco. The Principal BI Architect is part of the Business Intelligence team that is responsible for analytics supported by IT across Sales, Marketing, Services, Customer Success, Finance, Product and Engineering. This individual will provide architectural and technical leadership across a number of BI/Data related projects and strategic programs within the organization. 

This role is responsible for the oversight, design and development of solution architectures, application of architectural standards, principles and policies while balancing business needs and ensuring alignment with endorsed strategies, standards and patterns. The role involves extensive stakeholder management with a wide variety of groups and individuals including multiple functional teams, key business stakeholders, BI Analysts and BI support team. This role will report to the Director of IT Enterprise BI.

What You'll Do

• Oversee and ensure execution of multi-year strategies, projects, and ensure adherence to technology standards and best practices.
• Define and document current and future state BI architectures, frameworks and roadmaps.
• Define, implement, and promote BI architectural guidelines/standards, best practices, governing mechanisms, key processes, controls and supporting tools.
• Serve as steward, advisor, and thought leader on all matters related to BI.
• Provide expert guidance on BI skills and technologies.
• Maintain accurate and complete technical architectural documents.
• Support BI tools upgrades in development, testing and documentation.
• Perform maintenance and troubleshooting activities for BI tools.
• Diagnose and resolve BI tool capacity issues.
• Hands-on role (50%) - working on critical ETL fixes, design, development and QA.
• Focus on backend systems (Matillion ETL and AWS infrastructure) as well as front-end (Tableau). 
• Create Tableau Scorecards, Dashboards using stack bars, bar graphs, scatter plots, geographical maps, line/pie graphs, and charts.
• Recommend strategies to improve performance and capacity of BI tools.
• Address customer queries and issues in a timely manner.
• Provide BI administration and technical support during weekends, after-hours and holidays, when needed.
• Provide technical training on BI tools to junior staff.
• Collaborate with BI Analysts, Tableau Developers and Matillion ETL Developers for successful development of BI reporting and analysis solutions.
• Architect and optimize BI Tool infrastructure with a focus on usability, performance, reusability, long-term flexibility, and standardization.

What You Have

• Bachelor’s Degree in Information Technology or related field of study.
• 5 years experience in Enterprise BI Architect role.
• Proven ability to lead large scale enterprise wide initiatives.
• Proven experience providing oversight for multiple, concurrent BI development deliverables.
• Strong business and technical acumen with understanding of BI tools and techniques. 
• 10 years data analytics development experience; at least 5 years experience with Tableau, development, configuration and system administration; 5 Years ETL development experience working with backend systems and large, disparate, and complex datasets. Must have experience with Matillion or tools like Informatica / Talend / Snaplogic.
• Experience with AWS infrastructure (EC2, Redshift, etc.) is a must.
• Demonstrated understanding and familiarity with standard IT process and application development methodologies.
• Proven experience in BI technical leadership for project delivery: technical delivery planning and work.
• Advanced knowledge of Agile-based SDLC practices and application to BI.
• Experience working in complex and large scale project/ program environments requiring extensive internal and external stakeholder management and negotiation.
• Experience working closely with scrum teams and external parties to ensure architecture and design.
• Strong negotiation and people skills to ensure decisions are reached with appropriate speed and followed through to delivery.
• Relevant IT certifications, particularly in data management, business intelligence and architecture.
• Strong knowledge of Data Warehousing and Modeling, good verbal and written skills, strong analytical thinking and problem-solving abilities, considerable strength in Database queries, strong IT skills.
• Expertise in designing and creating schema level objects. This individual should be an expert in building application objects of all kinds including high performance dashboards.
• Technical experience should include full working knowledge of SQL (ability to read and write SQL queries), Architecture and Modeling within a BI Tool, Data warehouse concepts.
• Understanding of performance tuning concepts as they relate to schema objects as well as the underlying database.

#LI-JM1