Analyst, Business Intelligence

Experience: 0 - 2 years
CTC Offered: Not Disclosed
Locations: Bengaluru
Job description Description ACCOUNTABILITIES Analyzes business data, providing assessments of trends, identifying and explaining variances from goals Elicits and documents business requirements to produce meaningful insights and metrics, identifying trends and insights that improve business performance Designs, develops and implements business intelligence dashboards and reports to facilitate data review and analysis Proactively analyzes trends, causes and variances Champion process improvements, best practices and knowledExperience: 0 to 2 Years Mandatory Skills: Informatica 7 or above as an ETL Tool Teradata and SSAS SQL DB as Warehouse Database Very strong in SQL / Macros Should know Basic ~ Medium UNIX Commands Job Description Analyzes business requirements/processes and system integration points to determine appropriate solutions. Designs, codes, tests and documents applications based on system and user requirements. Responsibilities Prepares flow charts and systems diagrams to assist in problem analysis. Responsible for preparing design documentation. Designs, codes, tests and debugs software according to Dell s standards, policies and procedures. Codes, tests and documents programs according to system standards. Prepares test data for unit, string and parallel testing. Analyzes business needs and creates software solutions. Evaluates and recommends software and hardware solutions to meet user needs. Interacts with business users and I/T to define current and future application requirements. Initiates corrective action to stay on project schedules. Knowledge and Skills Competent to analyze diverse and complex Data Solutions from end to end (Design, ETL and Reporting) Possesses and applies broad knowledge of principles of Data Warehousing and BI Reporting Should be capable to design small to medium data marts on SQL Database, fetch data from multiple data sources into a Dimensional Model Should be expert in extracting, transforming and loading data from different data sources using ETL tools such as informatica or SSAS Build Tableau Reports on top of the warehouse Requirements 1-2 years of relevant IT experience in Data-Warehousing Technologies 1-2 years in End to End BI Solutioning is a MUST Design, ETL (Informatica and SSAS) and Reporting (Tableau, Excel etc) Should possess the below skillset experience Informatica 7 or above as an ETL Tool SSAS 3 years or above SQL DB as Warehouse Database Very strong in SQL / Macros Should know Basic ~ Medium UNIX Commands Tableau Exposure in scheduling tools like Control-M Excellent analytical and problem-solving skills is a must have Excellent communication skills (oral and written) Must be experienced in diverse industry and tools and data warehousing technologies. Preferences Bachelor of Engineering or Master of Computer Applications Experience in working in Agile (SCRUM) Methodology RoleBusiness Analyst Industry TypeIT-Software, Software Services Functional AreaIT Software - DBA, Datawarehousing Employment TypeFull Time, Permanent Role CategorySystem Design/Implementation/ERP/CRM Education UG :Any Graduate in Any Specialization PG :Post Graduation Not Required Key Skills UnixAnalystAnalyticalSystem integrationControl-MSchedulingInformaticaTeradataBusiness intelligenceMacros
Role: Business Analyst
Department: IT Software - DBA, Datawarehousing
Graduation Required: Any Graduate in Any Specialization
Post Graduation Required: Post Graduation Not Required
Doctrate Required: -
IT-Software Software Services
Employment Type:
Full Time Permanent
Unix Analyst Analytical System integration Control-M Scheduling Informatica Teradata Business intelligence Macros