Technical Business Analyst

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.