Role Proficiency:Independently provides expertise on data analysis techniques using software tools; streamlining business processes and managing teamOutcomes:- Managing and designing the reporting environment including data sources security and metadata.- Providing technical expertise on data storage structures data mining and data cleansing.- Supporting the data warehouse in identifying and revising reporting requirements.- Supporting initiatives for data integrity and normalization.- Assessing tests and implementing new or upgraded software and assisting with strategic decisions on new systems.- Synthesize both quantitative and qualitative data into insights- Generating reports from single or multiple systems.- Troubleshooting the reporting database environment and reports.- Understanding business requirements and translating it into executable steps for the team members.- Identify and recommend new ways to streamline business processes- Illustrates data graphically and translates complex findings into written text.- Locating results to help the clients make better decisions. Get feedback from clients and offer to build solutions based on the feedback.- Review the team's deliverables before sending final reports to stakeholders.- Support cross-functional teams with data reports and insights on data.- Training end users on new reports and dashboards.- Set FAST goals and provide feedback on FAST goals of reporteesMeasures of Outcomes:- Quality - number of review comments on codes written- Accountable for data consistency and data quality.- Illustrates data graphically and translates complex findings into written text.- Number of results located to help clients make informed decisions.- Attention to detail and level of accuracy.- Number of business processes changed due to vital analysis.- Number of Business Intelligent Dashboards developed- Number of productivity standards defined for project- Manage team members and review the tasks submitted by team members- Number of mandatory trainings completedOutputs Expected:Determine Specific Data needs:- Work with departmental managers to outline the specific data needs for each business method analysis projectManagement and Strategy:- Oversees the activities of analyst personnel and ensures the efficient execution of their duties.Critical business insights:- Mines the business's database in search of critical business insights and communicates findings to the relevant departments.Code:- Creates efficient and reusable SQL code meant for the improvementmanipulationand analysis of data.- Creates efficient and reusable code. Follows coding best practices.Create/Validate Data Models:- Builds statistical models; diagnosesvalidatesand improves the performance of these models over time.Predictive analytics:- Seeks to determine likely outcomes by detecting tendencies in descriptive and diagnostic analysisPrescriptive analytics:- Attempts to identify what business action to takeCode Versioning:- Organize and manage the changes and revisions to code. Use a version control tool like gitbitbucket. etc.Create Reports:- Create reports depicting the trends and behaviours from the analysed dataDocument:- Create documentation for own work as well as perform peer review of documentation of others' workManage knowledge:- Consume and contribute to project related documentsshare pointlibraries and client universitiesStatus Reporting:- Report status of tasks assigned- Comply to project related reporting standards/processSkill Examples:- Analytical Skills: Ability to work with large amounts of data: facts figures and number crunching.- Communication Skills: Communicate effectively with a diverse population at various organization levels with the right level of detail.- Critical Thinking: Data analysts must look at the numbers trends and data and come to new conclusions based on the findings.- Presentation Skills - reports and oral presentations to client- Strong meeting facilitation skills as well as presentation skills.- Attention to Detail: Making sure to be vigilant in the analysis to come to correct conclusions.- Mathematical Skills to estimate numerical data.- Work in a team environment- Proactively ask for and offer helpKnowledge Examples:- Database languages such as SQL- Programming language such as R or Python- Analytical tools and languages such as SAS & Mahout.- Proficiency in MATLAB.- Data visualization software such as Tableau or Qlik or Power BI.- Proficient in mathematics and calculations.- Spreadsheet tools such as Microsoft Excel or Google Sheets- DBMS- Operating Systems and software platforms- Knowledge about customer domain and also sub domain where problem is solvedAdditional Comments:- Hands on administration of Database Administration - Kknowledge in RDBMS concepts / Administration / Migration on cloud and non cloud vice versa. - Expertise the d