Senior Analyst

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