Job Description

5 - 7 Years
1 Opening
Kochi, Trivandrum


###

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:



o Over 6+ years of experience in developing BI applications utilizing SQL server/ SF/ GCP/ PostgreSQL, BI stack, Power BI, and Tableau. o Practical understanding of the Data modelling (Dimensional & Relational) concepts like Star-Schema Modelling, Snowflake Schema Modelling, Fact and Dimension tables. o Ability to translate the business requirements into workable functional and non-functional requirements. o Capable of taking ownership and communicating with C Suite executives & Stakeholders. o Extensive database programming experience in writing T-SQL, User Defined Functions, Triggers, Views, Temporary Tables Constraints, and Indexes using various DDL and DML commands. o Experienced in creating SSAS based OLAP Cubes and writing complex DAX. o Ability to work with external tools like Tabular Editor and DAX Studio. o Understand complex and customize Stored Procedures and Queries for implementing business logic and process in backend, for data extraction. o Hands on experience in Incremental refresh, RLS, Parameterization, Dataflows and Gateways. o Experience in Design, development of Business Intelligence Solutions using SSRS and Power BI o Experience in optimization of PBI reports implementing Mixed and Direct Query modes.


###

Skills

Power Bi,Power Tools,Data Analysis,Fabric



###

About UST

UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world's best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future-proof philosophy, UST embeds innovation and agility into their clients' organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact--touching billions of lives in the process.