Lead Data Modeling Engineer

HOW YOU WILL MAKE AN IMPACT

Your role is important and below are some of the fundamental job duties that make your work unique.

What your day-to-day will be like:

• Collect requirements and modeling data (conceptual, logical, and physical) to support all data needs across multiple technologies within Hilton’s Enterprise Data Environment.
• Understand data relationships and design data models that reflect these relationships and facilitate loading and querying the data while ensuring optimum performance.
• Implement and ensure standards for data naming conventions to promote consistency and reuse of data models.
• Perform bottom-up modeling (through re-engineering) aligned to specific data sources and projects. 
• Perform top-down data modeling through conceptual and logical modeling of specific data domains needed by business, independent of technology.   

How you will collaborate with others:

• Work with Business Analysts, other Data Architects, Software Developers, and DBAs to achieve project objectives. Team meetings are schedule and lead by a demand manager.

What projects you will take ownership of: 

• Float across multiple projects supporting enterprise initiatives building data assets and data as a product.

WHY YOU'LL BE A GREAT FIT

You have these minimum qualifications:

• Five (5) years of professional work experience in Technology or related field
• Four (4) years of experience designing relational and dimensional data models in common toolsets such as Erwin, ER Studio, Oracle SQL Data Modeler, or PowerDesigner
• Four (4) years of experience in Data Warehouse or Transactional technology such as ETL tools, BI, and Analytic datasets
• Experience collecting requirements for data models for a large enterprise environment
• Experience with data organizational change procedures and deployment of database changes
• Travel up to 10%

It would be useful if you have:

WHAT IT IS LIKE WORKING FOR HILTON

Hilton, the #1 World's Best Workplace, is a leading global hospitality company with a diverse portfolio of world-class brands. Dedicated to filling the earth with the light and warmth of hospitality, we have welcomed more than 3 billion guests in our more-than 100-year history. Hilton is proud to have an award-winning workplace culture and we are consistently named among one of the World’s Best Workplaces. Check out the Hilton Careers blog and Instagram to learn more about what it’s like to be on Team Hilton!

It is the policy of Hilton to employ qualified persons without regard to color, race, creed, religion, national origin, ancestry, citizenship status, age, sex or gender (including pregnancy, childbirth and related medication conditions), gender identity or gender expression, sexual orientation, marital status, military service, status as a protected veteran, disability, protected medical condition as defined by applicable law, genetic information, or any other protected group status as defined by and subject to applicable federal, state and local laws. 

We provide reasonable accommodations to qualified persons with disabilities to perform the essential functions of the position and provide other benefits and privileges of employment in accordance with applicable law.  Please contact us if you require an accommodation during the application process.

Hilton offers its eligible team members a comprehensive benefits package including medical and prescription drug coverage, dental coverage, vision coverage, life insurance, short-and long-term disability insurance, access to our employee stock purchase plan (ESPP) where you can purchase Hilton shares at a 15 percent discount, a 401(k) savings plan, 20 days of paid time off accruing over your first year of employment and increasing up to 25 days after completing one year of full employment, up to 12 weeks of paid leave for birth parents and 4 weeks for non-birth parents, 10 paid holidays and 2 floating holidays throughout the year, up to 5 bereavement days, flexible spending accounts, a health savings account, an employee assistance program, access to a care coordination program (“Wellthy”),  a legal services program, an educational assistance program, adoption assistance, a backup childcare program, pre-tax commuter benefit and our travel discount. The annual salary range for this role is $110,000-$155,000 and is determined based on applicable and specialized experience and location. Subject to plan terms and conditions, you will be eligible to participate in the Hilton Annual Incentive (Bonus) Plan, consistent with other team members at the same level and/or position within the Company. #LI-REMOTE