Job Title

The Sr. Data Engineer 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 Sr. Data Engineer will support our database architects, data analysts and BI engineers on data initiatives and ensure optimal data delivery architecture is consistent throughout ongoing projects. The Sr. Data Engineer also supports the data needs of multiple teams, systems, and products and is 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.

This role is based out of our Hampton, NH office following our hybrid work schedule.

Responsibilities

Responsibilities include:

• 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 changes control processes.
• Provide guidance and support to colleagues, serving as a mentor in areas of expertise performing quality and performance checks.
• Perform other duties as assigned.
• Provide on-call support as needed.

Qualifications

Qualifications include:

• 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 familiarity 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
• 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

Perks include:

• Hybrid work schedule out of our Hampton, NH office
• 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 the Club Support Center, complete with locker rooms and Black Card Spa area
• Delicious, healthy breakfast and lunch options served at our Club Support Center 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.