Great Wolf Lodge
Data Engineer
Great Wolf Lodge, Chicago, Illinois, United States, 60290
Job Description
Job SummaryGreat Wolf Lodge is seeking a talented and motivated Data Engineer to join our Analytics team. As a Data Engineer, you will play a crucial role in shaping our data infrastructure and analytics capabilities, enabling data-driven decision-making across the organization. You will 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 Data Engineer will report to the Director of Analytics and Data Science, and will collaborate with Technology, Finance, and Commercial Analytics to drive value through best-in-class data architecture and data model design.Job Duties:Design, develop, and maintain data pipelines and ELT/ETL processes using Matillion and dbt.Implement and maintain data warehouse and database systems for efficient data storage, retrieval, and analysis using Snowflake.Partner with internal stakeholders and external vendors involved in project definition, design, and planning, mapping the data journey from source through consumers (data visualization, applications, or predictive models).Gather, document, and analyze business requirements to deliver data products that support business needsDesign, develop, test and deploy data models, data collection, and transformation components. Determine best point for transformations, calculations, and joins (e.g. data lake, data warehouse, or Tableau data source)Ensure data quality, consistency, and integrity by following data governance best practices and ensuring scalability and sustainability of business intelligence data architecture.Troubleshoot and support existing data workflow processes; deliver fixes and optimizations where appropriateCollaborate with team members to improve technical skills and foster a cooperative working environment.Stay abreast of new data management methods and technologies and support development of these new capabilities internally.Qualifications:2+ years' experience building ETL/ELT pipelines and data warehousesExperience designing and implementing conceptual, logical, and physical data modelsExperience with common data infrastructure tools and services, including AWS S3, Snowflake, Snowpipe, and Tableau Server.Expert SQL scripting skills and advanced familiarity with a variety of databases, including both structured (SQL) and unstructured (NoSQL) environments.Experience with Matillion, dbt, Informatica, Talend, or other data transformation tool required.Advanced experience with one or more programming/scripting languages, including but not limited to Python and/or R.Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.Ability to effectively build relationships across the business at all levelsSelf-starter, entrepreneurial, high-energy who can take initiative in a fast-moving environmentStrong technical understanding of current and emerging business intelligence and analytics technologiesEducation:Bachelor's Degree in Technology, Computer Science, or similar technical field
#J-18808-Ljbffr
Job SummaryGreat Wolf Lodge is seeking a talented and motivated Data Engineer to join our Analytics team. As a Data Engineer, you will play a crucial role in shaping our data infrastructure and analytics capabilities, enabling data-driven decision-making across the organization. You will 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 Data Engineer will report to the Director of Analytics and Data Science, and will collaborate with Technology, Finance, and Commercial Analytics to drive value through best-in-class data architecture and data model design.Job Duties:Design, develop, and maintain data pipelines and ELT/ETL processes using Matillion and dbt.Implement and maintain data warehouse and database systems for efficient data storage, retrieval, and analysis using Snowflake.Partner with internal stakeholders and external vendors involved in project definition, design, and planning, mapping the data journey from source through consumers (data visualization, applications, or predictive models).Gather, document, and analyze business requirements to deliver data products that support business needsDesign, develop, test and deploy data models, data collection, and transformation components. Determine best point for transformations, calculations, and joins (e.g. data lake, data warehouse, or Tableau data source)Ensure data quality, consistency, and integrity by following data governance best practices and ensuring scalability and sustainability of business intelligence data architecture.Troubleshoot and support existing data workflow processes; deliver fixes and optimizations where appropriateCollaborate with team members to improve technical skills and foster a cooperative working environment.Stay abreast of new data management methods and technologies and support development of these new capabilities internally.Qualifications:2+ years' experience building ETL/ELT pipelines and data warehousesExperience designing and implementing conceptual, logical, and physical data modelsExperience with common data infrastructure tools and services, including AWS S3, Snowflake, Snowpipe, and Tableau Server.Expert SQL scripting skills and advanced familiarity with a variety of databases, including both structured (SQL) and unstructured (NoSQL) environments.Experience with Matillion, dbt, Informatica, Talend, or other data transformation tool required.Advanced experience with one or more programming/scripting languages, including but not limited to Python and/or R.Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.Ability to effectively build relationships across the business at all levelsSelf-starter, entrepreneurial, high-energy who can take initiative in a fast-moving environmentStrong technical understanding of current and emerging business intelligence and analytics technologiesEducation:Bachelor's Degree in Technology, Computer Science, or similar technical field
#J-18808-Ljbffr