Data Engineering & Analytics Contractor at Teton Ridge

Fort Worth, Texas, United States -

Full Time

Start Date

Immediate

Expiry Date

26 Sep, 26

Salary

0.0

Posted On

28 Jun, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, Google BigQuery, ETL/ELT Pipelines, Google Analytics 4, Data Engineering, Business Intelligence, Executive Reporting, Data Pipeline Maintenance, Project Management, Data Integration, Dashboard Development, Data Auditing, Python/Scripting, Cloud Data Warehousing, Stakeholder Management, Data Lineage

Industry

Entertainment

Description

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! POSITION OVERVIEW 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. WHAT YOU'LL DO 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, YouTube Analytics, Google Ads, Tiktok, and more) Administer automated data transfer jobs in BigQuery, 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 BigQuery into downstream data platforms as needed Troubleshoot and resolve cross-cloud data transfer issues, ensuring outputs are configured correctly to maintain pipeline reliability WHAT WE ARE LOOKING FOR 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 BigQuery. 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. PREFERRED QUALIFICATIONS Experience with Palantir Foundry, Looker Studio, or similar business intelligence and reporting tools. Experience with data integration platforms such as Fivetran. Familiarity with subscription-based businesses, streaming platforms, media, entertainment, or digital content organizations. Experience working with video analytics platforms such as JW Player. Familiarity with advertising and marketing platforms including Google Ads, Meta Ads, Google Ad Manager, and social media analytics tools. Experience working with CRM and revenue operations data, including systems such as Boostr CRM. Knowledge of REST APIs, data ingestion processes, and cross-platform data synchronization. Experience supporting executive stakeholders and responding to ad hoc analytical requests in a fast-paced environment. LOCATION Remote, Hybrid, or Ft. Worth HQ CONTRACT TERM Must be available for a contract assignment of approximately 3 months and capable of assuming ownership of existing data pipelines, reporting processes, and stakeholder relationships with minimal ramp-up time. EEO STATEMENT Teton Ridge is an equal opportunity employer. We are passionately committed to equitable hiring and boldly dedicated to diversity in our work and staff. We do not discriminate in employment opportunities or practices on the basis of actual or perceived race, color, religion, national origin, sex (including pregnancy, childbirth, or related conditions), age, marital status, sexual orientation, gender identity or expression, veteran status, uniform service member status, disability or any other characteristic protected by law. Women, people of color, including bilingual and bicultural individuals, LGBTQ+ persons, and people with disabilities are encouraged to apply. CALIFORNIA PRIVACY RIGHTS ACT (CPRA) NOTICE Teton Ridge is committed to protecting your privacy. If you are a California resident, the California Privacy Rights Act (CPRA) grants you specific rights regarding the collection, use, and sharing of your personal information. Information We Collect As part of the application and recruitment process, we may collect personal information, including but not limited to Contact details (e.g., name, email, phone number), Employment history and qualifications, Identifiers such as IP address or device information when applying online, and Any other information you provide during the hiring process. How We Use Your Information We use your personal information to assess your qualifications and suitability for employment, communicate with you regarding your application, maintain records related to hiring decisions, and comply with legal and regulatory obligations. Your CPRA Rights As a California resident, you have the right to: - Access the personal information we collect about you - Request deletion of your personal information, subject to legal exceptions - Correct inaccuracies in your personal information - Opt-out of certain data sharing practices How to Exercise Your Rights To submit a request, use this form. For verification, we may require additional details to confirm your identity. By submitting your application, you acknowledge and agree to the collection and use of your information as described in this notice.

Responsibilities

Maintain and optimize data pipelines and ETL connectors across various marketing and social platforms. Develop executive-level dashboards and reporting methodologies to track streaming performance and audience engagement.