Data Engineer

Role & responsibilities

DATA ENGINEER - BigQuery & Analytics Infrastructure

Preferred candidate profile

DATA ENGINEER - BigQuery & Analytics Infrastructure

Position Title:

Position Summary:

Core Responsibilities:

• Architect BigQuery datasets for student journey analytics (inquiry enrollment progression)
• Implement ETL pipelines using Dataflow and Cloud Composer for institutional data sources
• Design feature stores in Vertex AI Feature Store for reusable ML features
• Optimize BigQuery performance through partitioning, clustering, and materialized views
• Implement data quality frameworks and lineage tracking for FERPA compliance
• Create scheduled SQL pipelines for cohort analysis and enrollment forecasting
• Integrate third-party data sources (CRM, LMS, financial systems) into BigQuery
• Develop data cataloging and metadata management for analytics governance
• Support Data Scientists with SQL optimization and data access patterns
• Document data pipelines and maintain runbooks for Client internal teams

Required Technical Skills:

• BigQuery: Advanced SQL optimization, ML integration, geospatial analysis
• GCP Data Tools: Dataflow (Apache Beam), Cloud Composer (Airflow), Pub/Sub
• Python: Apache Beam SDK, dbt for transformations, Great Expectations for quality
• Data Orchestration: Workflow scheduling, dependency management, error handling
• Data Governance: Collibra, Data Catalog, lineage tracking, PII detection

Higher Education Data Expertise:

• Integration experience with SIS (Student Information Systems), CRM platforms
• Handling of time-series academic data and cohort analysis
• Data privacy implementation (FERPA, GDPR) in educational contexts
• Scalable data warehousing for multi-institution deployments

Qualifications:

• Bachelor's/Master's in Computer Science, Data Engineering, or related
• 5+ years data engineering experience; 2+ years GCP/BigQuery
• Google Cloud Professional Data Engineer certification preferred
• Experience with education data ecosystems

DATA ENGINEER - BigQuery & Analytics Infrastructure

Position Title:

Position Summary:

Core Responsibilities:

• Architect BigQuery datasets for student journey analytics (inquiry enrollment progression)
• Implement ETL pipelines using Dataflow and Cloud Composer for institutional data sources
• Design feature stores in Vertex AI Feature Store for reusable ML features
• Optimize BigQuery performance through partitioning, clustering, and materialized views
• Implement data quality frameworks and lineage tracking for FERPA compliance
• Create scheduled SQL pipelines for cohort analysis and enrollment forecasting
• Integrate third-party data sources (CRM, LMS, financial systems) into BigQuery
• Develop data cataloging and metadata management for analytics governance
• Support Data Scientists with SQL optimization and data access patterns
• Document data pipelines and maintain runbooks for Client internal teams

Required Technical Skills:

• BigQuery: Advanced SQL optimization, ML integration, geospatial analysis
• GCP Data Tools: Dataflow (Apache Beam), Cloud Composer (Airflow), Pub/Sub
• Python: Apache Beam SDK, dbt for transformations, Great Expectations for quality
• Data Orchestration: Workflow scheduling, dependency management, error handling
• Data Governance: Collibra, Data Catalog, lineage tracking, PII detection

Higher Education Data Expertise:

• Integration experience with SIS (Student Information Systems), CRM platforms
• Handling of time-series academic data and cohort analysis
• Data privacy implementation (FERPA, GDPR) in educational contexts
• Scalable data warehousing for multi-institution deployments

Qualifications:

• Bachelor's/Master's in Computer Science, Data Engineering, or related
• 5+ years data engineering experience; 2+ years GCP/BigQuery
• Google Cloud Professional Data Engineer certification preferred
• Experience with education data ecosystems