US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 1st Sep 2023
Coordinate technical design sessions with the Business Analysts and BI Developer
· Assess the data needs of an organization and create a flexible enterprise model that produces quick results for large groups of reports and dashboards for various departments
· Utilize your experience designing tabular models by writing complex DAX scripts to support Power BI KPIs
· Review the visualization use cases and determine whether the use of In-Memory models or Direct Query is needed
· Performance tune the tabular model to work with large data sets and/or complicated DAX formulas
· Build enterprise reporting capability using Analysis Services on-prem or in Azure
· Design the tabular model for consumption by non-technical business users in compliance with existing naming standards and metric calculations
· Optimize tabular models so they can be properly rendered in other BI Tools
Replace existing BI solutions (e.g. MSTR, Tableau, Cognos, QLIK) with new tabular models using DAX
· Create tabular models based on Data Warehouses and Data Lakes
· Understand and implement complex user authentication and data access security models in Analysis Services
· Analyze data and identify any data quality issues that can affect the model and reporting
· Support and train other team members on tabular model methodology and the use of DAX
· Participate in code reviews with Clients
Who you are:
3-5+ years of experience as Power BI Architect with expertise in the following areas:
· Strong SQL and DAX skills
· Expertise designing semantic data models that express the business context
· Ability to architect and design a tabular model solution
· Experience with Microsoft Power BI
· Experience with Azure Data Service and products (ex. Data Factory, Data Lake, Data Lake Analytics) is a plus
· Ability to integrate row-based security into tabular models
· Proven capacity of troubleshooting is