Sr. Data Engineer

About Us: Founded in 1992 in Dover, NH, Planet Fitness is one of the largest and fastest-growing franchisors and operators of fitness centers in the United States by number of members and locations. We have over 2,500+ stores in 50 states, the District of Columbia, Puerto Rico, Canada, Panama, Mexico, and Australia. 90% of Planet Fitness stores are owned and operated by independent franchisees.

At Planet Fitness, our unique mission has always been to enhance people’s lives by providing a high-quality fitness experience in a welcoming, non-intimidating environment. And we’re proud of the amazing Planet Fitness team that supports our clubs and team members. They are comprised of dynamic, dedicated, and talented individuals who represent our values of integrity, transparency, passion, respect, and excellence (while having fun!) in everything they do.

Joining the PF family means being part of a company that cares about bettering the health and wellbeing of our communities. It means being a part of a supportive, engaging workforce with an inclusive culture that values diversity and creates an environment where everyone can feel they belong. It means encouraging professional growth and development. It means making true, lasting connections with your co-workers with celebrations, team building activities and engaging corporate events! It means creating a positive impact in our local communities through our Judgement Free Generation® philanthropic initiative. It means being part of a brand that you can be proud of!

For the past 30 years, we’ve helped millions of people in their fitness journey and revolutionized the industry along the way. And we’re just getting started!

Overview:

We are looking for a Sr. Data Engineer to join our growing team of data and analytics experts. In this role, you will be responsible for expanding and optimizing our data products and services, including data modeling, data quality automation and alerting, data pipeline architecture and development, and automated data integration.

The ideal candidate is an experienced data pipeline builder and data wrangler who enjoys optimizing data systems and building them from the ground up. The Sr. Data Engineer will support our database architects, data analysts and BI engineers on data initiatives and will ensure optimal data delivery architecture is consistent throughout ongoing projects. They must be self-directed and comfortable supporting the data needs of multiple teams, systems, and products. The right candidate will be excited by the prospect of optimizing or even re-designing our company’s data architecture to support our next generation of products and data initiatives.

For team collaboration purposes, candidates that currently reside in the Central or Eastern US time zones will be considered.

Responsibilities:

• Build out and deploy extract, transform, and load ETL pipelines and data access services on a big data cloud platform.
• Support designing, building and maintaining scalable data platforms that use emerging big data technologies.
• Perform analytical exploration and examination of data from multiple data sources.
• Participate in enforcing data quality and governance best practices in the data platform.
• Work with a multi-disciplinary team consisting of data analysts, data engineers, developers and data consumers in an agile, fast-paced environment.
• Work with and support a team that is globally located.
• Make technical design and coding decisions under advisement of system architects and management.
• Work with a cross section of business stakeholders, data analysts and management to understand and document business requirements.
• Work with project managers and data architects to create and document technical project proposals that include estimates, planning and schedules.
• Participate in review processes that involve architecture, design and quality assurance to preemptively identify conflicts and ensure consistency of implementation.
• Participate in identifying, resolving and monitoring production support items as assigned.
• Perform functional and integration tests, develop testing scripts and guide others in testing of data solutions.
• Ensure strict adherence to documentation best practices and change control processes.
• Provide guidance and support to colleagues, serving as a mentor in areas of expertise performing quality and performance checks.
• Performs other duties as assigned.
• Provide on-call support as needed.

Qualifications:

• Bachelor’s degree in Engineering, Information/Computer Sciences, or a related field, required
• 5+ years of direct experience in cloud data solution architectures, design and development including ETL, data warehousing, data lakes, and big data
• 5+ years of experience creating, executing, and documenting unit test plans for ETL and data integration processes and programs
• 5+ years of experience using SQL including development of stored procedures, functions, triggers and views
• 5+ years of direct experience using Snowflake and Snowflake utilities such as SnowSQL and SnowPipe
• 5+ years of direct experience using one or more of the following: Java, Scala or Python
• 5+ years of direct experience working in a cloud environment such as AWS, Azure or GCP
• 3+ years of direct experience with AWS EMR, Glue, Athena, AWS entity resolution and S3
• 3+ years of direct experience with NoSQL databases
• 3+ years of direct experience with streaming data architectures and technologies for real-time and low-latency data processing
• Experience with code management tools such as Github
• Experience with CI/CD pipeline management tools such as Circle CI
• Experience with scheduling tools such as Airflow
• 3+ years of direct experience of working in a Linux or Unix environment
• Experience and familiarly with data virtualization tools and platforms
• Excellent critical thinking, problem solving, organizational, interpersonal, and oral/written communication skills
• Must be self-sufficient and proactive
• Strong ability to balance multiple priorities in a dynamic, fast-paced environment
• Strong attention to detail
• Deep understanding of agile development methods including core values, guiding principles, and key agile practices
• An understanding of data mining, predictive modeling, and statistical analysis
• Experience working in retail business (preferred)
• Experience working in a franchised business (preferred)
• Experience working with ETL tools like DBT (preferred)
• Experience with data modelling (preferred)
• Excellent attention to detail, efficient, and organized with an ability to establish priorities and objectives
• Excellent presentation and communication skills along with the ability to communicate effectively across all levels of the organization
• Able to establish and maintain effective, collaborative work relationships with diverse individuals, internally and externally
• Dedicated learner with a natural curiosity for consistent growth
• Exhibits comfort, ease, and flexibility working in an extremely fast-paced ever-changing, deadline-driven environment
• Cooperative team player with an upbeat, positive, “can-do” attitude!
• Must be available to work off-hours and provide on-call support as needed

Perks:

• Remote work allowed for the right candidate
• Competitive salaries and comprehensive benefits package, including medical, pharmacy, dental and vision benefits
• Generous vacation/holiday pay
• Volunteer days off
• 401(k) Retirement
• Employee Stock Purchase Program
• Childcare reimbursement
• Pet care reimbursement
• Learning and development programs
• Discount programs, including vacations, theme parks, shopping, meal delivery services & much more
• Free Black Card membership and fun exercise incentives
• Company-sponsored social events
• Access to our private gym at headquarters, complete with locker rooms and Black Card area
• Delicious, healthy breakfast and lunch options served at our headquarters café

Note to Applicants: We have been made aware of an increasing number of hiring fraud schemes across numerous platforms. Planet Fitness never requires advance payments of any kind for computer equipment or any other purpose at the start of employment. Any request for you to provide payment information during the application process is part of a fraud scheme. Further, we recommend that you do not provide sensitive personal information (SSN, DOB, driver’s license number) as part of the initial application process.