Technical Business Analyst
IT
KZN
Our client is looking for a Technical Business Analyst with strong SQL expertise and a background in software development to join their team at Traq Software.
This role plays a key part in aligning client business needs with technology solutions, ensuring seamless collaboration between stakeholders, IT teams, and development resources to deliver successful solutions.
The ideal candidate will have hands-on experience with SQL, software development, and the Software Development Life Cycle (SDLC), enabling them to bridge the gap between business requirements and technical implementation effectively.
Key Responsibilities
Business & Process Analysis
- Understand business issues and data challenges within the industry.
- Gather and document business requirements through interviews, workshops, and process analysis.
- Translate business needs into functional and technical specifications.
- Identify strengths, weaknesses, and areas of improvement within business processes.
- Develop workflow diagrams, data flow models, and functional decomposition analysis.
SQL & Data Management
- Write, optimize, and execute complex SQL queries for data extraction, reporting, and troubleshooting.
- Work with relational databases (SQL Server) to ensure data integrity.
- Assist in database design, performance tuning, and ETL processes.
Technical & Software Development Collaboration
- Act as a liaison between business teams and development teams to ensure clear communication.
- Work closely with developers on system design, development, and testing.
- Review and analyze system functionalities and propose enhancements.
- Understand and document APIs, data structures, and software architecture.
Testing & Implementation
- Coordinate UAT (User Acceptance Testing) and ensure business needs are met.
- Identify, track, and resolve issues effectively.
- Work with business users to identify necessary system changes.
- Provide training and documentation for end-users and technical teams.
Project Execution & Stakeholder Management
- Manage and enforce project timelines, ensuring deadlines are met.
- Collaborate with cross-functional teams to deliver solutions efficiently.
- Develop relationships with internal and external stakeholders to foster long-term partnerships.
- Provide clear and structured documentation for business processes, functional specifications, and system designs.
Qualifications & Experience
- IT Degree/Diploma or equivalent qualification.
- 4+ years of business analysis experience.
- 2+ years of hands-on SQL experience (writing queries, stored procedures, performance optimization).
- Previous experience in software development or database administration is essential.
- Strong knowledge of SDLC processes and software implementation.
Required Skills & Competencies
- Strong proficiency in SQL and relational databases.
- Knowledge of software development principles (C#, or similar).
- Understanding API integrations and data modeling.
- Excellent communication and stakeholder management skills.
- Strong problem-solving and analytical thinking.
- Ability to work independently and within a collaborative team environment.
- Strong documentation and process-driven analysis skills.
General Work Conditions
- Office-based: Standard hours (08:00 – 16:30).
- Flexibility: May require work outside regular hours based on project needs.
- Travel: Occasional travel to client sites.