SQL BI Developer

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
• Hands on experience using TSQL
• 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 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.