Day to Day Operations :
- Develop operational reports
- Build automated reports and dashboards with the help of On Premise Power BI
- Understand business requirements to set functional specifications for reporting applications
- Be experienced in tools and systems on MS SQL Server including SSRS and TSQL, Power Query, MDX, PowerBI, and DAX
- Be able to quickly shape data into reporting and analytics solutions
- Create functional reporting
- Have knowledge of database fundamentals such as multidimensional database design, relational database design, and more
- Should be able to write DAX with complex logic
- Trouble shooting skills
- Design conceptual and logical data models and data Quality & Environment :
- Ensure compliance to all relevant safety, quality and environmental management policies,
procedures and controls across the section in order to guarantee employee safety, legislative
compliance and a responsible environmental Improvement :
Motivate ones own team and identify opportunities to take part in change initiatives,programs and projects that reflect international best practice and changes in the competitive Processes & Procedures :
Recommend improvements to departmental policy and directs the implementation of procedures and controls so that all relevant procedural / legislative requirements are fulfilled while delivering a quality, cost-effective service to & Reports :Prepare MIS statements and reports pertaining to department to meet INJAZATs and thedepartmental requirements, policies and Assignments :
Perform other related duties or assignments as Skills :Expert knowledge in Data Modelling, Data visualization, Data Reporting, Statistical Analysis, Data Warehouse / Data Marts implementation and Data Analysis models.Strong experience with writing SQL in relational databaseStrong analytical and problem-solving skillsExperience with data visualization toolsAgile development methodology experienceAbility to prioritize with good time management skillsUnderstand business requirements in the BI context and design data models to convert raw data to meaningful insightsCreate dashboards and visual interactive reports using On Premise Power BIAnalyze data and present it through reports that can help in decision-makingAble to convert business requirements into technical specifications and decide the timeline to accomplish tasksDesign, develop, and deploy Power BI scripts and perform efficient detailed analysisPerform DAX queries and functions in Power BICreate charts and document data with algorithms, parameters, models, and relations explanationsConduct data warehouse developmentPerform SQL querying for best resultsUse filters and graphs for a better understanding of the dataDefine and design new systems by analyzing current ETL processesMake technical changes to existing BI systems in order to enhance their functioning(ref : hirist.tech)