Analytics Engineer

The Analytics Team is responsible for building and maintaining analytics tools and workflows to support the PrizePicks business across all departments — at the core of these operations is data. As an Analytics Engineer, you are passionate about distilling disparate data into highly visible and actionable insights and helping build a world-class Analytics organization. By developing, maintaining, and testing data generation infrastructures, you will enable the PrizePicks to make smarter, better, and faster data-driven decisions.

What you’ll do:

• Create and maintain optimal data pipeline architecture, ensuring data reliability in operationalized data sets.
• Expand our data lake with clean, reliable, and timely data ready for analysis.
• Define and improve our internal standards for data format, maintainability, observability, and best practices for a rapidly scaling data infrastructure.

What you have:

• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.  
• Strong analytic skills related to working with unstructured datasets. 
• Experience building and optimizing ETL/ELT ‘big data’ pipelines, architectures, and data sets.
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement. 
• Experience building data visualizations and dashboards for internal/external stakeholder communication and insights
• 2+ years of experience in a data analytics or data engineering role
• A graduate degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field.
• Experience using the following software/tools:
  • Data Ingestion tools: Hevo, Fivetran, Stitch, etc.
  • Relational SQL databases/warehouses: Postgres, BigQuery.
  • Object-oriented/object function scripting languages: Python.
  • Data modeling tools: dbt Cloud and Core.
  • Cloud platform services in GCP and analogous systems: BigQuery, BigTable, Cloud Storage, Cloud Compute Engine, Looker, DataStudio, CloudSQL.
  • Dashboarding platforms: Tableau, Looker, etc
  • Code version control: Git
  • Preferred experience with data observability/freshness/lineage tools: Elementary
  • Preferred experience with big data tools: Dataproc, Hadoop, Spark,, etc.
  • Preferred experience with data pipeline and workflow tools: Prefect, Airflow, Cloud Composer, Azkaban, Luigi, etc.

Where you’ll live:

• This is a remote position but preference given to candidates based in Atlanta, GA 

Benefits you’ll receive: 

In addition to your great compensation package, company subsidized medical/dental/vision coverage plans and matching 401(k), we’ll shower you with perks including: 

• Break room with ping pong, endless snacks and in-office lunch once a week
• Unlimited PTO to encourage a healthy work/life balance (2 week min required!)
• Modern work schedule focused on getting the job done, not hours clocked
• Workplace flexibility
• Company and team outings, we encourage a tight-knit workplace
• Generous Maternity AND Paternity leave (16 weeks!)
• Annual bonus & stock options
• Wellness program
• Company equipment provided (Windows & Mac options)
• Annual performance reviews with opportunity for growth and career development