Hershey Entertainment & Resorts Company (HE&R) is an award-winning entertainment & hospitality organization with properties including: Hersheypark, The Hotel Hershey, Hershey Lodge, Giant Center, Restaurants, and more. Our team members share a common goal of upholding the legacy of our founder, Milton S. Hershey, while striving to live by our company's Core Values: Devoted to the Legacy, Selfless Spirit of Service, Team Focused, and Respectful of Others. Hershey Entertainment & Resorts is committed to cultivating diversity, equity, and inclusion in our workforce, marketplace, and community, and is proud to help fulfill the dream of our founder by providing value to Milton Hershey School.

This role is critical for leveraging the power of Google Looker to provide valuable data insights and drive data-informed decision-making within the organization. This role will be crucial in building and maintaining data models in Looker, developing insightful reports and dashboards in Looker Studio, and ensuring the security and governance of data assets.

As a Full-Time Team Member, you will enjoy sweet perks like FREE admission to Hersheypark, discounts, and more as soon as you receive your Employee ID! Your total compensation consists not only of the wage that you are paid, but also includes Medical, Dental, and Vision coverage beginning the first day of the next month after you begin working, 401K Contribution, paid time off, and so much more!

Job Duties (Duties marked with an asterisk are essential functions of this job):

• Design, develop, and maintain robust and scalable data models using LookML. Define dimensions, measures, calculated fields, and aggregates to support business requirements.

• Establish relationships between different data sources and ensure data integrity within the Looker model.

• Utilize Looker's semantic layer to create a single source of truth for data analysis.

•  Design and develop interactive and user-friendly reports and dashboards in Looker Studio.  Ensure reports and dashboards adhere to data governance and security policies.

•  Create compelling visualizations to effectively communicate data insights. Implement filtering, parameters, and drill-down capabilities to enhance user interaction. 

•  Collaborate with stakeholders to understand reporting requirements and translate them into effective Looker Studio solutions 

•  Administer the Looker application, including user management, roles, and permissions by managing data access and sharing within the Looker environment. Implement and maintain security protocols to ensure data confidentiality and integrity.  

•  Work closely with data analysts and business stakeholders to understand their data needs and translate them into technical solutions. 

•  Provide guidance and support to end-users on how to effectively use Looker and Looker Studio. 

•  Contribute to the development of data-driven insights and recommendations. Participate in data governance initiatives to ensure data quality and consistency. 

•  Perform other duties as assigned.

Qualifications:

• Bachelor’s degree in computer science, Data Science, Business Analytics, or a related field.

• Minimum of 5 years of experience in data analytics.

• Minimum of 2-3 years of hands-on experience with Google Looker, including LookML. development and Looker Studio report and dashboard creation.

• This position does not offer visa sponsorship.

Knowledge, Skills, and Abilities:

• Experience with data security and access control implementation.

• Excellent analytical and problem-solving skills.

• Familiarity with ETL processes and tools.

• Experience with other BI and data visualization tools.

• Experience with data governance principles and practices.

Job Demands:

While performing the duties of this job, the employee is required to:

• Sitting Constant ( >67%)

• Finger Dexterity Frequent (34-66%)

• This job requires the visual ability to perform detailed work at close distances (computer screens, accounting ledgers, using measurement devices).

• Substantial movements of the wrists, hands, and/or fingers (Repetitive motion).

• This job regularly requires verbal communication of detailed information to others either by phone or in person.

Nothing in this job description restricts management’s right to assign or reassign duties and responsibilities to this job at any time.

Hershey Entertainment and Resorts is an Equal Opportunity Employer

Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.