Principal BI Architect
Yext (NYSE: YEXT) is building the next big thing in AI search, and the next big thing is answers.
With the explosion of information and data online, search has never been more important. However, while the world of consumer search has innovated over time, enterprise search has not. In fact, the majority of enterprise search is powered by outdated keyword technology that only scans for keywords and delivers a list of hyperlinks rather than actually answering questions. Yext, the AI Search Company, offers a modern, AI-powered Answers Platform that understands natural language so that when people ask questions about a business online they get direct answers – not links.
We have a big, audacious mission to transform the enterprise with AI search. To achieve that, we need bright minds and diverse perspectives to join our growing company and help us continue to disrupt an industry. Does this sound like you?
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.
- Run bi-monthly BI cross-functional strategy forum across business and IT and own the overall BI roadmap, end-to-end BI programs, architecture & design.
- Define, implement, and promote BI architectural guidelines/standards, best practices, governing mechanisms, key processes, controls and supporting tools.
- Design complex or high visibility dashboards in Tableau including predictive reporting.
- 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 fixes, design, development and QA.
- Focus more on the front-end system (Tableau) but at the same time be familiar with the backend systems (Matillion ETL, AWS infrastructure, Redshift & Snowflake data warehouse).
- 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.
- Should have the ability to drive process improvement tracking and execution.
- Strong business and technical acumen with understanding of BI tools and techniques.
- 10+ years data analytics development experience; at least 7+ years experience with Tableau, development, configuration and system administration; 3+ 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 and Redshift/Snowflake data warehouse 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.
- Knowledge of Enterprise Business Applications - Salesforce products (Sales Cloud, Community Cloud, CPQ), Zuora, Callidus, Coupa.
- 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-CD1
Yext is committed to building an inclusive and diverse culture where every person is seen, heard and valued. We believe in equal employment opportunity and welcome employees and applicants of all races, colors, ethnicities, religions, creeds, national origins, ancestries, genetics, sexes, pregnancy or childbirth, sexual orientations, genders (including gender identity or nonbinary or nonconformity and/or status as a trans individual), ages, physical or mental disabilities, citizenships, marital, parental and/or familial status, past, current or prospective service in the uniformed services, or any characteristic protected under applicable law. We also consider qualified applicants regardless of criminal histories, consistent with legal requirements. It is Yext’s policy to provide reasonable accommodations to people with disabilities as required by law. If you have a disability that requires an accommodation in completing this application, interviewing, or participating in the employee selection process, please complete this form.