Job Description :

Development of data models for Data Marts and Data Warehouses

Perform OLAP cube development

Ability to perform assigned tasks utilizing knowledge of SQL Server, SSRS, SSIS

Relational and Dimensional Modeling

Ability to apply good analysis and design skills, critical thinking, and analytical problem solving abilities.

Working from business requirements to perform ETL, Reporting, and Analytics functions

Build Data Visualizations including dashboards and reports

Quality Assurance for BI development

Document data profiling results, data dictionaries, business glossaries, and data analysis findings

Ability to provide excellent customer service throughout the client engagement process  

Qualifications Needed:

Strong SQL development skills

Experience with MS SQL, TSQL  Server suite, including SSIS, SSRS, SSAS

Experience with MS Excel including PowerPivot

Familiarity with other visualization and reporting tools (examples include Power BI, Tableau, Qlikview)

Exposure to cloud based solutions such as Azure, AWS beneficial.

Understanding of data analysis and statistical principles

Strong verbal and written communication skills including presentations, documentation, and facilitating meetings