Program Analyst - Power Bi

Role Overview: You will work as a Program Analyst/Project Controller in the Program Management Department. Your role will involve tasks related to Power BI desktop, such as ETL (Extract Transform and Load), managing relationships, creating visuals, establishing logic and primary keys for table relationships, and setting up meetings to understand the requirements of internal and external stakeholders. You will be responsible for performing tasks independently using advanced Power Query steps, DAX formulas, and Measures. Additionally, your creativity in producing visuals and presenting data in a presentable format will be crucial. Effective verbal and written communication, proactiveness, and ownership attitude are required for this role. You will be expected to deliver quality and timely deliverables, keep track of various dashboards and targets, execute agile tasks, and work on advanced Excel and Power BI for project analysis. Furthermore, connecting various data sources to Power BI and translating data into meaningful statistics and information will be part of your responsibilities. You should also be capable of implementing row-level security on data and have an understanding of application security layer models in Power BI. Creating and updating Power BI procedures specific to projects, deploying dashboards, and maintaining Power BI services for various clients within the workspace will also be within your scope of work. Key Responsibilities: - Work as a Program Analyst/Project Controller in the Program Management Department - Perform tasks on Power BI desktop, including ETL, managing relationships, and creating visuals - Establish logic and primary keys for table relationships in Power BI - Set up meetings and understand the requirements of internal and external stakeholders - Perform tasks independently using advanced Power Query steps, DAX formulas, and Measures - Be creative in producing visuals and presenting data in a presentable format - Deliver quality and timely deliverables - Keep track of various dashboards and targets - Execute agile tasks under typical program/portfolio - Work on advanced Excel and Power BI for project analysis - Connect various data sources to Power BI - Translate data into meaningful statistics and information - Implement row-level security on data and understand application security layer models in Power BI - Create and update Power BI procedures specific to projects - Deploy dashboards and maintain Power BI services for various clients within the workspace Qualifications: - Any Graduate or Diploma - Experience in advanced Power BI - Power BI Certification preferred - Working knowledge of Advanced Excel preferred - Interest in learning and developing project controls capabilities - Excellent written and verbal communication skills - Basic understanding of Project Management Knowledge areas and Planning Terminologies - Willingness to work permanently in the 2nd shift (12:30 pm to 9:00 PM) to coordinate with the US Office,