Understand the business requirements/ questions to be answered
Work with the offshore team to ensure the quality of deliverables
Align on KPIs and data sources to be used
Design and align on mock-ups
Define visuals and key KPI’s that enables speed to insight
Work with IT team closely to perform data extraction and data transformation processes to create the data set required for the dashboard
Develop the mock-up design in Power BI and load the dashboard with real data
Implement feedback from business users and create final version of the dashboard
Scale, maintain and improve existing solutions
Refresh the prototype with live data
Perform data transformations (if required) to make data in format which can be easily scaled across different geographies/ categories
Implement feedback from business users and further enhance the dashboard
Migrating solutions to production environment
Modify the processes (if required) to ensure they are set-up correctly to enable refresh of dashboard at aligned intervals in the production environment
Prepare holistic documentations (process and technical) to enable proper knowledge transfer of both process and solution to the production team
Enable seamless transition via shadow and reverse shadow process
Support and consult the production team if required
Requirements
Bachelor's or master's degree in computer science, Information Systems, Data Science, Supply Chain Management, or a related field
Minimum 6+ years (Senior Engineer) & 3+ Years (Engineer) of experience in Analytics/Visualizations & good project work experience using Power BI, SQL, Excel
Strong experience with Power BI
Experienced in all aspects of Power BI, including establishing gateways, use of embedding, DAX, Paginated Reports
Hands-on experience deploying the PBI service to mid-market and/or enterprise scale organizations
Hands-on experience on basic ETL using MQuery, connections to different data sources, DAX Studio, Tabular Editor, Optimization techniques & different data modelling schema
Hands-on experience of data manipulation in SQL
Good visualization experience using Tableau or any other BI tools
Proficient designing and implementing data models and data integration
Hands-on experience of data pipeline creation & exposure to Azure & Azure services like Datafactory, Databricks, Synapse, etc
Good exposure to Power Platform tools for design & development i.e. Powerapps, Power Automate, Dataverse, Power Virtual Agent, Model Driven Apps, Canvas apps, etc