A leading tech company is hiring an SQL Systems Analyst for a 6 month contract

<p><strong>Role</strong></p><p>The organisation is undertaking a modernisation of its internal operational systems and is seeking a hands-on technology specialist to develop, implement and deploy new solutions across the business.</p><p>The successful candidate will play a key role in replacing an existing Microsoft Access-based system, enhancing and extending a Supabase-based operational platform, migrating and validating data, conducting system testing, deploying solutions and supporting users through the implementation process.</p><p>This is a practical, delivery-focused position suited to an individual who can take ownership of solutions throughout the full implementation lifecycle, from development and data migration through to deployment, user adoption and ongoing support.</p><p>Success in the role will be measured by the delivery of reliable, fit-for-purpose systems that are effectively adopted by users, underpinned by accurate and well-managed data, and supported by comprehensive technical and user documentation.</p><p><br></p><p><strong>Requirements</strong></p><p>Legacy System Modernisation</p><ul><li>Assess the existing Microsoft Access environment and lead the transition to a modern SQL-based or cloud-based solution.</li><li>Analyse existing databases, forms, queries, reports, workflows and business rules.</li><li>Document current processes and identify opportunities for process improvement and automation.</li><li>Design the target database and application architecture.</li><li>Cleanse, map, migrate and validate historical data.</li><li>Rebuild required workflows, forms, reports and dashboards.</li><li>Implement appropriate security, access controls, backup and recovery processes.</li><li>Ensure the new solution is scalable, secure, maintainable and aligned with business requirements.</li></ul><p>Operational Platform Development</p><p>Continue developing and enhancing the organisation's operational platform using Supabase, PostgreSQL and modern AI-assisted development tools.</p><p>Key areas of functionality include:</p><p><strong>Inventory & Warehouse Management</strong></p><ul><li>Stock receiving and processing.</li><li>Serialised inventory and location management.</li><li>Stock transfers, picking, dispatch and delivery.</li><li>Returns processing.</li><li>Barcode scanning and tracking.</li></ul><p><strong>Asset Management</strong></p><ul><li>Customer asset identification and tracking.</li><li>Serial number, location and warranty management.</li><li>Asset movements and equipment transfers.</li><li>Repairs, replacements and swap-outs.</li><li>Complete asset lifecycle and maintenance history.</li></ul><p><strong>Technical Job Management</strong></p><ul><li>Job creation, allocation and scheduling.</li><li>Technician and site attendance tracking.</li><li>Recording work completed and technical activities.</li><li>Capturing photographs, stock usage and configuration information.</li><li>Customer approval and sign-off.</li><li>Job reporting and historical records.</li><li>Develop additional operational modules and workflows as business requirements evolve.</li></ul><p>Database & Application Development</p><ul><li>Design, develop and maintain Supabase, PostgreSQL and SQL database environments.</li><li>Develop database relationships, views, functions, validations and audit trails.</li><li>Implement authentication, role-based permissions and row-level security.</li><li>Develop and integrate APIs where required.</li><li>Use Git/GitHub for source-code management and version control.</li><li>Apply appropriate software architecture, security, testing and development standards.</li><li>Ensure AI-assisted development tools are used effectively while maintaining code quality, security and maintainability.</li></ul><p>2. Business Process & Solution Design</p><ul><li>Engage with management and operational teams to understand business requirements.</li><li>Analyse existing processes and translate business needs into practical technology solutions.</li><li>Identify opportunities for automation, optimisation and improved operational efficiency.</li><li>Develop prototypes and proof-of-concept solutions where appropriate.</li><li>Obtain user feedback throughout the development process.</li><li>Refine and enhance solutions to ensure they are fit for production and easy to use.</li><li>Ensure technology solutions provide practical and measurable business benefits.</li></ul><p>3. Testing, Implementation & Rollout</p><ul><li>Conduct functional, data, workflow, access-control, mobile and desktop testing.</li><li>Coordinate user acceptance testing and resolve issues prior to deployment.</li><li>Develop implementation and deployment plans.</li><li>Prepare, migrate and validate operational data.</li><li>Configure users, roles and permissions.</li><li>Deploy completed functionality to the relevant business areas.</li><li>Monitor adoption and resolve issues during the initial implementation period.</li><li>Gather user feedback and continuously improve system functionality.</li><li>Decommission legacy systems once the replacement solution has been fully tested, approved and stabilised.</li></ul><p>A solution will only be considered successfully delivered once it has been <strong>tested, approved, deployed and adopted by the business</strong>.</p><p>4. Training & Documentation</p><ul><li>Develop user guides, quick-reference materials and training resources.</li><li>Deliver training to employees, key users and system administrators.</li><li>Provide initial support following implementation.</li><li>Document application architecture, database structures, business rules, permissions and integrations.</li><li>Document deployment, backup, recovery and administration procedures.</li><li>Maintain accurate source-code repositories and technical documentation.</li><li>Ensure documentation remains current and supports ongoing system administration and maintenance.</li></ul><p>All source code, database structures, documentation and related intellectual property developed as part of the employment relationship will belong to the organisation, subject to the applicable employment agreement.</p><p>5. Required Experience & Skills</p><ul><li>Strong practical experience with SQL, PostgreSQL and relational database design.</li><li>Experience working with Supabase or similar cloud-based backend platforms.</li><li>Web application development experience.</li><li>Experience designing and integrating APIs.</li><li>Proven experience migrating data from Microsoft Access or other legacy database systems.</li><li>Practical experience with AI-assisted development tools such as Lovable, Cursor, Claude Code, GitHub Copilot or ChatGPT.</li><li>Experience with authentication, access control, testing and production deployment.</li><li>Experience developing reports, dashboards and operational systems.</li><li>Strong business process analysis and solution design capabilities.</li><li>Excellent communication skills with both technical and non-technical stakeholders.</li><li>Experience providing user training and supporting technology adoption.</li></ul><p>Experience in developing solutions for any of the following environments would be advantageous:</p><ul><li>Inventory and stock management</li><li>Warehousing</li><li>Asset management</li><li>Field service</li><li>Technical job management</li><li>ERP</li><li>Logistics</li><li>Operational management systems</li></ul><p>6. Portfolio Requirement</p><p>Candidates must provide examples of systems or applications they have personally developed or significantly contributed to.</p><p>Candidates should be able to demonstrate:</p><ul><li>Their specific role and contribution to the project.</li><li>Technologies, programming tools and database platforms used.</li><li>Application and database architecture.</li><li>The business problem addressed by the solution.</li><li>Technical and business challenges encountered and how these were resolved.</li><li>Testing, deployment and implementation approach.</li><li>How the solution is used by the business and its users.</li></ul><p><br></p><p><br></p>