• 18-Jan-2019 to 19-Mar-2019 (PST)
  • Seattle, WA, USA
  • Full Time

Virtuoso is the leading international travel agency network specializing in luxury and experiential travel. The by-invitation only organization comprises over 800 travel agency partners with more than 16,000 elite travel advisors in over 45 countries through North America, Latin America, the Caribbean, Europe, Asia-Pacific, Africa and the Middle East. Drawing upon its preferred relationships with 1,700 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.


Position Summary: This role actively participates as a senior BI developer, contributing to database architecture & designing, development, implementation, review, enhancing & creating new features within Virtuoso's reporting platform as well as ecosystem, and supporting critical production issues.


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

  • Work effectively with Leads and product owners to define & clarify requirements, assignment priorities, perform detailed analysis, and develop robust & maintainable solutions meeting business requirements
  • Analyze, plan, develop, deploy, and manage BI infrastructure.
  • Create application & SQL automation tests for unit, integration, regression, performance, and build verification
  • Understand and apply the advance principles of entity relationship model design, good data typing practices, index management, data management, and data security.
  • Write reliable and maintainable code at each layer of the application.
  • Develop ad-hoc queries and reports on demand with short turnaround times as determined by business priorities.
  • Research and prototype new database features, design, and architecture ahead of mainstream development.
  • Proactively initiate & contribute in system improvements and innovations.
  • Provide support to troubleshoot and resolve technical & performance issues in production environment.
  • Review designs, code, and test plans of other developers and provide recommendations for improvement or optimizations
  • Follow defined software development lifecycle best practices.
  • Work effectively with management and members to clarify needs and priorities.
  • Miscellaneous duties as assigned.


Educational and Skills Requirements:

  • Master/Bachelor's degree in Computer Science, or STEM (Science, Technology, Engineering, Math) majors, or related experience.
  • 8+ years of database development experience including Data warehouse design & development, SSIS, SSAS, and SSRS.
  • 8+ years of experience in developing database in MS SQL Server utilizing stored procedures, functions, triggers, queries etc. (or alternately 5+ years with an equivalent product such as DB2, Oracle, or MySQL).
  • 4+ years of experience in building online products utilizing C#, ASP.NET MVC, REST web services, middle-tier work, and front-end development.
  • 2+ years of experience building online products utilizing TypeScript/JavaScript, jQuery, HTML (5), CSS3, Less, Sass, JSON/XML REST web services.
  • 2+ years of demonstrated experience managing cross-browser issues.
  • Demonstrated experience on working with at least one scripting language such as PowerShell, Perl, Python, Ruby, or etc. with the intent to automate manual tasks (monitoring, deployments, testing, etc.)
  • Knowledge of SQL Server 2008-2017 including all latest features introduced in SQL Server 2012, 2014, 2016, & 2017.
  • Strong technical and communication skills.
  • Ability to think analytically, plan for future growth of systems/tools, troubleshoot and solve database issues.
  • Desire and ability to work as part of a team with minimal supervision in a results-oriented, fast-paced dynamic environment.
  • Expert level knowledge of TSQL, performance tuning, Query Plans, and Query Plan optimization for TSQL.
  • Expert level knowledge of developing complex Data Warehouses.
  • Experience of developing SSIS, SSAS, SSRS solutions and MDX & DAX queries.
  • Experience working in small teams with a good mix of autonomy and accountability.
  • Experience of managing and developing SQL Server, BI Suite, database custom tools using SQL Server Data Tools/Visual Studio 2013-2015 IDE's.
  • Strategic and in-depth technical understanding and development experience of BI/DW architectures.
  • 2+ years' experience in VSTS/GIT.
  • Preferred:
    • SQL Server 2012/2014 certified.
    • Database architecture and designing experience.
    • Travel industry experience; or Ecommerce experience with CRM or online sales.
    • PowerShell scripting knowledge.
    • Advance level knowledge in SQL automation unit test creation.
    • Experience with B2B data integrations work, including a variety of integration modes (file transfer, web services, SSIS, etc.).
    • Experience/Knowledge integrating new technologies (e.g., Hadoop) with traditional RDBMS
    • Experience/Knowledge in Hadoop ecosystem: Spark, Kafka, Hive, HiveQL, Map Reduce, Yarn, HDFS, etc...


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

  • Apply Now

  • * Fields Are Required

    What is your full name?

    How can we contact you?

  • Share This Page
Logo Advisors Destinations Hotels Cruises Tours About