Own architecting, optimizing, and transforming finance and product centric data models in DBT for flexible analysis by Data Analysts / Scientists and self-service by business stakeholders.
Design data validations to ensure data integrity throughout our pipelines, and assure the accuracy of our reporting.
Create transparency throughout the full data pipeline by establishing foundational processes with upstream data producers and downstream data consuming tools (BI, Reverse ETL, experimentation).
Advance agentic tooling and other automation efforts that help the team spend less time investigating data issues, and more time doing analyses.
Apply software engineering best practices like version control and continuous integration to the analytics code base.
Work closely with our Data Engineers, Analysts, Data Scientists, Diamond (Baseball/Softball) Sports, and Finance teams to build foundational models around new sport specific features, monthly recurring revenue, and subscription forecasting.
Support cross functional core metrics and data dependencies with leadership visibility.

Requirements

4+ years of experience in the Product, Finance, or Operations space as an analytics engineer, data analyst, data engineer, or equivalent.
Ability to write complex SQL, ad-hoc data pipelines, and experience in using Python for data analysis.
Hands-on experience implementing modern data modeling strategies with DBT, including validating data, building macros, and selecting optimal materialization.
Proven record of proactively driving improvements to data warehouse architecture.
Comfort with event tracking data and product analytics tools, including familiarity with common event data analyses like funnels and user paths.
Experience scaling a data platform’s capabilities while balancing warehouse costs.
Deep understanding of dimensional modeling techniques and building data for scale.
Comfort working in an agile, iterative environment and ability to thrive in a remote first organization.
Experience building and maintaining semantic layers and self-service technologies (e.g. dbt semantic views and LookML) for non-technical end-users.
Demonstrated capacity to clearly and concisely communicate complex business activities, technical requirements, and recommendations amongst cross-functional stakeholders.
Fluent in version control using git.

Benefits

Unlimited vacation policy.
Paid volunteer opportunities.
Technology stipend - $4,000 every 2 years after your start to make sure you have the latest and greatest technology.
WFH stipend - $500 annually to make your WFH situation comfortable.
Monthly physical, mental, wellness & learning stipend offered through Holisticly.
Monthly lifestyle stipend offered through Fringe.
Full health benefits - medical, dental, vision, prescription, FSA, HRA, HSA, and coverage for family/dependents.
Retirement savings - Traditional and Roth 401K plans are offered through Vanguard, with an immediate company match.
Life insurance - basic life, supplemental life, and dependent life.
Disability leave - short-term disability and long-term disability.
Company paid parental leave - up to 20 weeks for birthing parents and up to 12 weeks for non-birthing parents.
Family building benefits offered through Progyny.
DICK'S Sporting Goods and their family of brands teammate discount.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLPythonDBTdata modelingdata validationdata pipelinedimensional modelingevent trackingdata warehouse architecturesemantic layers

Soft Skills

communicationcollaborationproblem-solvingagilityproactivitytransparencyanalytical thinkingadaptabilityleadershipcross-functional teamwork