Data Engineer

Job Summary

This hybrid role is for an experienced Architect with ten to fourteen years of hands on data engineering and analytics experience focused on BigQuery. The architect will design scalable data platforms optimize complex queries and guide teams in building secure and reliable analytical solutions that help the organization make evidence based decisions and deliver meaningful outcomes for clients and communities.

Responsibilities

• Design robust BigQuery based data architectures that support large scale analytics and reporting needs while ensuring performance reliability and cost efficiency
• Develop optimized data models and partitioning strategies in BigQuery that improve query speed data quality and maintainability for complex analytical workloads
• Create reusable patterns for data ingestion transformation and storage using BigQuery and complementary cloud native services to streamline project delivery
• Implement query optimization techniques including clustering indexing alternatives and efficient SQL patterns to reduce processing time and resource consumption
• Define standards for data security access control and compliance within BigQuery environments to protect sensitive information and align with organizational policies
• Partner with product and business stakeholders to translate analytical requirements into practical BigQuery solutions that deliver measurable value and improved decision making
• Coordinate with data engineers analysts and platform teams to ensure consistent adoption of BigQuery best practices across projects and environments
• Develop monitoring and observability practices for BigQuery workloads using logging and metrics to detect issues early and ensure stable system performance
• Prepare technical design documents solution diagrams and reference guides that clearly describe BigQuery architectures and data flows for technical and nontechnical audiences
• Conduct code reviews and performance assessments for SQL scripts and data pipelines running on BigQuery to ensure adherence to standards and continuous improvement
• Provide technical guidance on migration of existing data warehouses and analytics solutions into BigQuery with a focus on risk mitigation and smooth transition
• Advise on cost management strategies such as workload sizing storage optimization and scheduling to ensure BigQuery usage remains sustainable and predictable