Senior Data Engineer

Gathern

1. Data Engineering & Pipeline Ownership

• Design, build, and maintain scalable data pipelines feeding the central data warehouse (BigQuery).
• Ensure data accuracy, freshness, reliability, and consistency across all BI and analytics datasets.
• Own data modeling, schema design, and documentation standards.
• Support efficient onboarding of new data sources with minimal rework.
• Optimize data access patterns and performance for BI tools (e.g., Power BI).

2. Data Quality, Observability & Reliability

• Implement and maintain data quality checks and monitoring mechanisms.
• Define and enforce core data quality dimensions (accuracy, completeness, consistency, timeliness, validity).
• Build automated validation checks (freshness SLAs, null thresholds, schema drift detection, referential integrity).
• Monitor data quality metrics and proactively alert on issues before they impact decision-making.
• Troubleshoot, debug, and resolve data pipeline and data quality incidents.

3. Collaboration & Enablement

• Partner closely with BI, Analytics, Product, and Engineering teams to support reporting and insight needs.
• Enable self-service analytics through well-designed, documented, and trusted datasets.
• Clearly document technical decisions, data models, and pipeline logic.
• Support data access controls, permissions, and security best practices in cloud environments.

• Strong proficiency in SQL, including complex queries and analytical modeling.
• Hands-on experience with Google BigQuery or comparable cloud data warehouses.
• Proven experience designing and operating ETL / ELT pipelines.
• Experience using Apache Airflow for orchestration and scheduling.
• Solid understanding of data modeling concepts (fact tables, dimensions, schema design).
• Experience working with semi-structured data (JSON, events, logs).
• Understanding of access control, permissions, and basic data security concepts in cloud environments.

Required Skills & Experience

• 3+ years of experience in data engineering or similar roles.
• Strong problem-solving and troubleshooting skills.
• Ability to work effectively with BI analysts, system analysts, and backend engineers.
• Clear communication skills and ability to document technical decisions.
• Comfortable operating in a fast-moving, evolving data environment.