BI Data and Reporting Specialist

About the Job At Pilothouse, Data and Reporting Specialists are the backbone of our client performance visibility. This is not a passive reporting or entry-level data entry role. We are looking for someone who can manage complex data flows, bridge the gap between BigQuery architecture and Looker Studio dashboards, and ensure our internal teams have accurate, actionable data at all times. You will manage a portfolio of approximately 100 Looker Studio client reports, working within our established BigQuery data warehouse and template framework. Success in this role comes from maintaining high data integrity across a large client roster, swiftly actioning dashboard customization requests, and serving as a trusted internal advisor to account managers on platform and reporting logic. What You'll Do Own the deployment, maintenance, and QA of approximately 100 Looker Studio client dashboards at any given time, based on standardized agency templates Action internal requests from account teams to customize reports, add new charts, or adapt metrics to align with specific client goals Work within our existing BigQuery architecture to update variables, manage client rosters, map new fields, and integrate new ad platforms into existing pipelines Serve as the primary internal contact for account managers regarding reporting logic, data anomalies, and dashboard functionality Proactively monitor report performance and data flows to troubleshoot bugs and continuously refine reporting…