* 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 recent 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