08-11-2016, 03:17 PM
1466956983-ComprehensiveDWAjobsupdated.docx (Size: 23.55 KB / Downloads: 4)
Abstract
Data warehousing is all about collectingofdata and analyzing it. Analysis will helps in making important decisions within the organizations. Consumer’s analysis, operations analysis, production strategies, etc are the key for improvising the performances. Identify the intelligent behaviors of the data is achieved by employing the quality resources who can perform an effective analysis. This document provides a comprehensive report of Analyst jobs available in the market. This report is created considering the most available different analyst job roles/positions on data warehouses and summarizes the requirements based on type of position, location, duration of position, educational requirements, total experience expected, knowledge of tools and techniques, level of expertise in specific technologies/skill set matrix, Salary/rate per hour, relocation availability.
Keywords: Business Intelligence,Data Warehouse, OLAP, Data warehouse Analyst, Data Warehousing.
Introduction
Companies create employment positions to enhance the performance of their projects or to complete the projects within deadlines. To fill the vacant positions companies, hire talent based on certain benchmarks. Each position is filled by considering many criteria’s and qualifications desirable. Companies post their position requirements in multiple job portals. Companies recruit employees by selecting the desired applications that are suitable for their requirement. In this report, I consider the Data warehouse Architect position to search in job portals using search keywords Business Intelligence, Data Warehouse, Data warehousing, dimensional modeling, OLAP, cubes, data warehouse analyst etc. This report helps in identifying what are the different criteria’s considered and their importance. Next sections will give more detail about consolidated criteria’s considered for the analyst job roles.
Job Description
• Communicate with business and IT teams to derive a solution for the complex business requirements.
• Understand the existing database designs, data modeling to come to conclusions for improvising or enhancing the architecture that improves performance.
• Create documentation for application systems, provide business rules and interpret process followed.
• Communicate with business partners to design and support BI solutions following assigned governing process.
• Develops ETL processes to automate the business processes operations using MySQL Services.
• Utilizes reporting tools Tableau, SAP business objects, HANA etc to create dashboards that provide reporting environments for analysis.
Job Title:
• Business intelligent Analyst
• Data warehouse systems Analyst
• Business/Data Analyst
• Senior BI consultant
• Business Intelligent developer.
Education Qualifications
• Bachelor's of Science in computer science or computer engineering
• Masters or preferred equivalent level of experience.
Qualifications for the job:
The below are the frequently asked qualifications for the business intelligent or data warehouse analyst job roles:
1. Good experience in formulation of BI solutions for the business domains and needs.
2. Experience in designing and modeling of data warehouses along with development and support of BI applications.
3. Preferred 3 to 5 years of experience in the architecture of enterprise systems.
4. Reporting tool experience along with Analysts experience (Tableau).
5. Strong business engagement skills and communication skills
6. Strong understanding of relational database systems and data warehouse methodologies.
7. At least few years of experience working in Agile/Scrum methodologies.
Tools required/techniques
Analyst roles often require any of programming languages preferably SQL for data extraction along with a reporting tool.
• SQL, ETL, SQL Server.
• Reporting tools Tableau, SAP Business objects, Business objects web intelligence, SAP HANA
• Any of the programming language for high-level understanding before creating designs.
• Data warehouse environment tools.
Salary
As per indeed, the average salary for business analyst role will be around 76,000 USD.
The salary of any employee varies based on different criteria’s such as skill set of any employee, the size of the company, the number of years of work experience, location. The different source will show to different price differences but salary is based on company that hires the employee.
Conclusion
This report shows the requirement of Business Analysts in the industry. These roles help in managing the data, analyzing the data and providing business decisions to the customers using reporting analysis. In future, to handle the critical information of the business Data warehouse analysts/business analyst roles will significantly increase.