Data Analyst - Business Intelligence Team

A Data Analyst in Business Intelligence team is responsible for working together with the team to design, implement and support BI solutions including KPIs, Dashboards, Reports and custom analysis in order to provide meaningful information to the business. This role includes supporting BI solutions along with business analysis, data modeling, datawarehouse design, stored procedure & datamarts creation, Report generation,

Performance Point Dashboard creation and integration of these components into BI software as required. This position will also be responsible for the maintenance and documentation of BI system implemented.

Responsibilities include:

- Ensure right stakeholders gets right information at right time

- Requirement gathering with stakeholders to understand their data requirement

- Creating and deploying reports

- Participate actively in datamarts design discussions

- Work on both RDBMS as well as Big Data for designing BI Solutions

- Write code (queries/procedures) in SQL / Hive / Drill that is both functional and elegant, following appropriate design patterns

- Design and plan BI solutions to automate regular reporting

- Debugging, monitoring and troubleshooting BI solutions

- Creating and deploying datamarts

- Writing relational and multidimensional database queries

- Integrate heterogeneous data sources into BI solutions

- Ensure Data Integrity of data flowing from heterogeneous data sources into BI solutions

Minimum Job Qualifications:

- BE/B.Tech in Computer Science/IT from Top Colleges

- 1-5 years of experience in Datawarehousing and SQL

- Excellent Analytical Knowledge

- Excellent technical as well as communication skills

- Attention to even the smallest detail is mandatory

- Knowledge of SQL query writing and performance tuning

- Knowledge of Big Data technologies like Apache Hadoop, Apache Hive, Apache Drill

- Knowledge of fundamentals of Business Intelligence

- In-depth knowledge of RDBMS systems, Datawarehousing and Datamarts

- Smart, motivated and team oriented

Desirable Requirements:

- Sound knowledge of software development in Programming (preferably Java )

- Knowledge of the software development lifecycle (SDLC) and models