Bi Data Analyst

Min 5 years work experience in this type of roleWill have to pass internal assessments and testsReferences of prior BI workTechnical Skills:Power BI Power Query concepts (query steps and M syntax, transforming data including pivoting, aggregating, and joins)DAX (knows basic functions offhand, understands concept of measures and behavior of aggregate calculations in context)Data model relationships including implications on visual filtering behavior and RLSNice to have: MS Fabric features (e.g., Data warehouses, lake houses, data pipelines)Nice to have: AI builder experienceNice to have: RPA and/or software testing automation experience SQLKnowledge of basic SQL language and concepts including: SELECTs, JOINs, GROUP BYs, ViewsNice to have: Stored procedures, basic database managementResponsibilities:Design, publish and maintain Power BI data models with over 45 interrelated tables connected Implementing a data model that works seamlessly in Direct Query or Import modeMerging/Joining Queries (M Language) in order to filter useful data to make visuals on a high granular levelEstablishing dynamic table relations with desired Cross filtering directions.Implementing measures in DAX that filter out values from different tables to display calculationsVisuals with Level Filters that maintain data consistency across interactive/dynamic pagesSetup automated data refresh of dashboards to show the updated values from source dataSlicer Selections and Syncing across report pagesTranslate business needs to technical specificationsCreation of external facing live dashboardsEvaluate and improve existing BI systemsCollaborate with teams to integrate dashboards Performs other duties as required
#J-18808-Ljbffr