Business Intelligence Engineer

Mandatory Skills:

ROLE

Skill

Required Proficiency - On a scale of 1-5

(5 being the highest)

BI Engineer

MicroStrategy / Tableau

4

Dimensional Data modelling, Logical & Physical Data modelling

3

Data Vault 2.0 model for Snowflake

4

Data visualizations / interactive dashboards

4

Qlikview, Qlik Sense, Tableau, Power BI

3

Data & Analytics

4

Data integration tools such as Talend

3

Snowflake Cloud Data Platform

4

Detailed JD (Pl share the Detailed Description, 1 liner JD will not work)

The primary role for the Business Intelligence Engineer is to work on integrating data from a variety of source systems and presenting it through an array of self-service applications. The BI Engineer will support all development efforts including data analysis, data modelling and data design tasks as well as the creation of metrics and attributes to be consumed by interactive dashboards and data visualizations tools like MicroStrategy and Tableau that are widely used throughout the organization. Additionally, the BI Engineer will be instrumental in the creation of optimal reporting structures at the database for ongoing reporting and analytics. Will be partnering with the business stakeholders, Product Owners, Product Managers and data engineers for translating business requirements into data requirements and structures for schema creation.

Responsibilities

Develop data modelling and data transformation for business intelligence tools like MicroStrategy and Tableau using Cloudera Impala, Hive, Spark etc
Perform data analysis, data modelling and data design tasks on complicated datasets with potentially complex data integration scenarios for Hadoop and Snowflake.
Build data structures and data blending technologies to support data harmonization and provide data to MicroStrategy and Tableau
Develop data structures using Hadoop and Snowflake to build dashboards, reports and self-service templates to enable visualization through BI tools like MicroStrategy, Tableau etc.
Create Schema objects to produce reports, Templates and metadata for MicroStrategy.
Convert business requirements into Data Warehouse design for Business Intelligence tools; Provide technical requirements to data engineering for conversion of business requirements to events to database schema's. Build database objects based on schema provided by data engineers to be consumed by reporting tools like Tableau and MicroStrategy

Must Have

Bachelor's degree in Computer Science/Engineering preferred
5+ years' experience in designing and implementing the data structures (conceptual, logical, physical & dimensional models) for reporting tools like MicroStrategy, Tableau or any reporting tools
Developing Enterprise Business Intelligence solutions on one or more of the following EDW platforms: Snowflake, Cloudera Impala, Hive, and BW on HANA
2+ years' experience with Snowflake, SQL and Big Data solutions
Strong knowledge of key scripting and programming languages such as Python, Java. Experience with data integration tools such as Talend
Proven track record working with complex, interrelated systems and bringing that data together on Big Data platforms.
Expertise / In-Depth Database Knowledge SQL and NoSQL.

Good to Have

Be knowledgeable in visualization tools data structure requirements to enable the requirements in HANA
Work collaboratively with cross-functional teams
Be able to proactively prioritize tasks in consultation with business stakeholders, Product Owners, Product Managers
Establish and maintain a working environment conducive to positive morale, individual style, quality, creativity, and teamwork
Ability to work in a fast-paced, team environment