Responsibilities:
- Understand business requirements in BI context and design data models to transform raw
data into meaningful insights
- Create dashboards and interactive visual reports using Power BI
- Identify key performance indicators (KPIs) with clear objectives and consistently monitor those
- Analysing data and present data through reports that aid decision-making
- Convert business requirements into technical specifications and decide timeline to accomplish
- Create relationships between data and develop tabular and other multidimensional data
models
- Chart creation and data documentation explaining algorithms, parameters, models, and
relations
- Skilled in Analyses Service, building Tabular & Multidimensional models (OLAP, Cubes) on top
of DW/ DM/DB.
- Expert in complex DAX and MDX queries.
- Design and guide BI related IT architecture components in the existing or New BI landscape
to ensure compliance with regulations, policies and standards.
- Providing blueprinting, gathering requirements, designing, and rolling out BI solutions to
users.
- Design conceptual, logical, physical Data model.
- Design, develop, test, and deploy Power BI scripts and perform detailed analytics
- Perform DAX queries and functions in Power BI
- Analyse current ETL process, define and design new systems
- Data warehouse development and work with SSAS, SSIS, and SSRS
- Redefine and make technical/strategic changes to enhance existing Business Intelligence
systems
- Create customize charts and custom calculations as per requirements
- Design, develop and deploy business intelligence solutions as per needs
- SQL querying for best results, use of filters and graphs for better understanding of data
- Work with users and team members at all level for performance improvement and
suggestions