Senior Analytics Engineer

Summary

Join PrizePicks, a rapidly growing sports company, as an Analytics Engineer and contribute to building and maintaining data models and transformation pipelines. Partner with Data Engineering and Business Intelligence teams to ensure data accessibility, implement business logic for BI dashboards, and deliver actionable insights. Design and implement data transformation workflows using best practices, build and maintain dbt models, and implement data quality checks. Collaborate with stakeholders to understand data requirements and develop comprehensive documentation. Develop and manage CI/CD pipelines, champion data governance principles, and mentor team members. This role requires strong SQL skills, experience with ELT processes, and familiarity with various data tools and technologies.

Requirements

• Experience in designing and implementing data transformation workflows using best practices in data modeling, ELT processes, and ensuring data quality and consistency for analytical use cases
• Experience in championing and implementing data governance principles, such as data lineage and data cataloging, to improve data discoverability, usability, and trust for analytical purposes
• 5+ years of experience in an Analytics Engineering, Data Engineering, or data-oriented software engineering role creating and pushing end-to-end data engineering pipelines
• 1+ years of experience acting as technical lead and providing mentorship and feedback to junior engineers
• Graduate degree in a quantitative field: Computer Science, Mathematics, Statistics, Business Analytics, Engineering) or equivalent experience
• Proven experience in guiding complex projects and mentoring other engineers
• Experience building and optimizing data pipelines for analytics, with a focus on data transformation and modeling
• Experience in integrating data from various sources to support analytical needs, including familiarity with data warehousing principles and ELT processes
• Experience in most of the following: ELT tools: dbt
• SQL/NoSQL databases/warehouses: Postgres, BigQuery, BigTable, etc
• Replication Services: Data Stream, Hevo, Kafka, etc
• Scripting languages: SQL, Python
• Familiarity with cloud platform data services, such as data warehousing solutions (e.g., BigQuery, Snowflake, Redshift) and storage (e.g., Cloud Storage, S3)
• Code version control: Git
• Data pipeline and workflow tools relevant to analytics: Dataform, Spark, orchestration tools used in data analytics workflows (e.g., Argo Workflows, Airflow, cloud-based workflow services), and customer data platforms (e.g. Segment, Rudderstack)
• Data visualization and BI tools knowledge (e.g., Tableau, Looker)
• Excellent organizational, communication, presentation, and collaboration experience with organizational technical and non-technical teams
• Strong experience in dimensional modeling, data warehousing, and data mart design
• Ability to translate business questions into data requirements and analytical solutions
• Experience contributing to and implementing data quality standards and data governance principles

Responsibilities

• Partner with Data Engineering to build and optimize robust data pipelines that ensure data accessibility and reliability
• Collaborate with Business Intelligence to implement crucial business logic that powers BI dashboards, directly impacting key business decisions and providing broad organizational exposure
• Design and implement complex data transformation logic primarily in SQL with a focus on creating reusable data models that support various analytical needs
• Build and maintain dbt models to ensure data accuracy, consistency, and reliability
• Collaborate with data engineers, data analysts, and business stakeholders to understand data requirements, define key metrics, and deliver actionable insights through data models and reporting solutions
• Implement and maintain data quality checks and validation processes to ensure the accuracy and reliability of data used for analysis
• Develop comprehensive documentation of data models, and transformation logic to facilitate data understanding
• Develop and manage CI/CD pipelines to automate and streamline the deployment of data solutions
• Ensure that data workflows are thoroughly tested, integrated, and deployed efficiently, following best practices for version control, automation, and quality assurance
• Serve as a leading voice within the Analytics Engineering team by staying current with emerging analytical techniques, data modeling best practices, and analytics engineering trends
• Actively mentor other team members and promote a data-driven culture by leading through example and sharing best practices
• On-call rotation support, the on-call is shared across Analytics and Data Engineering teams

Preferred Qualifications

Preferred: experience in a daily fantasy sports platform or a similar data-intensive analytical environment, with a proven track record of delivering impactful data insights

Benefits

• Company-subsidized medical, dental, & vision plans
• 401(k) plan with company match
• Annual bonus
• Flexible PTO to encourage a healthy work/life balance (2 weeks STRONGLY encouraged!)
• Generous paid leave programs, including 16-week paid parental leave and disability benefits
• Workplace flexibility and modern work schedules focused on getting the job done, not hours clocked
• Company-wide in-person events and team outings
• Lifestyle enhancement program
• Company equipment provided (Windows & Mac options)
• Annual performance reviews with opportunities for growth and career development