Data Engineer | The Points Guy

What You’ll Do

• 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.

What We’re Looking For

• 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

Compensation

• Total Cash Compensation Range: $80,000 - $140,000 per year
• New York City Total Cash Compensation Range: $80,000 - $175,000 per year

Benefits

• Health Insurance Coverage (medical, dental, and vision)
• Life Insurance
• Short and Long-Term Disability Insurance
• Flexible Spending Accounts
• Holiday Pay
• 401(k) with match
• Employee Assistance Program
• Paid Par