Lead Data Modeling Engineer

This role is based at one of our corporate offices in McLean, VA, Dallas, TX, Memphis, TN, or RemoteThis is your chance to be a part of an in-house Technology team that’s creating consumer-facing, cutting-edge technologies revolutionizing the hospitality industry around the world! As a Lead Data Modeling Engineer, you will bring your technical skills to a hospitality company with an award-winning culture. On the Enterprise Modeling Team reporting to the Director Data Architect, you will support projects including Customer, Stay, Marketing, and Pricing.HOW WE WILL SUPPORT YOUHilton is proud to support the mental and physical wellbeing of all Team Members so they can Thrive personally and professionally in a diverse and inclusive environment, thanks to programs and benefits such as:

Go Hilton travel program: 100 nights of discounted travel with room rates as low as $40/night

Hilton Shares: Our employee stock purchase program (ESPP) - you can purchase Hilton shares at a 15 percent discount

Paid parental leave for eligible Team Members, including partners and adoptive parents

Mental health resources including free counseling through our Employee Assistance Program

Paid Time Off (PTO)

Learn more about the rest of our benefits (https://jobs.hilton.com/us/en/benefits)

At Hilton, we believe every Team Member is a leader. We are committed to offering leadership development opportunities and programs through every step of a Team Member’s career journey and at every level, both in our hotels and across corporate.Available benefits may vary depending upon terms and conditions of employment and are subject to the terms and conditions of the plans.HOW YOU WILL MAKE AN IMPACTYour 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 FITYou 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:

Bachelor’s Degree, or Associate’s Degree plus 6 years of Technology related experience, or High School Degree/GED plus 12 years of Technology related experience

Seven (7) years of professional work experience in Technology or related field

WHAT IT IS LIKE WORKING FOR HILTONHilton, the #1 World's Best Workplace, is a leading global hospitality company with a diverse portfolio of world-class brands (https://jobs.hilton.com/us/en/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 (https://jobs.hilton.com/us/en/blog) and Instagram (https://www.instagram.com/hiltoncareers/) 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 (https://cdn.phenompeople.com/CareerConnectResources/prod/HILTGLOBAL/documents/ApplicantAccommodationandAccessibilityAssistance-English-20230515-1684253430519.pdf) 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-REMOTEJob: Enterprise Architecture and DataTitle: Lead Data Modeling EngineerLocation: nullRequisition ID: COR014M7EOE/AA/Disabled/Veterans