Software Engineer II

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. TheSoftware Engineer IIactively contributes to Relational database and Azure Data pipeline & data platform development, design, architecture, review, enhancing & creating new features within Virtuoso’s marketing and reporting platform, and supporting critical production issues. Essential duties and responsibilities include the following.Other duties may be assigned. • Work effectively with team and product owners to define & clarify requirements, perform detailed analysis, and develop robust & maintainable solutions meeting business requirements. • Analyze, plan, develop, deploy, and manage a large scalable distributed data warehouse and database systems. • Create automation tests for unit, integration, regression, performance, and build verification • Understand and apply the advanced 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 product development. • Research and prototype new product & database features, design, and architecture ahead of mainstream development. • Proactively initiate & contribute to system improvements and innovations. • Provide support to troubleshoot and resolve technical & performance issues in a production environment. • Review designs, code, and test plans of other developers and provide recommendations for improvement or optimizations. • Build and support Microservice and Stateless architecture. • Follow defined software development lifecycle best practices. • Work effectively with management and members to clarify needs and priorities. Educational and Skills Requirements: • Bachelor’s degree in Computer Science, Engineering, or equivalent work experience • 7+ years' related experience • Understanding of complete data analytics stack and workflow, from ETL to data platform design to BI and analytics tools • Strong skills in databases and data processing • Extensive hands-on expertise with SQL and SQL analytics • Extensive experience in developing solutions with Snowflake cloud data warehouses • Intermediate-level knowledge of developing solutions using C#/Python, and REST API • Experience in developing a relational & non-relational data platform/data pipeline using Azure cloud solutions • Demonstrated experience in 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.) • Strong technical and communication skills • Desire and ability to work as part of a team with minimal supervision in a results-oriented, fast-paced, dynamic environment • Experience in managing and developing SQL Server, BI Suite, database custom tools using SQL Server Data Tools • Advance-level experience in GIT repository • Preferred: • Database architecture and designing experience. • Travel industry experience; or Ecommerce experience with CRM or online sales. • Advanced Snowflake experience • Advance level knowledge in automation test creation • Experience delivering data migration projects Travel Requirements: • Travel is rarely required for this position (0-1 trips per year). • Any travel will be entirely domestic. Type/Nature of Contacts: • Internal: Key job contacts are primarily with clerical and technical personnel outside of the job’s immediate work unit/department. • External: There is almost no contact outside of Virtuoso staff. Position is primarily internal facing. 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.