Share this job with your friends, family and co-workers...
THIS JOB ADVERT HAS EXPIRED...
MIS ANALYST DEVELOPER - 336940
MIS ANALYST DEVELOPER
Information Technology / Web Development / Telecommunications
Wage / Salary:
R - Market Related - P/M (Per Month)
MIS Analyst Developer - JHB
We are looking for an internal MIS Analyst Developer to manage our IQbusiness MIS, related data and reports. Take ownership in a multi-disciplined position where the core skills of this role comprise of 60% data engineer and 40% data analyst/report writer. The MIS Analyst Developer will be responsible for analysing information generated by the business, generating reports for different departments and Practices and forecasting future trends.
Develop integrated reports, methodologies, and files for analysing and presenting data.
Collects and summarises data in preparation for statistical and analytical reports i.e. KPI reports, Daily and Weekly reports etc.
Interprets, evaluates, and connect data, and develops integrated business analyses and projections for reporting purposes.
Produce high quality reports and ensure accurate data.
Identify areas to increase efficiency and automation of processes.
Investigate ad hoc queries; assist in data interpretation and present results.
Identifying exceptions and errors and investigate and report on the causes for the occurrence.
Research and analyse data from internal processes to identify opportunities to improve operations visibility.
To undertake duties as directed and requested by the Financial Manager to support the delivery and implementation of projects.
Prepare written responses to routine enquiries.
Maintains quality service by establishing and enforcing organisation standards.
Design and develop- databases, SQL queries, stored procedures, reports, dashboards or integration solutions
Produce solutions for both real-time and batch environments
Test work to ensure accuracy, correctness and compliance
Solve problems and perform root cause analysis
Prioritize workloads, estimate effort and communicate completion dates
Assist in other areas relating to your true data function, such as data modelling, data and business analysts
Work as part of a team
Interact with a variety of individuals: senior, junior, technical and from business
Provide guidance to fellow colleagues
Uphold the IQ values, which are to care, learn & share; innovate; deliver as well as to build, enhance and maintain relationships
Degree preferably in Information Systems / Statistics / Science.
Relevant Microsoft certifications.
+4 years' experience in database development, data analysis and report writing, including demonstrated proficiency with analytical software.
Minimum Level 3 in MS Office - Excel (Expert) and proficient in the following:
Excel - Power Queries
VBA - custom macros and automation
ODBC Drivers for connecting to SQL Servers
Writing VBA SQL String
The use of data related software: databases, ETL and BI tools; report writing and analytical tools
Previous experience in using MS SQL Server, SSIS, SSRS, SSAS and Power BI to develop solutions
A strong knowledge of professional services industry and supporting the operational reporting needs of a business.
No criminal record
Clear financial record