[Remote] Senior Data Engineer

Note: The job is a remote job and is open to candidates in USA. PFF is a leading sports analytics company that transforms complex football data into powerful insights. They are seeking a Senior Data Engineer to lead the architectural redesign of their PostgreSQL database and optimize data delivery for client-facing APIs and internal tools.ResponsibilitiesLead the Architectural Redesign: Analyze and re-architect the existing highly-normalized PostgreSQL database, driving the transition to a modern, high-performance analytical data modelOptimize for Performance: Redesign schemas, balancing normalization with analytical read efficiency. Strategically apply denormalization, materialized views, and dynamic queries to support high-speed data accessScale 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 toolsData Pipeline Excellence: Design, implement, and maintain scalable data pipelines and ETL/ELT frameworks across distributed systems to ensure data reliability and freshnessTechnical Leadership: Act as a subject matter expert, guiding the engineering team on best practices for data modeling, query optimization, and architectural decisionsSkills5+ years of experience as a Senior Data Engineer, Database Architect, or equivalent role in high-scale, read-heavy data systemsExpert-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 warehousesDeep practical knowledge of advanced database concepts including indexing strategies, partitioning, caching mechanisms, and replication patternsStrong experience with building and managing data ingestion pipelines and ETL/ELT processes in a modern cloud environmentExceptional communication and collaboration skills. Must be proactive, articulate, and comfortable managing technical scope and expectations with leadership and product stakeholdersPrior professional experience working with data systems in sports analytics, betting, or digital mediaExperience operating within a globally distributed team spanning the US and UK time zonesA pragmatic, hands-on approach: a willingness to dive into legacy schema cleanup while simultaneously designing future-state systems and leading by exampleCompany OverviewPFF's enterprise analytics business has joined Teamworks to better serve professional teams and collegiate programs around the world. It was founded in 2015, and is headquartered in Cincinnati, Ohio, USA, with a workforce of 11-50 employees. Its website is https://www.pff.com/.Company H1B SponsorshipPFF has a track record of offering H1B sponsorships, with 2 in 2021. Please note that this does not guarantee sponsorship for this specific role.