Job Description :
Required:
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