Technical Business Analyst (SQL & Software Development)

Our client is seeking a Technical Business Analyst with strong SQL expertise and a background in software development to join their team. 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.