performs software development tasks
performs database administrative tasks
performs business intelligence tasks
Responsible for design, development, testing, maintenance, and support of clients' data warehouse.
Develop data warehouse and business intelligence solutions using Microsoft Business Intelligence tools and underlying technologies e.g. SSAS, BusinessObjects and Novaview
Provide enterprise information management expertise with emphasis on data design, access, usage and stewardship to ensure proper governance, security and quality of information assets.
Code, test and troubleshoot programs utilizing the appropriate hardware, database, and programming technology.
Refine data and format final product.
Maintain and modify programs; make approved changes by amending flow charts, develop detailed programming logic, and coding changes.
Test and develop programming modifications.
Write new program code using prescribed specifications.
Evaluate simple interrelationships between programs such as whether a contemplated change in one part of a program would cause unwanted results in a related part.
Analyze performance of programs and take action to correct deficiencies based on consultation with users and approval of supervisor.
Confer with users to gain understanding of needed changes or modifications of existing programs. Resolve questions of program intent, data input, output requirements, and inclusion of internal checks and controls.
Write and maintain programming documentation.
Maintain confidentiality with regard to the information being processed, stored or accessed.
Design and document database architecture. Data Modeling
Build database scheme, tables, procedures and permissions
Develop database utilities and automated reporting
Analyse the behaviour of codes to diadnose a problem and find the underlying cause.
Document solutions by developing flowcharts, layouts, diagrams, charts, code comments and codes
Research and recommend new tools, techniques and methods regarding application development
Utilise use of a version control tool for managing software codes
Identify and utilise learning opportunities and share new information with team members
Broad knowledge of all basic Microsoft Business Solution (Navision) Essentials granules, installing Navision on multiple clients, application performance
Working knowledge of core financials and distribution granules and able to train in these granules
Navision programming – proven skills in C/SIDE code, Navision report writing, dataports, XMLPort, table and form design
Analyse customer requirements
Conduct client workshops
Document customer requirements and ability to articulate changes required in reports, forms and code to stakeholders
Carry out Navision modifications to a high standard
Install and implement Navision on clients