SSIS,SSAS,POWERBI,SQL

MSBI Technical Consultant

Job Requirements

Core Technical Skills

1. SQL Server Integration Services

o Hands-on experience with SSIS (Creating packages, Data transformations, Deployment)

o Strong understanding of ETL (Incremental and Full load)

o Experience in using parameters and variables inside package.

o Proficient in following best practices

2. SQL

o Ability to translate business requirements into SQL Queries

o Create stored procedures and views

o Work experience in indexing, code optimization and usage of execution plan in ssms

o Aware of all the best practices for coding

3. Sql Server Analysis Services -Tabular

o Experience in creating data models by identifying facts and dimensions

o Identify and use correct relationships / Joinkeys

o Ability to write DAX Queries and create calculated measures and fields

4. Power BI

o Experience in creating BI models and dashboards based on data stored in sql

o Understanding and usage of various connection modes

o Create measures and visuals which provide meaningful insights to Business.

Total Experience

4+ years

Relevant Experience

4+ years

Mandatory skills

SSIS,SSAS,POWERBI,SQL

Desired skills

SSIS,SSAS,POWERBI,SQL

Additional Technical Skills

• Snowflake experience will be beneficial as upcoming deliverables will require some exposure on snowflake

Preferred Certifications (Optional)

Microsoft Certified : Data Analyst Associate