Senior Data Engineer

Job not on LinkedIn

🕒 March 24

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

PFF

WebsiteLinkedInAll Job Openings

201 - 500 employees

⚽ Sports

📱 Media

☁️ SaaS

💰 $1M Seed Round - Pro Football Doc on 2020-10

Sports • Media • SaaS

PFF is a sports analytics and media company that grades every player and play to provide data-driven insights, news, and tools for NFL, college football, fantasy football, and betting audiences. The company offers premium subscription products, interactive tools (mock draft simulator, draft assistant, projections), newsletters, and a large database of advanced player performance metrics used by fans, fantasy managers, and industry professionals.

📋 Description

• Lead the Architectural Redesign: Analyze and re-architect the existing highly-normalized PostgreSQL database, driving the transition to a modern, high-performance analytical data model. • Optimize for Performance: Redesign schemas, balancing normalization with analytical read efficiency. • Strategically apply denormalization, materialized views, and dynamic queries to support high-speed data access. • Scale Data Delivery: Introduce advanced PostgreSQL strategies including robust indexing, partitioning, caching, and replication to ensure high-throughput and low-latency access for client-facing APIs and internal tools. • Data Pipeline Excellence: Design, implement, and maintain scalable data pipelines and ETL/ELT frameworks across distributed systems to ensure data reliability and freshness. • Technical Leadership: Act as a subject matter expert, guiding the engineering team on best practices for data modeling, query optimization, and architectural decisions.

🎯 Requirements

• 5+ years of experience as a Senior Data Engineer, Database Architect, or equivalent role in high-scale, read-heavy data systems. • Expert-level proficiency in PostgreSQL schema design, optimization, and performance tuning (e.g., query planning analysis, configuration tuning). • Proven track record of successfully re-architecting complex, highly normalized OLTP systems into efficient OLAP/analytical data warehouses. • Deep practical knowledge of advanced database concepts including indexing strategies, partitioning, caching mechanisms, and replication patterns. • Strong experience with building and managing data ingestion pipelines and ETL/ELT processes in a modern cloud environment. • Exceptional communication and collaboration skills. • Must be proactive, articulate, and comfortable managing technical scope and expectations with leadership and product stakeholders. • Nice to Have: Prior professional experience working with data systems in sports analytics, betting, or digital media. • Experience operating within a globally distributed team spanning the US and UK time zones. • A pragmatic, hands-on approach: a willingness to dive into legacy schema cleanup while simultaneously designing future-state systems and leading by example.