Lead I Software Engineering in UST

Job Description

Thiruvananthapuram, Kerala

2 days ago Full–time 

Job description
Role Description

Role Proficiency:

Provide expertise on data analysis techniques using software tools. Under supervision streamline business processes.

Outcomes
• Design and manage the reporting environment; which include data sources security and metadata.
• Provide technical expertise on data storage structures data mining and data cleansing.
• Support the data warehouse in identifying and revising reporting requirements.
• Support initiatives for data integrity and normalization.
• Assess tests and implement new or upgraded software. Assist with strategic decisions on new systems. Generate reports from single or multiple systems.
• Troubleshoot the reporting database environment and associated reports.
• Identify and recommend new ways to streamline business processes
• Illustrate data graphically and translate complex findings into written text.
• Locate results to help clients make better decisions. Solicit feedback from clients and build solutions based on feedback.
• Train end users on new reports and dashboards.
• Set FAST goals and provide feedback on FAST goals of repartees

Measures Of Outcomes
• Quality – number of review comments on codes written
• Data consistency and data quality.
• Number of medium to large custom application data models designed and implemented
• Illustrates data graphically; translates complex findings into written text.
• Number of results located to help clients make informed decisions.
• Number of business processes changed due to vital analysis.
• Number of Business Intelligent Dashboards developed
• Number of productivity standards defined for project
• Number of mandatory trainings completed

Outputs Expected

Determine Specific Data needs:
• Work with departmental managers to outline the specific data needs for each business method analysis project

Critical Business Insights
• Mines the business’s database in search of critical business insights; communicates findings to relevant departments.

Code
• Creates efficient and reusable SQL code meant for the improvement manipulation and analysis of data.
• Creates efficient and reusable code. Follows coding best practices.

Create/Validate Data Models
• Builds statistical models; diagnoses validates and improves the performance of these models over time.

Predictive Analytics
• Seeks to determine likely outcomes by detecting tendencies in descriptive and diagnostic analysis

Prescriptive Analytics
• Attempts to identify what business action to take

Code Versioning
• Organize and manage the changes and revisions to code. Use a version control tool for example git bitbucket. etc.

Create Reports
• Create reports depicting the trends and behaviours from analyzed data

Document
• Create documentation for worked performed. Additionally perform peer reviews of documentation of others’ work

Manage Knowledge
• Consume and contribute to project related documents share point libraries and client universities

Status Reporting
• Report status of tasks assigned
• Comply with project related reporting standards and processes

Skill 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 review numbers trends and data to come up with original conclusions based on the findings.
• Presentation Skills – facilitates reports and oral presentations to senior colleagues
• Strong meeting facilitation skills as well as presentation skills.
• Attention to Detail: Vigilant in the analysis to determine accurate conclusions.
• Mathematical Skills to estimate numerical data.
• Work in a team environment
• Proactively ask for and offer help

Knowledge Examples

Knowledge 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.
• Proficient in mathematics and calculations.
• Efficiently with spreadsheet tools such as Microsoft Excel or Google Sheets
• DBMS
• Operating Systems and software platforms
• Knowledge regarding customer domain and sub domain where problem is solved

Additional Comments

Job Description –
• Use independent judgment to analyze, design, develop and/or maintain databases and its integration with systems
• Performs database enhancements and improvements
• Direct application development teams in working with databases, planning and implementing production changes and query optimization
• Perform quality control audits to ensure accuracy completeness and proper usage of data in tables and support tools, such as database dictionaries
• Monitor transaction activity and utilization, with particular strengths in performance tuning highly transactional databases in both the development and production environments including remotely located servers
• Ensure data replication is scheduled and optimized
• Perform Root cause analysis and resolution for all the database and application issues
• Participate in scheduled and unscheduled system maintenance
• Change Management, on-call and off-hour systems support
• Participate in application recovery and disaster recovery practices
• Maintain security standards with other database administrators and technical resources
• Supervise and mentor Associate Database Administrators, Database Administrators, Database Engineers as per project needs
• Perform other duties as assigned or requested
• Must be able to relocate as needed by the company.
• To support and promote the values of UST
• Comply with all Company policies and procedures.
• The Company reserves the right to periodically redefine your roles and responsibilities based on the requirements of the organization and/or your performance. 10+ years of experience

Skills

Dba,Oracle,Ms Sql,Mysql

Thiruvananthapuram, Kerala