Reporting and Data Specialist

Company: Scenthound Franchising
Location: Jupiter
Posted on: March 19, 2023

Job Description:

Scenthound is the first membership-based franchise providing affordable and accessible wellness-focused dog care. Dogs need consistent care to keep all their parts healthy, from their Skin and Coat to their Ears, Nails, and Teeth (S.C.E.N.T.). At Scenthound we're committed to providing every dog with the care necessary to help maintain their health and keep them clean and happy. Founded in 2015 and Franchising since 2019, our revolutionary concept, technology-driven strategy, and proven model are fueling rapid nationwide growth. With 40 locations through the end of 2022 and on pace for 100 stores by the end of 2023, Scenthound is establishing itself as the preeminent solution for routine and preventive dog care.
JOB SUMMARY Reporting to the Chief Technology Officer, the Reporting & Data Specialist is responsible for building and maintaining Scenthound's corporate, as well as franchisee, facing dashboards and reports. The Scenthound team requires high-quality data, reports, and business intelligence to facilitate successful operations.
DUTIES & RESPONSIBILITIES
Update and maintain data lakes and data warehouse
Support data load and transformations across read replicas, RDS, Dynamo, unstructured data sources
Utilize relational databases, data warehouses, and other information resources to provide information and knowledge to key stakeholders
Track, process, and deliver requests for reports and queries in a timely manner
Clearly define outcomes through collaboration with requestors and key business stakeholders. Ensure that all parties agree with the business needs, information requirements, and key data elements that will be utilized.
Create reports and dashboards in Zoho Analytics, with data sourced from Snowflake data warehouse
Query and view design in Snowflake and Zoho Analytics using SQL
Design, build, test and distribute customized and ad hoc reports in alignment with authorized data definitions
Maintain reports in response to individual and business unit requests
Monitor daily automated tasks to ensure proper functioning
Use relevant tools to develop the right solution to meet customer data needs

EDUCATION & EXPERIENCE
BA/BS degree; or equivalent related work experience
4+ years of demonstrated experience with relational databases (MySQL, Aurora), queries, and data transformations
Experience with ELT tools, including Stitch and Skyvia
In-depth understanding of underlying data, data structures and general knowledge of business uses for data
Passion for and experience in designing data visualizations that communicate information though simplicity

SKILLS & ABILITIES
Strong SQL skills
Star-schema data warehouse setup and maintenance (Snowflake, Redshift)
Querying unstructured data (JSONs in S3) using Glue and Athena
Strong data modeling skills
Critical thinking, problem solving skills
Ability to define data relationships and author Entity Relationship Diagrams (ERDs)
Ability to work independently and exercise sound decision-making skills
Ability to meet deadlines through effective time management and a results-oriented mindset
Ability to translate user requirements into functional & design specifications
Vision for data relationships and resilient data structures
Commitment to accuracy, testing, and quality
COMPENSATION & BENEFITS
Competitive salary commensurate with experience
Health Insurance (Dental, Vision and Medical)
401(k)
Paid time off
Energetic, fun, loving work environment
Unlimited growth potential with an expanding business
Working at a company that is making the difference in the lives of dogs and dog parents!
LOCATION & TRAVEL REQUIREMENTS
Onsite if local to Jupiter, Florida (Scenthound HQ) or Remote
30% Travel


Flexible work from home options available.

Keywords: Scenthound Franchising, Jupiter , Reporting and Data Specialist, Advertising , Jupiter, Florida