Technical Lead / Associate Architect - Power BI

Role & responsibilities "

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

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

c) Should be able to guide Leads and developers

d) Should be a team player

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

f) Should be self motivated and passionate to become technology expert

Primary Skills (Must have experience):

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.)

a) Power BI (Pro, Premium, Paginated). Dataflows, Incremental data refresh, row level security, DAX, Power Query, M language

b) SQL Server and Azure SQL Database

c) Designing and Implementing Power BI Data Models

d) Designing and building complex Reports, Dashboards, Scorecards in Power BI

e) Knowledge of Azure Stream Analytics and Realtime Dashboards

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

g) Programming and optimizing DB objects Views, Stored Procs, Functions

h)Azure Data Lake or Blob storage

i) ADF

g) PL 300 Certified preferable

Secondary Skills (Good to have):

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

a) Azure SQL DW/Synapse

b) Azure Databricks

c) Azure Data Lake or Blob storage

Other skills preferable:

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

b) Tableau (preferable)

c) Experience working with high volume data, large objects