JOB OVERVIEW
As a BI Specialist Developer:
- You play a critical role in ensuring that the Financial business expert has the key data it needs to make critical business decisions that drive the strategy and direction of the organization. Your skills in SQL combined with your ability to quickly understand key business concepts will enable you to successfully meet the challenges of mining and aggregating data from multiple sources into the organizations data warehouse.
- You should have a firm grasp of BI implementation methodologies and have had in-depth experience with at least one BI Suites (Oracle, Microsoft, IBM, others). You have an analytic approach to solving business requirements which enables increased collaboration with the business data analysts.
- The right individual should possess experience in all development stages of BI and Data Warehouse project work from working with the data analysts to understanding the business requirements, being involved in the implementing the technical solution and supporting the business team to verify the outcome meets the business requirements.
KEY RESPONSIBILITIES
As a Business Intelligence Specialist Developer, your responsibilities are:
Ability to work on data design/data modeling, well understanding of Dimensional Data Modelling concepts.
Ability to write efficient SQL queries and tune/evaluate their performance.
Ability to develop efficient shell scripting to manage data gathering, mining and transformation.
Understanding of data integration issues (validation and cleaning), familiarity with complex data and structures.
Ability to develop OLAP cubes.
Ability to develop rich and interactive business intelligence reports/dashboards.
Ability to develop insightful business conclusions and generate data and reporting solutions to optimize and address the business needs.
Ability to develop models with advanced data visualization that identify and forecast trends and cause-effect relationships, lead to recommendations, and measurably maximize operational efficiency.
Experience with developing mobile business intelligence application is preferred.
Experience with the use of DAX (Data Analysis Expression) is preferred.
Experience with any of the following languages R, Python, Java is preferred.
Experience with any of the following databases NoSQL, MongoDB, HBase, Cassandra, Hadoop is preferred.
Build and update relevant technical documentation.