Data Engineering & Analytics Contractor

Who We Are

Teton Ridge is a visionary force in Western sports, entertainment, media, lifestyle, and equine culture, dedicated to growing the world of the American West to new fans. Our content and events engage a broad community of fans while preserving the traditions and legacy of the American West.

From large-scale events like The American Rodeo to The Cowboy Channel, short films, digital and print media, and social-first content, Teton Ridge tells the stories of the rich culture of the American West. Join us in shaping the future of Western sports and entertainment!

This contractor will serve as the primary data analytics and engineering resource for Teton Ridge during a planned maternity leave. The role covers day-to-day data pipeline maintenance, executive reporting, and ongoing infrastructure projects across the company.

Executive Reporting

• Maintain and distribute weekly/monthly streaming performance dashboards (DAU, MAU, stickiness, logged-in rate, avg. session time) for biweekly stakeholder meetings
• Meet with key stakeholders to define target metrics for their teams and reverse-engineer solutions using available pipeline data
• Support ad-hoc data requests from leadership as they arise

Data Pipeline Maintenance

• Monitor and maintain ETL connectors across marketing and social platforms (Facebook Pages, Instagram Business, You Tube Analytics, Google Ads, Tiktok, and more)
• Administer automated data transfer jobs in Big Query, including scheduling management and backfill resolution and maintenance for if/when they break
• Serve as subject-matter-expert on data pipeline architecture across cloud data platforms, including data lineage, source systems, and reporting caveats
• Partner with revenue operations, social, and marketing teams on performance data audits and dashboard maintenance
• Own subscription reporting structures, auditing existing pipelines and developing new ones to support streaming platform analytics
• Maintain and enhance custom scripts and queries as business needs evolve (scheduled in GBQ)
• Provide cross-functional project management for technical and data initiatives across teams

Audience & Engagement Reporting

• Pull and reconcile web/app analytics data (GA4) with video platform metrics (JW Player) for subscriber and audience analysis
• Develop and maintain DAU/MAU reporting methodology, including documenting data limitations and ensuring appropriate caveats in all stakeholder reporting
• Field stakeholder questions on viewing patterns across devices and platforms (Roku, CTV, mobile, web) using combined analytics sources

Data Platform Integrations

• Coordinate with engineering partners on data sync issues between cloud platforms
• Push updated pipeline outputs from Big Query into downstream data platforms as needed
• Troubleshoot and resolve cross-cloud data transfer issues, ensuring outputs are configured correctly to maintain pipeline reliability

• 5 years of experience in data analytics, business intelligence, data engineering, or a related field
• Strong proficiency in SQL, including experience writing and optimizing complex queries in large-scale data environments
• Hands-on experience with cloud-based data warehouses, preferably Google Big Query
• Experience maintaining and troubleshooting ETL/ELT pipelines and automated data workflows
• Working knowledge of digital analytics platforms, including Google Analytics 4 (GA4)
• Experience integrating and analyzing data from multiple sources, including advertising, social media, subscription, and web analytics platforms
• Proven ability to develop executive-level dashboards, reports, and performance metrics
• Experience documenting data definitions, methodologies, and reporting caveats for business stakeholders
• Strong project management and organizational skills, with the ability to manage multiple priorities simultaneously
• Excellent communication skills and ability to translate technical concepts into actionable business insights
• Ability to work independently with minimal supervision and quickly learn new systems and business processes

• Experience with Palantir Foundry, Looker Studio, or similar business…