Senior BI and Data Architect
Los Angeles, CA - USA
Job Summary
- End-to-end BI & data architecture and implementation
Own BI solutions across the full data stack:data ingestion and transformation (Synapse Databricks) analytical data models and Power BI semantic models and reports.
Designrobust scalable BI architecturesaligned with enterprise standards.
Act as a bridge betweendata engineering and business analytics ensuring consistency and reusability across reporting tools and theconversational-AIlayer.
Data modelling & analytics
Design andmaintainanalytical data models(star/snowflake)optimizedfor reporting performance andnatural-language querying using clean business-friendly naming and well-defined keys and relationships.
Build and ownPower BI semantic modelswith clean business definitions reusable measures andstrong performancecharacteristics on Fabric capacity.
Develop advancedDAX measures including time intelligencetrendand variance analysis andbooking curves and demand patternsrelevant to the hospitality industry.
ConversationalAIanalytics & Databricks Genie enablement
Design build and curateDatabricks Geniefor key business domains (e.g. bookings & demand revenue management operations) selecting certified tables and metric views and authoring clear instructions example SQL and verified answers so business users receive trustworthy responses.
Build and govern theUnity Catalog semantic layer (metric views)socore KPIs are defined once and reused consistently across Genie AI/BI dashboards and alerts.
Make dataAI/ BI-ready:maintainrich table and column descriptions a business glossary and synonyms / entity matching so Genie reliably maps business language to the correct fields.
Continuouslyevaluate and improve answer accuracy reviewing generatedSQLand refining instructions based on user feedback.
Where valuable extend conversational analytics into the flow of work byembedding Genie in Microsoft Teams or applicationsvia the Conversation API.
Data engineering & transformations
Develop data transformations usingSQL and Python and work with Databricks to prepare clean well-modeled analytical datasets for both BI andconversational-AIconsumption.
Applyanalytics-engineering best practices(layered models clear data contracts tested transformations).
Business partnership & communication
Work closely withbusiness stakeholders(commercial revenue operations leadership) to understand requirements challenge assumptions and translate needs into scalable BI and self-service analytics solutions.
Clearly communicatedata definitions modellimitations andtrade-offsand design decisions.
Help drivedata literacy and trustin BI outputs and AI-generated answers including guidance on how to ask effective questionsthrough prompt engineeringand how to interpret results.
Governance quality & performance
Ensuredata quality and consistencyacross BI models and the AI layer.
Establish and enforceUnity Catalog metadata standards(table/column descriptions tags ownership certification lineage) and ensure Genie respects Unity Catalog permissions row-level security and column masking.
OptimizePower BI models forFabric capacity usage(memory refresh strategy query performance).
Contribute toBI standards best practices and documentation.
Own a strategy aroundshared / certified semantic modelsand metric definitions that serve as thesingle sourceof truth across Power BI and Databricks Genie.
Job Requirements:
Strongend-to-end BI experienceacross data engineering modeling and reporting.
SQL Expert:Able to design optimize and troubleshoot complex analytical queries; deep understanding of joins CTEs window functions aggregations and performance tuning; comfortable validating AI-generated SQL.
Python Advanced:Experience building production-grade data transformation and analytics workflows usingPySpark/Pandas; strong understanding of data quality automation testing and scalable data processing in Databricks.
DAX Strong Working Knowledge:Able to develop complex measures and KPIs including time intelligencetrendand variance analysis; understands evaluation context filter propagation and performance optimization within Power BI semantic models.
Power BI: semantic model design performance optimization Fabric capacity awareness.
Databricks SQL and Unity Catalog hands-on experience with catalogs schemas governance lineage and permissions.
Dimensional / semantic data modelingwith clean business-friendly naming and well-defined keys and relationships (the foundation for reliable natural-language querying).
Strong data-documentation discipline(descriptions business glossary certified definitions).
Experience working withfinancial / accounting data.
Proven ability tocommunicate effectively with businessstakeholders.
What We Offer You:
Highly competitive compensation plan.
Salaryrange$190000-$220000 annuallydeterminedby a myriad of factors including but not limited to years of experience depth of experience and other relevant business considerations.
Employees are eligible for annual discretionary bonus.
401(k) plan with company match.
Employee Share Purchase Plan (ESPP)Viking full-time regular employees working in the United States canpurchaseViking shares through payroll deductions.
Full benefits including medical dental visionlifeand disability insurance at a highly subsidized rate (some plans are fully paid by Viking).
Accrue 15 paid vacation days sick time accrual by state and 6 paid holidays per year.
Opportunity to take a free and/or discounted cruise.
Highly subsidized gym membership.
Discounts on theatres theme parks movie tickets travel discounts through IATA membership and too many more discounts to name.
Viking is a certified Great Place to Work company. This certification is a result of our commitment to excellenceintegrityand our teams outstanding contributions.
About Viking
Viking (NYSE: VIK) is a global leader in experiential travel with a fleet of more than 100 ships exploring 21 rivers fiveoceansand all seven continents. Designed for curious travelers with interests in science history culture and cuisineChairmanand CEO Torstein Hagen oftensaysViking offers experiences ForTheThinking Person. Viking has more than 450 awards to its name including being rated #1 for Rivers and #1 for Oceans five years in a row byCondé Nast Travelerinthe 2025 Readers Choice Awards. Viking is alsorateda Worlds Best byTravel Leisureno other travel company has simultaneously received such honorsbyboth publications.
Required Experience:
Senior IC