Data Engineer

COMPANY OVERVIEW GoFan is the leading digital ticketing solution for high school events. Led by innovative technology and unmatched support, GoFan provides schools a turnkey platform to manage season, online and at-event ticket sales. Serving thousands of schools and 37 state associations, GoFan provides fans frictionless access to high school events across the country. For the 2020-2021 school year, more than 15 million tickets were sold on the GoFan platform!   GoFan is a product of Huddle Tickets, who has provided over 2 billion complimentary event tickets to 10,000 school since 2001. THE ROLE GoFan is looking for a Data Engineer to support the organization’s data and BI function as a member of the Product and Engineering organization. This role will support our lead data architect on projects that comprise the company’s foundational systems for handling both business (B2B) and consumer (B2C) data. This includes relational databases, data warehouses and transactional data systems. In this position, you will cover a wide range of responsibilities including managing existing transactional and reporting infrastructure, optimizing SQL queries and logic, overseeing BI tools and infrastructure, as well as assisting with end user data needs. Additional responsibilities and accountabilities for this role include: • Support data architecture roadmap by managing data models, data store/warehouse, information management, and advanced data analytics. • Utilize tools and techniques for data management and data quality. • Support DataOps deployments, configurations, and complex data architectures, ensuring documentation meets current and forecasted needs. • Collaborate and work with data stakeholders to ensure that data and reports meet their business needs. • Develop logical and physical data models for complex projects using both relational and other modeling techniques and approaches. • Developing ETL specifications and mappings to support data conversion and integration from a wide variety of source systems. • Stay up to date with emerging data technologies and provide an understanding of how to adopt and apply new patterns. • Lead and provide technical guidance for design and implementation of data storage and governance systems. • Engage in technical evaluations of solution and design approaches. THE PERSON • 3 years as a Data Engineer or BI Engineer within a technology-driven organization • 2 years of data & analytics development or comparable experience • 2 years working with PostgreSQL, MySQL, or SQL Server Databases • 2 years hands-on experience with Python and cloud environments, preferably AWS • 2 experience with BI tools such as Tableau, Looker, Power BI or other • Bachelor’s degree in Computer Science, Information Technology, Business or related field • Advanced knowledge of SQL • Strong experience with data warehousing, database design principles, and data administration standards WHY YOU’LL LOVE WORKING AT GOFAN We are one GoFam. We believe that the time and effort we put in to serving our schools and fans can only be done by working hard together. But we also believe that a work/life balance is equally crucial. Seriously. Our team members well-being is just as important to us as their work. We are humans first, employees second.  Some benefits we office include: • Competitive salary  • Multiple Medical options to choose from • Dental, Vision, Life and Disability Insurance • Generous PTO  • 401K plan with company match  • Fun, flexible, and collaborative work environment