We are seeking a Data Warehouse Architect to lead the evolution, tuning and refinement of our Data Warehouse and Analytics infrastructure. This role will work closely with the Data Team to include Data architecture and ETL to enhance the aggregated data used across the product suite.

This role will work cross functionally across the Data organization to streamline the data processing quality and efficiency to ensure the processed data is available in a timely manner, can scale according and grow as the organization scales.

Roles and Responsibilities

  • Identify and implement improvements to the data warehouse/Redshift environment to include performance tuning, system availability, and redundancy
  • Develop, analyze and refine the capacity planning roadmap and scalability of the core systems
  • Maintain and continually incorporate best practices in system deployments
  • Update and maintain production environment with latest upgrades and security patches
  • Review, design and implement data model enhancements to support new/3rd party data sources
  • Research, identify and resolve problems across the data processing spectrum
  • Serve as a data steward across all systems developing and maintaining the “source of truth” of the data
  • Ensure proper alarming, monitoring, logging and alerting of core systems

Desired experience and skills

  • Bachelor’s Degree in Computer Science, Information Systems or related field
  • 10+ years’ experience with data warehouse(s), AWS, ETL, data processing, database programming and troubleshooting
  • Extensive experience with automated software deployments, Ansible, Jenkins, Nexus, git, and build systems
  • Extensive experience configuring application servers, (such as Tomcat), connection pooling, environment management, and load balancing
  • Experience with configuring and maintaining containerized deployments
  • Extensive background in the support and scaling of large scale DW environments
  • Extensive background in operating and maintaining systems in production
  • Extensive background updating and upgrading operating system and application server versions
  • Ability to analyze existing data model and develop short and long term roadmap for enhancements
  • Experience with AWS EC2, S3, Redshift, Route53, EFS, IAM, Terraform, SQL and Pentaho required
  • Knowledge of hotel industry preferred but not required

Kalibri Labs, LLC is an Equal Opportunity Employer.