SONAR/FreightWaves is seeking a Senior Data Engineer to join their innovative and creative engineering team.
The position is fully remote, but candidates must reside in the United States and be eligible to work within the US.
Responsibilities include implementing ingestion pipelines using Airflow, transformation pipelines with DBT, and maintaining infrastructure for API and SaaS products.
The role involves defining quality control processes for data ingestion and transformation, building pipelines across multiple technologies and cloud environments, and ensuring data automation stability.
The Senior Data Engineer will review existing infrastructure for enhancements and work closely with Data Science for advanced data analysis.
Requirements:
Candidates must have a strong working knowledge of Apache Airflow.
Experience supporting a SaaS or DaaS product is required, with bonus points for creating new data products or features.
Proficiency in Linux environments and scripting languages is necessary.
Expertise in Python is essential.
A strong understanding of software best practices and associated tools is required.
Experience with major RDBMS such as MySQL, Postgres, or SQL Server is needed.
Strong SQL skills are required, with bonus points for experience in both T-SQL and Standard SQL.
Familiarity with NoSQL databases like Elasticsearch or MongoDB is necessary.
Multi-cloud and/or hybrid-cloud experience is preferred.
Strong interpersonal skills are essential, along with the ability to work with non-technical data providers.
Experience with cloud storage, Cloud Pubsub, BigQuery, Apache Airflow, dbt, and DataFlow is required.
Benefits:
The company offers an excellent work environment with flat hierarchies and short decision paths.
A generous benefits package includes 100% employer-paid health, dental, vision, and life insurance, as well as STD and LTD.
Employees receive stock options and an appealing 401k matching plan.
There is a student loan reimbursement program after one year of employment.
An annual life achievement bonus is provided for significant life events such as having a baby, buying a house, or getting married.
The company has an unlimited PTO policy, allowing team members to take time off as needed with supervisor approval.
Employees can receive up to $50 for gym or virtual gym memberships and up to $20 for AI subscriptions.