Hybrid
Full-Time
Bengaluru, Karnataka
India
Skills
Amazon Web Services (AWS)
Data Warehousing
Extract, Transform, Load (ETL)
Business Intelligence (BI)
DAX
Dashboards
Data Analytics
Pyth (Programming Language)
SQL Server Integration Services (SSIS)
SQL Server Reporting Services (SSRS)
QlikView
SQL Server Analysis Services (SSAS)
Microsoft Power BI
About the Role
Role: Senior/Associate Architect - Power BI
Experience Level: 3 to 8 Years
Work location: Mumbai/Bangalore
Role & Responsibilities:
Designing, developing and maintaining business intelligence solutions to enable the client make data-driven business decisions
Work with business users and other stakeholders to understand business processes and requirements
Design, build and deploy BI solutions using PowerBI
Presenting information through reports and visualization
Provide research, high-level design and estimates for data transformation and data integration from source applications to end-user BI solutions
Collaborate with teams to integrate systems
Develop and execute database queries and conduct analyses
Create visualizations and reports for requested projects
SSRS Integration to Power BI
Data Gateway for data refreshing, content pack library
Publishing reports to app.powerbi.com and setting up the necessary connection details and scheduling
Connecting Microsoft Power BI Desktop to various data sources
Creating Custom Visuals and Groups Creation and managing Embed Codes
Identify opportunities to improve processes and strategies with technology solutions
Identify development needs in order to improve and streamline operations through automation
Skills:
5+ years of experience in Data Visualization/Business Intelligence
Proficient in using Power BI
Exposure to Qlikview is a plus.
Exposure to the insurance industry is desirable
In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework, data-warehousing
Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) is a must
Knowledge of AWS data lake is a plus.
Highly proficient in working with large volumes of business data and strong understanding of database design and implementation.
Good experience in performance tuning of BI reports and dashboards. Solid experience in complex SQL logic.
Should have strong concepts on building Security around the entire Datawarehouse
Implementation of Row Level Security by defining various constraints for each role.
Expert knowledge using advanced calculations using MS Power BI Desktop (Aggregate, Date, Logical, String, Table)
Good at creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc
Sound knowledge of DAX data types, DAX query, parameters for standard time intelligence functions and implementing hierarchies, Bookmarks, drill-down, drill through features, dynamic filtering, parameter naming, creating calculated measures and columns
Knowledge of Power Query M code is a plus
Team leading experience is a plus
Exceptional interpersonal and communication (verbal and written) skills
Experience Level: 3 to 8 Years
Work location: Mumbai/Bangalore
Role & Responsibilities:
Designing, developing and maintaining business intelligence solutions to enable the client make data-driven business decisions
Work with business users and other stakeholders to understand business processes and requirements
Design, build and deploy BI solutions using PowerBI
Presenting information through reports and visualization
Provide research, high-level design and estimates for data transformation and data integration from source applications to end-user BI solutions
Collaborate with teams to integrate systems
Develop and execute database queries and conduct analyses
Create visualizations and reports for requested projects
SSRS Integration to Power BI
Data Gateway for data refreshing, content pack library
Publishing reports to app.powerbi.com and setting up the necessary connection details and scheduling
Connecting Microsoft Power BI Desktop to various data sources
Creating Custom Visuals and Groups Creation and managing Embed Codes
Identify opportunities to improve processes and strategies with technology solutions
Identify development needs in order to improve and streamline operations through automation
Skills:
5+ years of experience in Data Visualization/Business Intelligence
Proficient in using Power BI
Exposure to Qlikview is a plus.
Exposure to the insurance industry is desirable
In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework, data-warehousing
Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) is a must
Knowledge of AWS data lake is a plus.
Highly proficient in working with large volumes of business data and strong understanding of database design and implementation.
Good experience in performance tuning of BI reports and dashboards. Solid experience in complex SQL logic.
Should have strong concepts on building Security around the entire Datawarehouse
Implementation of Row Level Security by defining various constraints for each role.
Expert knowledge using advanced calculations using MS Power BI Desktop (Aggregate, Date, Logical, String, Table)
Good at creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc
Sound knowledge of DAX data types, DAX query, parameters for standard time intelligence functions and implementing hierarchies, Bookmarks, drill-down, drill through features, dynamic filtering, parameter naming, creating calculated measures and columns
Knowledge of Power Query M code is a plus
Team leading experience is a plus
Exceptional interpersonal and communication (verbal and written) skills