Senior Data Engineer
| Company | Point |
|---|---|
| Location | Washington, USA, Kansas, USA, Pennsylvania, USA, Oregon, USA, California, USA, Washington, DC, USA, Texas, USA, Jackson Township, NJ, USA, Florida, USA, Waterbury, CT, USA, Nevada, USA, South Carolina, USA, Georgia, USA, Arizona, USA, Tennessee, USA, Virginia, USA, Arkansas, USA, Minnesota, USA, Colorado, USA, Utah, USA, Kentucky, USA, New York, NY, USA, Massachusetts, USA, North Carolina, USA, Missouri, USA, Ohio, USA, Michigan, USA, Illinois, USA, Alabama, USA |
| Salary | $116500 – $196700 |
| Type | Full-Time |
| Degrees | |
| Experience Level | Senior |
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 is preferred.
- Familiarity with BI and visualization tools (e.g., Tableau, Looker).
- Knowledge of data quality tools preferred (e.g., Monte Carlo, Metaplane, Great Expectations).
- Project management or cloud platform certifications.
- Understanding of stream processing, message queues, NoSQL databases, or Apache Spark.