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 responsibilitiesAnalyze functional and business requirements to produce comprehensive technical specificationsModel 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 modulesDesign, review, and validate database schemas, data models, and modular architecturesWrite and optimize complex SQL queries for data analysis, validation, and testingSupport system integration, API design, and interface specificationsConduct impact analysis for system changes, data migrations, and feature enhancementsCollaborate with developers and architects to ensure technical solutions meet performance, security, and scalability requirementsParticipate in integration, system, and user acceptance testing with a focus on technical validationMaintain technical documentation, models, and traceability for ongoing development and audit purposes Required skills & qualificationsProven experience as a Technical Analyst, Systems Analyst, or Application Analyst in a technically complex environmentStrong proficiency in BPMN and UML for modeling system processes and architecturesAdvanced SQL skills (complex joins, aggregation, stored procedures, performance optimization)Deep understanding of relational database design, data modeling, normalization, and modularizationExperience with system integration, APIs, data pipelines, and modular or layered architecturesAbility to translate business and functional requirements into precise, testable technical specificationsStrong problem-solving, analytical, and troubleshooting skillsExcellent communication with cross-functional technical teams The offerA permanent, full-time employment contractA salary & benefits package commensurate with experience