Job description

• Sr. Power BI Architect • Location: NYC/NJ or Princeton 3 days a week • JD: Attached, Data Engineering is plus, • 10plus exp. • Expert knowledge of architecting and developing Power BI solutions • Design and develop business intelligence dashboards, analytical reports and data visualizations • Long Term contract Business Intelligence: Power BI, Azure Data Factory (ADF), Azure Databricks, Azure Analysis Services(SSAS), Azure Data Lake Analytics, Azure Data Lake Store (ADLS), Power Apps, Azure Integration Runtime, DAX, XMLA, Power Query(M Language), Azure Event Hubs, Azure Stream Analytics, DBT Database Technologies: Azure SQL, MongoDB Experience Required: Power BI Reporting • Design and develop business intelligence dashboards, analytical reports and data visualizations using power BI and providing access to different user groups • Expert knowledge of architecting and developing Power BI solutions by configuring the data security and assigning the licenses and sharing the reports and dashboards to the difference user groups in the organization. Expert in writing Parameterized Queries for generating Tabular reports, Sub reports using Global variables, Expressions, and Functions, Sorting the data, Dashboard, Scorecards, Drill - down and Drill-through reports, Defining Data sources and Subtotals for the reports using SSRS • Design and develop business intelligence dashboards, analytical reports and data visualizations using power BI by creating multiple measures using DAX expressions for user groups • Use of Power BI Power Pivot to develop data analysis prototype, use Power View and Power Map to visualize reports. • Developed interactive reports and dashboards in Power BI to provide actionable insights and facilitate informed decision-making use of Dynamics 365. • Develop MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports. • Experience in Databricks lakehouse and DBT for processing data and building models.

Requirements