Sr. Data Engineer

Job Title: Senior Data Engineer

Experience Required: 6+ Years

Engagement Type: Contract

About

• Linksoft is seeking two Senior Data Engineers with deep Google Cloud Platform and BigQuery experience to deliver hands-on technical discovery and assessment work for a data architecture engagement on behalf of a client.
• The client operates a mature data environment centered on Google BigQuery, with integrations spanning Salesforce, Snowflake, HubSpot, and several homegrown and third-party systems.
• This engagement is a time-boxed advisory assessment and not an implementation project.

Key Responsibilities

• Environment Baseline Metrics — GCP billing exports, BigQuery cost decomposition, slot vs on-demand analysis, storage growth trending, and 12-month cost trajectory.
• Asset & Integration Inventory — discovery across platforms, pipelines, APIs, and undocumented integrations.
• Pipeline & ETL Assessment — orchestration review, error handling, idempotency, schema evolution, CDC patterns, and production pipeline case studies.
• Data Quality & Validation Assessment — validation coverage, lineage capability, reconciliation practices, and business impact mapping.
• Monitoring & Observability Assessment — monitoring posture, MTTD analysis, and monitoring stack recommendations.

Must-Have Skills

• Advanced Google BigQuery expertise including INFORMATION_SCHEMA introspection, query optimization, schema and dataset management.
• Experience with GCP billing exports, BigQuery IAM, partitioning, clustering, and metadata tables.
• Hands-on experience with Airflow or Cloud Composer, dbt, ETL/ELT design, and Fivetran or Airbyte.
• Strong understanding of data quality frameworks, pipeline observability, reconciliation, and backup/recovery assessment.
• Technical documentation and client-facing communication skills.

Good-to-Have Skills

• Snowflake knowledge
• Salesforce or HubSpot API familiarity
• Observability tooling such as Monte Carlo or Datafold
• Python scripting for pipeline automation
• GCP certifications

Experience Profile

• 6+ years in data engineering roles
• Minimum 3 years hands-on BigQuery experience
• Minimum 2 years Airflow or Cloud Composer experience
• Minimum 2 years dbt experience
• Experience in SaaS, technology, or professional services preferred