SQL BI Analyst Developer - Junior - 13004

SQL BI Analyst Developer - Junior
Job No:  13004
Location:  Johannesburg, Braamfontein
Salary:  R 20 000 - R 30 000 Per Month

Financial process information and experience having dealt with software development teams would be beneficial. You must be able to understand the full spectrum of processes and how they map to the operational system, along with the detail, and be able to interrogate databases.

Development

  • Comprehensive knowledge of relational database design and structure
  • Knowledge surrounding the building of SQL Queries, Sub-Queries and SQL CRUD operations
  • Basic experience in the optimizing of SQL statements
  • Practical experience with Microsoft SQL Server
  • Practical experience with MySQL a bonus (but not a requirement)
  • Translate business needs to technical specifications
  • Design, build and deploy SQL BI solutions (e.g. reporting tools (SSRS))
  • Working knowledge of Java script
  • Maintain and support data analytics platforms
  • Create tools to store data
  • Conduct unit testing and troubleshooting
  • Evaluate and improve existing BI systems
  • Collaborate with teams to integrate systems
  • Develop and execute database queries and conduct analyses
  • Create visualizations and reports for requested projects
  • Develop and update technical documentation

Qualification

  • Engineering: Computer Science
  • Electrical Engineer focusing on Software
  • Project coordination
  • Arrange meetings with stakeholders
  • Take notes from meetings to form action points
  • Assign action points to relevant team members
  • Follow up on overdue tasks

Issue Tracking

  • Understand operational systems and business processes
  • Identify, collect, and collate issues and / or bugs arising from the operational system
  • Identify process inefficiencies and problems.
  • Coordinate with software development team to communicate issues and receive feedback
  • Distribute feedback to business stakeholders and team managers.

System Development coordination

  • Gather system feature requests from business users
  • Log feature requests with software development team
  • Liaise with software development team on requests and timelines
  • Coordinate meetings with stakeholders for scoping and gather feedback

Team Communication

  • Keep a centralized log of projects, tasks, bugs, issues, and business process problems
  • Streamline communication between various team members, development team, and management