Roles and Responsibilities
ï'· Manage BI solutions (Cubes, portals, dashboards, standard and ad-hoc reporting) with a
specific focus on data management, and data warehouse architecture.
ï'· Provide technical direction and mentoring to a team of developers who develop and build
solutions using our Enterprise Data tools (SQL Server, SSIS, SSAS, Power BI, and Power View &
ï'· Ensuring team members are following best practices within the SDLC structure while
overseeing, planning, and estimating project needs.
ï'· Maintains resource forecast and resolves resource conflict and risk.
Required Experience :
ï'· Deep analytical experience and understanding of typical information technology processes
ï'· Experience with requirements gathering and documentation processes
ï'· Provides oversight and mentoring to the BI Development team.
ï'· Experience with software testing, report development and database management
ï'· Experience with designing packages in SSIS.
ï'· Experience in Dimensional Modelling
ï'· Designing & developing dimensions, hierarchies, measures & cubes.
ï'· Develop calculated measures using DAX.
ï'· Experience in Performance optimization of Tabular Cubes
ï'· Creation of Excel based reports and PBI on top of SSAS Cube. Create reports and data extracts
against complex data sets using SQL
ï'· Deep understanding of relational database design, multidimensional database design,
OLTP, OLAP, KPIs, Scorecards, and Dashboards
ï'· Solid understanding of relational databases, including data analysis and reporting
ï'· Experience in Power shell is a plus