Data Engineer | The Points Guy

The Points Guy is a company focused on providing seamless digital experiences and is seeking a Data Engineer to build data products that support their machine learning and business analytics efforts. The role involves designing and building data pipelines, partnering with various teams to create scalable data models, and ensuring the reliability of data pipelines.

Responsibilities:

• Design and build data pipelines from various sources to data warehouse using batch or incremental loading strategies utilizing cutting edge cloud technologies
• Conceptualizing and generating infrastructure that allows data to be accessed and analyzed effectively
• Engineer reliable data pipelines - Implement Python/Spark jobs, dbt transformations, and Orchestration with CI/CD (GitHub Actions, Terraform)
• Partner with analytics and product teams to translate business needs into scalable data models and solutions

Requirements:

• Must be located in the Eastern or Central Time Zone and be based in the United States
• 3+ years of experience working with SQL
• 3+ years of experience performing production data engineering/ETL work
• 3+ years of experience with one of the major cloud providers (we use AWS but we welcome candidates with experience in Azure or GCP)
• 3+ years of experience working on Spark/SparkSQL using Scala/Python to build and maintain complex ETL pipelines
• Experience with GitHub and CI/CD processes
• Experience working on Orchestration (Databricks Workflows / Airflow)
• Experience with one of the major data warehousing solutions (we use Databricks but we welcome candidates with experience in BigQuery, Snowflake, Oracle or Redshift)
• Conceptual understanding of data warehousing and dimensional modeling
• Experience providing operational support for the production data pipelines and data triaging
• Familiarity with SaaS like Fivetran and Hightouch is a plus