Data Warehouse Developer (contract)

Hilton Inc.
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 156K

Job location

Remote

Tech stack

Agile Methodologies
Amazon Web Services (AWS)
Business Intelligence
Big Data
Information Systems
Data Governance
Data Infrastructure
Data Integrity
ETL
Data Mart
Data Security
Data Systems
Data Warehousing
Relational Databases
Database Queries
Dimensional Modeling
Document-Oriented Databases
Machine Learning
Meta-Data Management
Performance Tuning
Scrum
Cloud Services
SQL Stored Procedures
SQL Databases
Systems Architecture
Freeform SQL
Sql Optimization
Indexer
Information Technology
Data Lineage
Data Management
Data Pipelines

Job description

We are seeking a skilled and experienced professional to design, develop, and maintain scalable data warehouse solutions that power business analytics, reporting, and data-driven decision-making across the organization. The ideal candidate brings deep expertise in ETL/ELT processes, dimensional data modeling, SQL optimization, and modern cloud-based data platforms, and thrives in a collaborative, fast-paced environment where data integrity and performance are top priorities. This role offers the opportunity to work closely with cross-functional teams including data engineers, analysts, BI developers, and business stakeholders to deliver impactful, enterprise-grade data solutions., * Design, build, and maintain enterprise data warehouse architectures and data marts

  • Develop and optimize ETL/ELT pipelines to integrate data from multiple source systems
  • Create and maintain dimensional and relational data models, including star and snowflake schemas
  • Write, tune, and optimize complex SQL queries, stored procedures, and views
  • Ensure data quality, accuracy, and consistency through validation and monitoring processes
  • Collaborate with data engineers, analysts, BI developers, and business stakeholders to gather and translate requirements
  • Support reporting, dashboarding, and analytics needs across the organization
  • Implement performance tuning, indexing, and partitioning strategies
  • Manage data security, access controls, and compliance requirements
  • Document data models, pipelines, and warehouse architecture thoroughly
  • Participate in Agile ceremonies including sprint planning, standups, and retrospectives, This is a compelling opportunity to make a meaningful impact within a globally recognized organization by building and shaping the data infrastructure that drives strategic business decisions. You will work alongside talented professionals on challenging, high-visibility projects that leverage cutting-edge technologies and modern data practices, making this an ideal role for a motivated data professional looking to grow their career and leave a lasting mark on enterprise-scale data solutions.

Requirements

Do you have experience in System architecture design?, Do you have a Bachelor's degree?, * Advanced proficiency in SQL, including complex query writing and optimization

  • Strong development experience with Informatica IDMC CDI and CAI
  • Strong understanding of data warehousing concepts, including dimensional modeling
  • Experience working with large-scale datasets and performance optimization techniques
  • Familiarity with Agile and Scrum development methodologies
  • Experience with cloud data platforms, including AWS
  • Experience supporting machine learning or advanced analytics workloads is a plus
  • Understanding of data governance, metadata management, and data lineage is a plus

Experience:

  • 5 or more years of experience as a Data Warehouse Developer or in a similar data-focused role, * Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent practical experience

Benefits & conditions

4.04.0 out of 5 stars Remote $65 - $75 an hour - Contract

Apply for this position