PFF
About PFF
PFF is a leading sports analytics company that transforms complex football data into powerful insights. Our exclusive player grades, advanced metrics, and tools fuel winning decisions for NFL and college teams, broadcasters, fantasy players, bettors, and fans alike.
Key ResponsibilitiesLead 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.Skills & Experience5+ 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 HavePrior 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.
Originally posted on Himalayas
To apply for this job please visit himalayas.app.
About this role & career path
Working in United States
The United States of America (USA), also known as the United States (U.S.) or America, is a country primarily located in North America. It is a federal republic consisting of 50 states and a federal capital district, Washington, D.C. The 48 contiguous states border Canada to the north and Mexico to the south, with the semi-exclave of Alaska in the northwest and the archipelago of Hawaii in the Pacific Ocean. The United States also asserts sovereignty over five major island territories and various uninhabited islands in Oceania and the Caribbean. It is a megadiverse country, with the world's th
Keep exploring on Get A Job.ai
Not quite the right fit? Your next opportunity is a click away.
- Browse all jobs
- More jobs by category
- Remote jobs you can do from anywhere
- Research typical pay for this role
- Set a job alert so new matches reach you first
- Upload your resume to apply faster
Hiring instead? Post a job and reach candidates searching right now.