BigQuery Management:
- Resource Management: Managing projects, datasets, and tables within BigQuery, including creating, deleting, and configuring them.
- Security and Access: Implementing and managing access controls to ensure data security and compliance with data governance policies.
- Workload Management:Monitoring and managing jobs, queries, and compute capacity to ensure optimal performance and cost control.
- Performance Optimization: Identifying and resolving performance bottlenecks, optimizing queries, and managing costs associated with BigQuery usage.
- Troubleshooting: Investigating and resolving issues related to data loading, query performance, and other BigQuery related problems.
Power BI Management:
- User Management: Configuring user roles, permissions, and access to Power BI reports and dashboards.
- Settings and Configuration: Managing Power BI settings, including data refresh schedules, gateway configurations, and other organizational settings.
- Resource Provisioning: Ensuring that Power BI resources are provisioned appropriately to meet user needs and performance requirements.
- Monitoring and Reporting: Monitoring Power BI usage, identifying potential issues, and generating reports on key performance indicators.
General Responsibilities:
- Data Governance: Implementing and enforcing data governance policies and procedures to ensure data quality, consistency, and security.
- Collaboration: Working with business analysts, data scientists, and other stakeholders to understand their data needs and provide solutions.
Qualification:
- Strong experience in Data Warehousing concepts and practices, including data modeling and ETL/ELT processes.
- Proficiency in Google BigQuery, including advanced SQL, query optimization, and BigQuery ML (a plus).
- Strong experience with Power BI administration, including Power BI Service management, user security, data gateways, and performance monitoring.
- Experience with other relevant Google Cloud Platform services (like Cloud Storage, Dataflow) is beneficial.
- Familiarity with other data tools (e.g., Collibra, Theobald) can be a plus