Platform Support Lead

TechDigital Group; Bolingbrook (IL); On-site; USD 80,000 - 100,000; Full time

Job summary

A cutting-edge technology firm in Illinois is seeking a platform administrator for their data warehouse using BigQuery and Power BI. The role includes managing the infrastructure, security, and performance of the data environment, along with ensuring data integrity and accessibility for users. The ideal candidate should have strong experience in data warehousing concepts, advanced SQL, and Power BI administration. This position offers an opportunity to work in a dynamic environment with a focus on data governance and collaboration with stakeholders.

Qualifications

• Strong experience in Data Warehousing concepts and practices.
• Proficiency in Google BigQuery and advanced SQL.
• Experience with Power BI administration and performance monitoring.

Responsibilities

• Manage projects, datasets, and tables within BigQuery.
• Implement and manage access controls for data security.
• Ensure optimal performance and cost control for BigQuery usage.
• Configure user roles and permissions in Power BI.

Skills

Big Query

SQL

ETL

Data Flow

Power BI

Collibra

Theobald

Tools

Google Cloud Platform

Power BI Service

Job description

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.