What are the responsibilities and job description for the BI Engineer - Looker Amazon Quicksight and Power BI position at Trisian-Global Consulting LLC?
Position : BI Engineer Looker Amazon Quicksight and Power BI
TrisianGlobal Consulting LLC is seeking a highly skilled and experienced Business Intelligence Engineer with hands on technical experience using Looker Amazon Quicksight and Power BI. In this role you will be responsible for implementing and managing BI platforms for business intelligence data applications and embedded analytics. This is a contract for hire
Requirements :
- Work closely with internal IT Server and Security teams to troubleshoot including reviewing logs and resolving issues with production / nonproduction environments.
- Work independently and provide solutions to users.
- Manage Power BI Gateways to keep the dashboards and reports refreshed automatically.
- Build CI / CD pipeline to check in and migrate Power BI datasets / 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 selfservice BI users and support the business in promoting selfservice BI and the overall data platform through communications collateral and training material.
- Support BI production environment for large scale user base.
- Available oncall support for production issues.
- Provide leadership and vision for best usage and practices with regards to Cognos toolset.
- Setting standards and guidelines for BI development.
- Mentor other team members for knowledge transfer.
Qualifications :
Extensive experience with Python programming Shell Scripting and PowerShell Scripting.
Account manager information :
Name : Nate Bagby
Email : Phone : ext 230
Must have :
Strong Looker Admin Experience
AWS Knowledge (EC2 S3 Lambda Redshift)
Experience with CI / CD Processes (for automating testing and deployment)
Experience with SDLC (Software Development Life Cycle)
Experience with ITSM (IT Service Management) and Change Management
Proficiency in Scripting (Python Shell PowerShell)
Automation and Infrastructure Management Skills
Understanding of Network Firewalls and Proxies (in cloud environments)
Additional Information (Screening Questions you can use while evaluating / vetting candidates)
Segregation of duties : 80% admin and 20% dev. Mostly has admin skills with some dev. skills
How do they deploy content between environments : Control production environment. Developers cant publish direct in their setup. Process runs vie tickets. Use ServiceNow tickets. Manual deployment not common in their setup. Not do a lot of bulk deployment. If it needs to be done they use APIs
How do they connect Power BI APIs : Depends on type of API. Agileconnect Power BI to ADI environment. Touch in. AD active directorynavigateadd registrationset up. Initiate packets. Oacth / rest use client ID. tenet ID
Purpose of Power BI gateways : Serves important role. Enable secure data connectivity. Enable data source connectivity. Facilitates connection with DBs
How do they connect to cloud databasesdepends where is the datasource. If DataSource is on premconnect to desktop launch. Connect to DB. Enable on perm to cloud.
Top 5 issues that they encountered during their journey :
Performance issuesdashboards are not built with best practices. Work with inefficient queries. E.g. in a current project there are lot of complex tax queries and inefficient tax data.
Large amount of data can also cause performance issues.
Insufficient live connection to DataSource. Transactional data changes all the time. For exampleSales dataif there is no live feed. Inefficient indexing can lead to issues.
Data refresh failure
Power gateway issues
Permissionsmisconfigured roles security
Key Skills
Accounts Receivable,Brand Management,Apache Web Server,High School,HSSE
Employment Type : Full Time
Vacancy : 1
