Senior Data Engineer

Job Description

Company Overview Fanatics is building a leading global digital sports platform. The company ignites the passions of global sports fans and maximizes the presence and reach for hundreds of sports partners globally by offering innovative products and services across Fanatics Commerce, Fanatics Collectibles, and Fanatics Betting & Gaming, allowing sports fans to Buy, Collect and Bet. Through the Fanatics platform, sports fans can buy licensed fan gear, jerseys, lifestyle and streetwear products, headwear, and hardgoods; collect physical and digital trading cards, sports memorabilia, and other digital assets; and bet as the company builds its Sportsbook and iGaming platform. Fanatics has an established database of over 100 million global sports fans, a global partner network with over 900 sports properties, including major national and international professional sports leagues, teams, players associations, athletes, celebrities, colleges, and college conferences, and over 2,000 retail locations, including its Lids retail business stores. As a market leader with more than 18,000 employees, and hundreds of partners, suppliers, and vendors worldwide, we take responsibility for driving toward more ethical and sustainable practices. We are committed to building an inclusive Fanatics community, reflecting and representing society at every level of the business, including our employees, vendors, partners and fans. Fanatics is also dedicated to making a positive impact in the communities where we all live, work, and play through strategic philanthropic initiatives. COMPANY OVERVIEW We are PWCC. We're based in Tigard, Oregon and are the largest trading card marketplace in the world. PWCC is brokering nearly a half-billion in trading card sales annually (and you thought those baseball cards in your mom's basement were worthless!), with the goal of expanding and becoming the name for collectibles storage, research, and liquidity. We are growing rapidly and need the right person to expand our team and help us provide the care our client base needs. POSITION OVERVIEW We are seeking a highly skilled and motivated Senior Data Engineer with expertise in implementing cross functional solutions and building a world class data practice. As a Senior Data Engineer, you will play a foundational role in designing, implementing, and maintaining our data infrastructure to support efficient and scalable data processing. You will work closely with cross-functional teams including software engineers, other members of the data team and business stakeholders to ensure our data systems are driving the business forward, have high availability, and are end-user friendly. This role is critical to the establishment, socialization, and implementation of our data infrastructure and business processes that will drive organizational, institutional, and marketplace success. POSITION RESPONSIBILITIES: • Be a technical subject matter expert and provide technical leadership for data solutions across the enterprise. o Support current technologies in place (Snowflake, DBT, Airbyte, Rudderstack, Python, Tableau, GCS, AWS) and champion better or more appropriate technologies as the need arises. o Collaborate with the Head of Data and Analytics to set the roadmap for data infrastructure projects. o Collaborate with the Head of Data and Analytics to set the roadmap for analytics and product projects. • Design, own and develop highly scalable and available services for data ingestion, data processing and business intelligence. o Support and develop real time data pipelines to support operations and trust teams. o Maintain and tune currently nightly data processes. o Design and build machine learning pipelines and process that impact auction performance and increase customer loyalty. o Collaborate with data colleagues across Fanatics Collectables to ensure awareness and appropriate coordination to achieve enterprise goals. • Lead collaboration with executive and director level stakeholders to understand data requirements and design data models that answer key business questions. o Be a frequent data subject matter expert in business and analytics projects. o High level of execution required to drive significant growth in the business. Only barrier to growth is higher levels of insight and business intelligence. • Design and own data quality control and validation. o You should know before anyone else if there is a data quality or data processing issue. o You will be responsible to use existing tools or selecting new tools and building out the data quality control and validation system. o Escalate system issues as needed to impact/responsible business partners. • Analyze and improve existing data sources. • Continuously improve efficiency by tuning low performing data processes. Support the scalability of the data practice through automating and labeling workflows and maintaining up to date documentation of the data processes and models. • Additional duties as assigned. QUALIFICATIONS: • 5+ years of experience in data engineering, software engineering, or other related roles • B.S. or higher in Computer Science or equivalent training and experience • Experience in relational database concepts with a solid knowledge of SQL, SQL Tuning, Big Data technologies • Demonstrated success in generating and maintaining data pipelines from various data sources, in collaboration with diverse stakeholders • Demonstrable experience working with AWS, DMS, S3, DBT, Snowflake, other ETL Tools, Tableau etc. • Proven track record of experience with best practices for development including query optimization, version control, code reviews, and documentation • Demonstrated knowledge of data structures • Experience in designing foundations of operational excellence, particularly in a CoE environment • Curiosity and passion to learn with a strong bias to action • Highly effective problem-solving skills and the ability to analyze complex data-related issues. • Demonstrably effective interpersonal skills, both verbal and written BENEFITS We offer generous benefits including, but not limited to: 401(k), 401(k) matching, dental insurance, vision insurance, employee assistance program, flexible schedule, health insurance, life insurance, paid time off. Our clients come from all walks of life and so do we. We hire great people from a wide variety of backgrounds because it makes our company stronger. If you share our passion, please do not hesitate to apply. We are also happy to look into any ADA accommodation requests that may be needed. PWCC is an equal opportunity employer. Must be able to pass relevant criminal background check if offered the job, however, we believe in second chance employment and encourage everyone to apply. TEAM BIO We are responsible for conceiving, specifying, designing, programming, documenting, testing, & bug fixing involved in keeping the PWCC website and our auctions functioning and operational. $140,000 - $160,000 a year Ensure your Fanatics job offer is legitimate and don’t fall victim to fraud. Fanatics never seeks payment from job applicants. Feel free to ask your recruiter for a phone call or other type of communication for interview, and ensure your communication is coming from a Fanatics or Fanatics Brand email address. For added security, where possible, apply through our company website at www.fanaticsinc.com/careers Tryouts are open at Fanatics! Our team is passionate, talented, unified, and charged with creating the fan experience of tomorrow. The ball is in your court now. Fanatics is committed to responsible planning and purchasing (RPP) practices, working with its business partners across its global and multi-layered supply chain, to ensure that planning, sourcing, and purchasing decisions, along with other supporting processes, do not impede or conflict with the fulfillment of Fanatics’ fair labor practices. NOTICE TO CALIFORNIA RESIDENTS/APPLICANTS : In connection with your application, we collect information that identifies, reasonably relates to or describes you (“Personal Information”). The categories of Personal Information that we collect include your name, government issued identification number(s), email address, mailing address, other contact information, emergency contact information, employment history, educational history, criminal record, and demographic information. We collect and use those categories of Personal Information about you for human resources and other business management purposes, including identifying and evaluating you as a candidate for potential or future employment or other types of positions, recordkeeping in relation to recruiting and hiring, conducting criminal background checks as permitted by law, conducting analytics, and ensuring compliance with applicable legal requirements and Company policies. For additional information on how we collect and use personal information in connection with your job application, review our Candidate Privacy Policy-CA Apply for this job