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
Click
here to apply!
|