To create and develop compelling reports and dashboards in power bi using advanced DAX.
Implement SSIS and SSRS using SQL Server data tools (SSDT) and Power BI.
To develop SSIS Packages to Extract, Transform, and Load (ETL) data into the Data warehouse from SQL Server.
& Responsibilities:
Understand business requirements to set functional specifications for reporting applications
Experience writing ETL processes in batch mode and in Real-time.?
Must have strong experience in Financial Services utilizing tools and systems on the MS SQL Server BI Stack, including SSRS SSIS, SSAS, and TSQL, PowerBI, Power Query, MDX, and DAX.
Review current reporting and look to export these reports into PowerBI?
Identifying new analytics trends and opportunities to drive the innovation agenda.?
Connecting to data sources, importing data and transforming data for Business Intelligence.
Ability to quickly stage & shape data from data sources into reporting and analytics solutions?
Responsible for design methodology and project documentation.
Able to develop tabular and multidimensional models that are compatible with warehouse standards.
Able to properly understand the business requirements and develop data models accordingly by taking care of the resources.
Able to integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation. Also, one must be experienced in developing custom visuals for Power BI.
