- Duties/ Roles & Responsibilities for- Power BI Architect
- Designing, developing, and maintaining business intelligence solutions using Power BI
- Power BI development and administration
- Building Analysis Services reporting models
- Developing visual reports, dashboards, and KPI scorecards using Power BI desktop
- Create the data model and establish relationships
- Create the DAX based calculations and resolve issues
- Resolve any issues related to loops and hierarchy
- Create n review model and KPI
- Create and review visualization
- Establish data level security and object level security
- Establish model used for self-service BI
- Capacity estimation and planning
- User management and administration
- Aware of Azure cloud services
- Experience in Tabular model using Azure Analysis services
- 5+ years of strong architecting solution experience using BI tools like Power BI and hands-on software development experience in Power BI, etc.
- Should be able to collaborate with teams to integrate systems
- Ability to look at various data load options and suggest an optimal way of proceeding
- Integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS), or by API automation
- Develop custom visuals for Power BI
- Experience with cloud-hosted Power BI using Microsoft Azure is required
- Strong understanding across cloud and infrastructure components
- Can understand and articulate the technical merits and value of cloud-computing
- Experience in Databases, especially Redshift databases
- Strong communication, interpersonal and problem-solving skill
Duties/ Roles & Responsibilities for- Sr. Power BI / Jr. Power BI
- 2-5 years of experience as a Business Intelligence Reporting Developer
- Should have worked on Power BI contents like workspaces, reports, datasets, and data flows
- Strong Technical skills in Power BI Desktop and Power BI service, especially expertise in DAX functions and Power BI modelling
- Should be able to implement data refresh using Data Management Gateway
- Should be able to define and implement dashboard security
- Strong knowledge of the following:
- Power BI PowerShell script development
- Power BI Rest API knowledge
- Azure Active Directory concepts
- Power BI Administrator Role
- Excellent knowledge in writing Queries, Stored Procedures, Functions in T-SQL
- Should be able to create technical specifications from the functional requirements
- Should be able to design Automation Script and customization
- Configure target workspace with Management Gateway, refresh schedule etc