Lanyon is the leading provider of content and spend management solutions to the travel, transportation and hospitality industries. We serve over 725 corporate clients and over 340 hotel companies, representing over 425 hotel brands and 93,000 hotel properties. Lanyon’s customer base includes 70% of the Corporate Travel 100, 50% of the Global 500, and 70% of the world’s hotel brands.
The Data Warehouse Architect/ETL Developer is responsible for the design and management of the data warehouse and ETL processes that support the enterprise’s BI initiative. In the data warehouse architect role, this person will be expected to have a solid understanding of the company’s data model and the ability to design solutions and processes which combine disparate data into meaningful reporting and analysis that can be easily understood by customers and internal audiences. This person must have the ability to understand complex data relationships and business requirements and formulate efficient and reliable solutions to difficult problems. In the ETL developer role, this person will be responsible for the development and maintenance of several critical ETL processes that support the data warehouse and other aspects of the BI initiative. This person will report to the Senior Director of Data Services.
Perform data modeling based on Dimensional Fact Model (DFM) principles
Manage the ongoing design and maintenance of the company’s data warehouse and ETL processes to ensure that data is as consistent, clean and accurate as possible
Design of SSIS packages and other tools used to implement ETL processes between various data sources, including product databases, third-party applications and other data sources
Write and optimize packages, stored procedures, functions, views, etc. using T-SQL and PL/SQL
Act as a key liaison to the company’s BI product manager and developers, developing solutions to design problems, increasing efficiency and performance, and recommending best practices for data warehouse-driven reporting and analytics
Lead the technical aspects of customer requirements analysis, review technical specification for completeness and recommend appropriate business systems and IT infrastructure
Develop technical documentation, including requirements documents, process overviews, data models, data flow and network diagrams
Bachelor's degree in Computer Science or related field
7+ years of experience in database development, information systems design and analysis and IT/technical consulting
7+ years of experience with the implementation of enterprise-level data warehousing and supporting business intelligence initiatives
Broad expertise spanning various technologies, business process integration, enterprise data warehousing and advanced analytics
Prior experience implementing medium-to-large scale data warehousing initiatives
Prior experience with and deep understanding of complex performance management and data warehousing business processes
7+ years of experience with database programming and design, including mastery of complex report queries and SQL optimization
7+ years of experience with enterprise-class RDBMS, including Microsoft SQL Server and Oracle and associated tools, including Microsoft SSMS, BIDS, SSIS, etc.
Strong grasp of advanced SQL writing and query tuning/optimization
Strong written / oral communication and organizational skills
Ability to self-manage and multi-task on multiple projects
Familiarity with Agile development methodologies
Experience with general project management and project lifecycle techniques
Experience in the Travel and Hospitality industry
Experience with LogiAnalytics reporting and data visualization tools