Vivid Resourcing

We are seeking a technically proficient Technical Analyst to define, design, and validate complex system solutions. This role is critical for translating business and functional requirements into detailed technical specifications, system models, and data architectures that drive software development, integrations, and operational efficiency. The ideal candidate combines strong analytical skills with deep technical expertise in BPMN/UML, SQL, data modeling, and modular system design. The Technical Analyst will MAP end-to-end system workflows, data flows, and integration points, producing precise BPMN and UML diagrams to capture sequence, activity, component, and interface-level interactions. You will define system behavior, validation rules, and data transformations, ensuring alignment with architectural standards, scalability, and maintainability. The role requires hands-on experience with SQL for complex queries, data validation, and troubleshooting, as well as experience in designing and validating relational schemas, modularized data models, and layered architectures. A key focus of the role is ensuring seamless integration across systems, APIs, and data pipelines, and supporting technical teams in solution implementation, testing, and post-deployment validation. You will collaborate closely with software engineers, data engineers, architects, and QA teams to ensure that systems are robust, modular, and aligned with enterprise data and integration standards. Key responsibilities Analyze functional and business requirements to produce comprehensive technical specifications Model system processes, workflows, and architecture using BPMN and UML (sequence, activity, component, and deployment diagrams) Define data flows, transformations, and integration points across systems and modules Design, review, and validate database schemas, data models, and modular architectures Write and optimize complex SQL queries for data analysis, validation, and testing Support system integration, API design, and interface specifications Conduct impact analysis for system changes, data migrations, and feature enhancements Collaborate with developers and architects to ensure technical solutions meet performance, security, and scalability requirements Participate in integration, system, and user acceptance testing with a focus on technical validation Maintain technical documentation, models, and traceability for ongoing development and audit purposes Required skills & qualifications Proven experience as a Technical Analyst, Systems Analyst, or Application Analyst in a technically complex environment Strong proficiency in BPMN and UML for modeling system processes and architectures Advanced SQL skills (complex joins, aggregation, stored procedures, performance optimization) Deep understanding of relational database design, data modeling, normalization, and modularization Experience with system integration, APIs, data pipelines, and modular or layered architectures Ability to translate business and functional requirements into precise, testable technical specifications Strong problem-solving, analytical, and troubleshooting skills Excellent communication with cross-functional technical teams The offer A permanent, full-time employment contract A salary & benefits package commensurate with experience