Primary Skills: Big Query, SQL and ETL, Data Flow, power BI
Secondary Skills: Collibra, Theobald
Job Summary: A platform administrator for a data warehouse using BigQuery and Power BI is responsible for managing the infrastructure, security, and performance of the data warehouse environment, as well as ensuring data integrity and accessibility for users. This includes tasks like managing projects, datasets, and tables within BigQuery, configuring user access, monitoring resource usage, and optimizing performance. Additionally, the role involves managing Power BI administration, including user access, settings, and resource provisioning.
Here's a more detailed breakdown of the responsibilities:
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.