Key Responsibilities
1. Pipeline Ownership & Maintenance
- Manage the full data pipeline from source systems (trackers, workflow tools) through GCP/BigQuery into Power BI dashboards
- Execute and oversee weekly data refresh processes, including data consolidation, transformation (Alteryx), and uploads to BigQuery
- Ensure data accuracy, schema alignment, and timely availability of dashboards
2. Data Engineering (GCP / BigQuery)
- Manage GCP Cloud Storage and BigQuery tables (mapped/unmapped datasets, staging pipelines)
- Troubleshoot data load issues, schema mismatches, and pipeline failures
- Work with scheduled queries and ensure downstream tables used in Power BI remain stable
3. Power BI Development & Support
- Maintain and enhance Power BI dashboards (data models, transformations, validations)
- Validate dashboard outputs post-refresh and resolve data discrepancies
- Optimize performance and usability for business stakeholders
4. Business Requirements & Solutioning
- Act as the primary point of contact for new business requests and enhancements
- Translate business requirements into scalable data models, transformations, and BI solutions
- Proactively identify gaps and recommend improvements (data logic, process automation, reporting structure)
5. Problem Solving & Continuous Improvement
- Diagnose data issues across multiple layers (source transformation reporting)
- Design scalable fixes instead of tactical workarounds
- Drive automation and reduce manual dependencies in the pipeline
Key Skills Required
- GCP / BigQuery (data pipelines, table management, queries)
- Power BI (data modeling, DAX, dashboard development)
- Data Engineering fundamentals (ETL, schema design, data validation)
- Advanced Excel / Data transformation tools (Alteryx preferred)
- Strong problem solving & critical thinking
- Ability to translate ambiguous business requirements into solutions
Profile We Need
- Owns problems end-to-end (not just updates status)
- Can independently figure out gaps + propose solutions
- Comfortable debugging across multiple systems (Excel GCP BI)
- Balances technical depth + business understanding