Power BI Architect

Role : Power BI Architect

Job Description :

- Should be able to work independently with little guidance from the lead architect

- Should be able to understand requirements, proactively clarify any doubts/assumptions with the team members and also proficient in client interactions

- Should be able to guide Leads and developers

- Should be a team player

- Should be flexible with working hours (sometimes during deployments, customer calls)

- Should be self-motivated and passionate to become technology expert

Primary Skills :

- Excellent verbal and written communication.

- Should be able to speak confidently throughout the conversation

- Experience working with customer Business/IT team

- Expertise with minimum 3+ projects (5+ Yrs exp.)

- Power BI (Pro, Premium, Paginated).

- Dataflows, Incremental data refresh, row level security, DAX, Power Query, M language

- SQL Server and Azure SQL Database

- Designing and Implementing Power BI Data Models

- Designing and building complex Reports, Dashboards, Scorecards in Power BI

- Knowledge of Azure Stream Analytics and Realtime Dashboards

- Designing DB schema, data models on RDBMS and DW by leveraging the Medallion Architecture

- Programming and optimizing DB objects Views, Stored Procs, Functions

- Azure Data Lake or Blob storage

- ADF

- PL 300 Certified preferable

Good to have :

- Experience with minimum 2+ projects (3+ Yrs. exp.)

- Azure SQL DW/Synapse

- Azure Databricks

- Azure Data Lake or Blob storage

Other skills preferable :

- MS Fabric (atleast the Power BI and One Lake/Lakehouse components is preferable)

- Tableau (preferable)

- Experience working with high volume data, large objects