Seeking a Data Analytics Support Engineer with expertise in GCP BigQuery and dbt to support and monitor enterprise analytics platforms and data pipelines
Job Details:
- Support and monitor production dbt pipelines scheduled jobs and data transformation workflows
- Monitor GCP BigQuery datasets queries and data loads to ensure data accuracy and availability
- Investigate and resolve data pipeline failures source freshness issues model failures and data quality exceptions
- Analyze dbt execution logs BigQuery query performance and system alerts to identify root causes and implement fixes
- Perform data validation reconciliation and quality checks to ensure trustworthy analytics outputs
- Collaborate with Data Engineers BI Developers Analysts and business stakeholders to resolve production issues and support analytics requirements
- Manage incidents service requests and problem tickets while adhering to SLA commitments Support deployment activities release validations and postproduction monitoring of analytics solutions
- Develop and maintain operational documentation support runbooks SOPs and knowledge base articles
- Create monitoring dashboards and reports to track pipeline health job failures and system performance trends Identify recurring issues and drive continuous improvement through automation and proactive monitoring
Roles and Responsibilities
- Strong experience with dbt Core andor dbt Cloud Handson experience with Google BigQuery and GCP services
- Advanced SQL development debugging and optimization skills
- Knowledge of Data Warehousing ELTETL concepts and dimensional data modeling
- Experience in production support incident management and root cause analysis
- Familiarity with Git CICD processes and release management practices
- Experience with monitoring and alerting frameworks Knowledge of ServiceNow or other ITSM tools
- Strong analytical troubleshooting and communication skills Positive to have Apache Airflow GCP Workflows Python for data scripting.