What are the responsibilities and job description for the Data Engineer position at Gardner Resources Consulting, LLC?
Data Engineer
Requirements:
We are seeking Data Engineers - These hands-on opportunities involve developing reliable pipelines, migrating SQL and reporting workloads, improving data quality, and managing sensitive data in cloud warehouse environments. The ideal candidates will have strong SQL and Python skills, experience with GCP/BigQuery, and the ability to analyze complex data dependencies and validate results.
- Strong SQL and Python skills, including complex transformations, code analysis, automation, and query optimization.
- Experience building and maintaining production ETL/ELT pipelines and cloud data warehouses, preferably GCP/BigQuery.
- Strong understanding of data modeling, data lineage, dataset dependencies, and downstream reporting.
- Experience with data validation, source-to-target reconciliation, troubleshooting, and preserving business logic during migrations.
- Experience handling sensitive data, including PII identification, data masking, redaction, anonymization, or deletion, preferred.
- Familiarity with Git, CI/CD, and tools such as Airflow, Cloud Composer, dbt, SQLMesh, or Fivetran.
- Ability to collaborate with business and technical stakeholders, explain technical decisions, and document solutions.
Preferred experience:
- Migrating SQL code, data models, or BI reports from Teradata or Snowflake to cloud platforms.
- Building and reconciling financial, billing, subscription, payments, or revenue datasets.
- Using AI tools such as ChatGPT or Claude to support code analysis, development, and validation.
Position Details:
- Contract Position - 6 months plus potential extension
- W2 employment only. Applicants must be authorized to work in the United States. Employment visa sponsorship is not available for these positions.
- Remote - working Eastern Time
Salary : $55 - $65