Virtuoso
  • 26-Sep-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 1,000 travel agency locations with 20,000 elite travel advisors in over 50 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 Virtuoso.com ecosystem, and supporting critical production issues.

Essential Functions:

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

 

Qualifications:

  • 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 a 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 development experience with Graph Database technologies (e.g. Neo4j, GraphDB, Microsoft)
  • Expert-level knowledge of TSQL, performance tuning, Query Plans, and Query Plan optimization for TSQL.
  • Expert-level knowledge of developing complex Data Warehouses
  • Advance level experience of developing SSIS, SSAS, SSRS solutions, and MDX & DAX queries.
  • 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, etc. with the intent to automate manual tasks (monitoring, deployments, testing, etc.)
  • Knowledge of SQL Server 2012-2017 including all latest features introduced in SQL Server 2012, 2014, 2016, & 2017
  • Strong technical and communication skills.
  • Ability to think analytically, plan for the 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.
  • 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 works, 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 the 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.

Virtuoso
  • 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