SSAS Developer

Description

Job Description The BI Report Developer will be responsible for BI development using the Microsoft SQL Server platform and tool stack. This will include reporting tasks and other related administrative and development tasks. In addition to strong technical and project management skills, this position will also be business facing and require excellent customer relationship management. Responsibilities Develop complex, effective and standardized SSRS driven reports, dashboards and analytics Create Power BI dashboards/Excel templates to satisfy user reporting requirements
Write complex DAX/MDX/TSQL code against Reporting Cubes/data marts
Assist in design and testing of SSAS Tabular and Multidimensional Cube structures
Review, recommend and implement changes to existing DAX/MDX/TSQL code and stored procedures for performance improvements
Gather and document reporting requirements from customer meetings regarding report development and ad hoc requests. ResultsDriven with ability to take initiatives and meet deadlines in a fastpaced changing environment. Assist various stakeholders by providing them with data as requested. Requirements Experience with 2012+ Microsoft BI stack and team development tools 3+ years core expertise in data analysis, query design and reporting with SQL Server Database, Analysis Services and Reporting Services
Experience with SQL Server Analysis development using DAX/MDX
Strong SQL skills including creation of userdefined functions, complex stored procedures, Query optimization and SQL scripts for use in analysis and reporting. Experience building Reports, Scorecards and Dashboards Experience with Power BI, Excel, or other data visualization tools Ability to work both independently and collaboratively with others in team environment Demonstrated advanced analytical, troubleshooting and problem solving skills Nice to have Design complex SSAS tabular and multidimensional models
Troubleshoot and tune DAX/MDX code using Profiler and other tools