Lead Data Engineer

Job Summary: Great Wolf Lodge is seeking a talented and experienced Lead Data Engineer to join our Analytics team. As a Lead Data Engineer, you will play a pivotal role in shaping our data infrastructure and analytics capabilities, enabling data-driven decision-making across the organization. You will lead a team of data engineers and work closely with data scientists, analysts, and other stakeholders to design, build, and maintain data pipelines, databases, and data models to support analytics and reporting solutions, including performance management, data science, and personalization.

The Lead Data Engineer will collaborate closely with Technology, Finance, and Commercial Analytics to drive value through best-in-class data architecture and data model design.

Responsibilities:

• Lead a team of data engineers in designing, developing, and maintaining data pipelines and ELT/ETL processes using Matillion and dbt.
• Partner with both internal stakeholders and external vendors involved in project definition, design, and planning, and map the data journey from source through consumers (data visualization, applications, or predictive models).
• Architect, implement, and maintain data warehouse and database systems for efficient data storage, retrieval, and analysis using Snowflake.
• Design, develop, test, and deploy data models, data collection, and transformation components. Determine the best point for transformations, calculations, and joins (e.g., data lake, data warehouse, or Tableau data source).
• Ensure data quality, consistency, and integrity by establishing data governance best practices and ensuring scalability and sustainability of business intelligence data architecture.
• Stay current with industry trends and emerging technologies to drive innovation within the data engineering domain.
• Oversee and conduct troubleshooting, performance tuning, optimization, and scalability of data infrastructure.
• Mentor and coach team members to improve their technical skills and foster collaboration.
• Act as a subject matter expert on data-related projects and communicate effectively with non-technical stakeholders.

 Qualifications:

• Bachelor's or Master’s Degree in Technology, Computer Science, or similar technical field.
• 5+ years experience with data engineering technologies such as SQL, ETL tools (Matillion and dbt), and Snowflake data warehousing
• Experience designing and implementing conceptual, logical, and physical data models
• Strong programming skills in languages like Python and/or R.
• Experience with cloud platforms (AWS and Azure) and knowledge of cloud-based data services.
• Excellent problem-solving skills, with a focus on data architecture and system design.
• Strong communication and leadership skills, with the ability to work collaboratively in a team environment.
• Ability to work from Great Wolf's Corporate Headquarters, currently operating on a hybrid-remote schedule: Mondays and Fridays optional work from home, Tuesdays, Wednesdays and Thursdays in-office.
• 
  

Preferred Experience:

• Familiarity with data visualization tools (e.g. Tableau) and analytics platforms.
• 2+ years in a leadership or senior role strongly preferred.