Senior Data Engineer

Summary

Join Point as a Senior Data Analytics Engineer and contribute to enhancing and expanding our data systems. You will maintain and improve analytics tools, integrate external data sources, and build reliable data sets for reporting and business insights. This role also involves automating processes to support data science and machine learning initiatives. We are seeking a candidate with 3-5 years of experience in data engineering, data analytics, or business analysis, strong SQL skills, and experience with cloud data warehouses. Point offers a comprehensive benefits package including generous health benefits, unlimited paid time off, flexible remote work options, and fully paid parental leave. We are a people-first, value-driven team committed to improving the lives of our customers.

Requirements

• 3-5 years of experience in data engineering, data analytics, or business analysis roles
• 3 years of experience writing SQL for data warehousing
• 2-3 years of experience working on data warehouses to support analytics
• 2-3 years of experience building and maintaining enterprise data models, such as fact/dimensional star schemas
• Proficiency in cloud data warehouses (Redshift, BigQuery, Snowflake)
• Strong SQL query writing and data modeling capabilities
• Experience with Python for scripting, data manipulation, and API interaction
• Familiarity with version control systems (e.g., Git, GitHub, GitLab)
• Experience with workflow orchestration tools (e.g., Apache Airflow)
• Knowledge of cloud platforms, particularly AWS

Responsibilities

• Create and maintain Apache Airflow data pipeline jobs
• Monitor and update Fivetran extract and load runs
• Create and govern dbt models, testing, and job runs
• Monitor and maintain data quality processes and procedures
• Own, manage, and govern Snowflake data warehouse, including permission grants
• Maintain and govern usage of data sent from Snowflake to source systems (“Reverse ETL”)
• Collaborate with stakeholders to maintain and monitor existing data pipelines
• Evaluate automation opportunities within the business, using available data tools
• Provide data set and tooling recommendations where appropriate
• Provision data sets for analytic, master data, and reporting use cases

Preferred Qualifications

• Experience with dbt for data transformation
• Familiarity with BI and visualization tools (e.g., Tableau, Looker)
• Knowledge of data quality tools (e.g., Monte Carlo, Metaplane, Great Expectations)
• Project management or cloud platform certifications
• Understanding of stream processing, message queues, NoSQL databases, or Apache Spark

Benefits

• Generous health benefits: medical, dental, and vision plans with options for flexible spending accounts (FSA) and health savings accounts (HSA)
• Unlimited paid time off and 10 company holidays
• Flexible remote & onsite work options; fully remote work supported
• Fully paid parental leave: Point will true-up wages from state-applicable PFL earnings to 100% of regular base pay, plus two weeks of fully paid leave after state PFL exhaustion; up to 8 weeks for states without Paid Family Leave; 4 weeks of fully paid transition time; part-time work option at 100% pay for four weeks post-leave
• Financial wellness: 401K retirement plans, guaranteed life insurance, short- and long-term disability coverage, equity options for full-time employees
• Extra work/life benefits: monthly stipends for internet and mobile plans, one-time home office reimbursement