Business Intelligence Engineer

Experience Level : 5+ Years

Required Skills :

• DOMO (Pipeline / ETL, Admin)
• SQL
• Jira
• Data wrangling & Data Quality

Responsibilities :

Creating input dataset from MongoDB, Flat files, AWS S3, Athena and Redshift connector

Creating the dataflow using Magic ETL (different type of tiles like SQL, Add Formula, Rank & Window, Pivot etc.,), SQL Transformation, Blend

Based on the required data from user assign the Personalized Data Permission (Row Level Security)

Data Governance, Metadata and User Management

Creating the views dataset with Joining, Union

Sandbox (Dev, QA and Prod instance)

Content Migration / Promotion

Optimization / Performance Tuning

SQL Queries

Creating the Apps, Dashboards and Applying the page filter, global date filter, formatting

Creating the cards using the different of charts / tables like bar, pie, line, gauge, table, pivot etc.,

Applying the Drill Up / Down / Thru on cards

Creating the Calculated Fields (Beast Mode) Like WTD, MTD, QTD and YTD, etc., formatting, color rules.

Creating the Variable, Control Filter

Capable for handle the KPIs.

Better to have AWS Cloud (DMS, S3, Glue, Athena and Redshift) or Any Cloud experiences.

Preferred Skills :

MongoDB

Redshift

AWS Glue & Athena

Confluence