Looker & Quicksight Admin

StradIT•Dallas, TX

About The Position

This role requires extensive experience in managing Business Intelligence (BI) platforms, with a strong focus on Looker and Amazon Quicksight, alongside Power BI. The position involves designing and delivering complex platform architectures, implementing automation solutions using scripting, and managing security configurations. A key aspect of this role is ensuring platform governance, resiliency, and integrating BI tools with various external components and systems. The ideal candidate will possess strong analytical and problem-solving skills, a passion for data, and the ability to lead complex projects in a fast-paced, client-facing environment.

Requirements

10+ years of experience in managing BI platforms including Power BI, Looker, and Amazon Quicksight.
Experience in designing and delivering complex Platform architectures.
Extensive experience with Python programming, Shell Scripting, and Powershell Scripting.
Experience identifying and implementing various automation solutions using scripting.
Experience working on various product APIs to automate Admin functions.
Extensive knowledge and experience in setting up security using Active Directory, Azure AD, and Ping federate.
Experience configuring OAuth, SAML configurations for SSO implementation.
Experience in defining SDLC process and CICD process using Jenkins.
Experience integrating Looker with a Git repo for code commits.
Extensive knowledge and experience with platform governance and resiliency.
Power BI Service architecture design and administration including but not limited to Azure and Power BI Administration, PBI Premium Capacity Administration and extensive knowledge of Power BI Premium Service as a whole and how to troubleshoot and find opportunities for automation to streamline the day-to-day Operations of the platform.
Experience with Looker Setup and Administration.
Architect and develop data models, ETL packages, Reports utilizing Power BI applying best practices to the development lifecycle.
Data Modeling experience with Kimball method.
Experience with more than one database tool such as Snowflake, Oracle, DB2, SQL Server.
Understanding of various external components that BI tools depend on for successful connectivity, including understanding of Network, Firewall, Proxy etc.
Experience integrating Power BI with different tools which includes and not limited to Splunk, collibra, Service now.
Understanding of pre-requisites for a successful connection setup.
Strong ability to quickly propose solutions by recalling the latest best practices learned from MVP & Product Team articles, vendor documentation, whitepapers, and community publications.
A passion for understanding and integrating business semantics into technology solutions.
Ability to work in a fast-paced, dynamic, client-facing role where delivering solid work products to exceed high expectations is a measure of success.
Excellent communication, presentation, influencing, and reasoning skills.
Ability to lead complex projects.
Work closely with internal IT, Server, Security teams to troubleshoot including reviewing logs and resolve issues with production/non-production environments.
Work independently and provide solutions to users.
Manage Power BI Gateways to keep the dashboards and reports refresh automatically.
Build CI/CD pipeline to check in and migrate Power BI data sets/dashboards/reports between workspaces utilizing Power BI Rest APIs/Power Platform.
Build & Support Power BI platform metrics such as user tracking/logging, usage monitoring, anomalies detection in published data sets and reporting at an enterprise level using Power BI Platform.
Configure Power BI Tenant settings for PBI features such as (workspace settings, Export and sharing settings, Publish to web, Developer settings).
Manage Power BI Premium capacities for capacity planning and performance management.
Monitor premium capacities regularly to look for trends that indicate underlying issues.
Train self-service BI users and support the business in promoting self-service BI and the overall data platform through communications, collateral and training material.
Support BI production environment for large scale user base.
Available on call support for Production issues.
Provide leadership and vision for best usage and practices with regards to Cognos tool set.
Setting standards and guidelines for BI development.
Mentor other team members for knowledge transfer.

Nice To Haves

Certifications

Responsibilities

Manage BI platforms including Power BI, Looker, and Amazon Quicksight.
Design and deliver complex platform architectures.
Implement automation solutions using Python, Shell Scripting, and Powershell Scripting.
Automate Admin functions using product APIs.
Set up and manage security using Active Directory, Azure AD, and Ping federate.
Configure OAuth and SAML for SSO implementation.
Define SDLC and CI/CD processes using Jenkins.
Integrate Looker with Git repositories for code commits.
Ensure platform governance and resiliency.
Design and administer Power BI Service architecture, including Azure and Power BI Administration, PBI Premium Capacity Administration, and troubleshooting.
Set up and administer Looker.
Architect and develop data models, ETL packages, and reports using Power BI, applying best practices.
Perform data modeling using the Kimball method.
Work with multiple database tools such as Snowflake, Oracle, DB2, SQL Server.
Understand external components necessary for successful BI tool connectivity, including Network, Firewall, and Proxy.
Integrate Power BI with tools like Splunk, Collibra, and ServiceNow.
Understand prerequisites for successful connection setups.
Propose solutions by leveraging best practices from MVP & Product Team articles, vendor documentation, whitepapers, and community publications.
Integrate business semantics into technology solutions.
Work closely with internal IT, Server, and Security teams to troubleshoot and resolve issues in production/non-production environments.
Provide solutions to users independently.
Manage Power BI Gateways for automatic dashboard and report refreshes.
Build CI/CD pipelines for migrating Power BI datasets/dashboards/reports between workspaces using Power BI Rest APIs/Power Platform.
Build and support Power BI platform metrics such as user tracking/logging, usage monitoring, and anomaly detection.
Configure Power BI Tenant settings (workspace settings, export and sharing settings, publish to web, developer settings).
Manage Power BI Premium capacities for capacity planning and performance management.
Monitor premium capacities for underlying issues.
Train self-service BI users and support the business in promoting self-service BI and the overall data platform.
Support the BI production environment for a large user base.
Provide on-call support for Production issues.
Provide leadership and vision for best usage and practices with regards to Cognos toolset.
Set standards and guidelines for BI development.
Mentor other team members for knowledge transfer.