Business Intelligence Architect

Virtuoso® is the leading global travel agency network specializing in luxury and experiential travel. This by-invitation-only organization comprises over 1,200 travel agency locations with more than 20,000 travel advisors in 54 countries throughout North America, Latin America, the Caribbean, Europe, Asia-Pacific, Africa and the Middle East. Drawing upon its preferred relationships with more than 2,300 of the world's best hotels and resorts, cruise lines, airlines, tour companies and premier destinations, the network provides its upscale clientele with exclusive amenities, rare experiences and privileged access. Normalized annual sales of (U.S.) $28-$32 billion make Virtuoso a powerhouse in the luxury travel industry. For more information, visit www.virtuoso.com.

As Virtuoso continues to scale our BI department, the Business Intelligence Architect is responsible for designing and developing business management systems and architecture, focusing on data organization to support our internal dashboards and data products.

Essential duties and responsibilities include the following. Other duties may be assigned.

1. Build universes with business logic to support end user decision making.
2. Works with data stewards to develop and implement data mining, storing and analysis methods to improve data management.
3. Drive and specify global design and development principles for external partner reporting.
4. Conduct research and analyses, gathering and analyzing data from BI analysts, troubleshooting programs, creating and implementing test systems, and modifying structures when necessary.
5. Design and development of analysis cubes, star schema, or data mining assets supporting measurement and predictive analysis (feature stores, measure stores, etc.).
6. Develop documentation of changes and procedures to move code changes from development to QA and production.
7. Ensure data accuracy across application interfaces by documenting ETL job process flow.
8. Identify custom extraction needs and document architecture.
9. Review the functional and technical specifications and lead data profiling efforts to uncover data anomalies and inconsistencies.
10. Optimize query performance with indexes, table partitions, unnecessary column removal, and redundant/inconsistent data elimination.

Educational and Skills Requirements:

• Bachelor's degree in any quantitative field (business, math, finance, statistics, computer science, engineering, etc.)
• 7 years of in-depth experience working on business intelligence projects modeling complex data
• Proven ability to translate complex business needs into technical requirements and deliver solutions
• Expert-level proficiency in SQL
• Experience working in Agile/Scrum environment
• 3+ years experience with Snowflake preferred
• 5+ years experience with Tableau preferred
• Detail oriented with strong sense of data accuracy
• Advanced knowledge of the principles of data analysis and data quality
• High level of attention to detail
• Creative problem solving
• Strong written, verbal, and interpersonal communication skills

Travel Requirements:

• Infrequent travel may be required to attend company events (1-3 trips per year).
• Travel will be primarily domestic but may include some international.

Type/Nature of Contacts:

• Internal: Key job contacts are primarily with director level staff and above outside of the job's immediate work unit/department.
• External: Contact possible with members, partners, and outside vendors.

We offer a competitive salary and full benefits package, including medical/dental/vision/life, 401(k) savings plan, and more. Virtuoso is an equal opportunity employer, dedicated to promoting a diverse workforce.

Pay ranges are intended to cover roles based across the United States. An individual's base pay depends on various factors including geographical location, experience, knowledge, skills, and abilities of the applicant.

Location: Fort Worth, TX, US

Posted Date: 12/22/2024