Senior Analyst Developer (Delphi/SQL Server) at Crystal Recruit

Responsibilities.

• Design, develop, and maintain the core Laboratory Information Management System (LIMS), primarily using Delphi and SQL. Integrate the LIMS with laboratory equipment and other Cropnuts and third-party systems to streamline data exchange and workflow automation. Design, optimize and maintain database schemas, stored procedures, and queries to ensure data integrity, performance, and security of database systems.
• Develop APIs and contribute to the design, development and support of other products and systems across the organization's technology stack. Write clean, efficient, and maintainable code and ensure adherence to coding standards and best practices.
• Develop reports and dashboards from various data sources, including the LIMS database, using reporting tools such as Excel, SSRS and Power BI. Implement business intelligence solutions to analyze data trends, identify insights, and support informed decision-making processes.
• Work closely with users and stakeholders to gather and analyses requirements and optimize workflows. Translate business requirements into technical specifications and design solutions that address user needs. Continuously monitor and enhance integrations to ensure compatibility with evolving technologies and standards.
• Provide technical guidance and mentorship to other developers across development teams. Collaborate with cross-functional teams to ensure alignment with architectural standards and best practices.
• Develop and execute comprehensive test plans to ensure the quality and reliability of software applications. Conduct code reviews and participate in quality assurance activities to identify and address issues early in the development process.
• Identify opportunities to optimize software performance and enhance scalability. Implement optimizations to improve application efficiency and responsiveness.
• Troubleshooting and Support: Investigate and resolve technical issues reported by users or identified during testing. Collaborate closely with users to understand their requirements and provide guidance and assistance as needed. Provide timely support and troubleshooting assistance to users ensuring that user support requests are handled promptly and professionally, maintaining high levels of user satisfaction and engagement.
• Create and maintain technical documentation, including design documents, user manuals, and API documentation. Ensure documentation is kept up-to-date and accessible to relevant stakeholders.
• Stay updated on emerging trends and technologies in software development, particularly within the organization's Tec stack ecosystem. Continuously enhance your skills and knowledge to remain effective in your role.

Requirements

• Bachelor's degree in computer science, Software Engineering, or a related field.
• Extensive experience in software development using Delphi and related frameworks and tools (e.g. DevExpress, Fast Reports, Digital-Metaphors Report Builder).
• Proficient in Delphi 7 or later and highly effective at debugging and troubleshooting of Delphi applications
• Sound understanding of relationship databases and strong SQL and Stored Procedure
• Extensive experience with Microsoft SQL Server and ideally with MySQL and Postgres databases.
• Experience with reporting tools such as SQL Server Reporting Services (SSRS), Power BI, Excel, and Looker Studio for creating reports and dashboards from various data sources.
• Familiarity with version control systems (e.g. Git), issue tracking tools, and agile development methodologies.
• Excellent problem-solving skills and attention to detail. Ability to debug and troubleshoot complex issues effectively.
• Effective communication skills, with the ability to convey technical concepts to non-technical stakeholders.
• Proven ability to work independently and collaboratively in a team environment.
• Familiarity with Delphi testing methodologies and frameworks such as unit testing.
• Familiarity with Delphi Logging Libraries
• Experienced in developing and utilizing RESTful APIs
• Knowledge of multiple back-end languages (e.g. Python, PHP) and JavaScript frameworks (e.g. React, Node.js)
• Experience developing web applications and understanding of web development technologies.
• Strong understanding of object-oriented programming concepts and design patterns.
• Knowledge of process automation techniques
• Experience working with cloud platforms such as Azure, AWS, or Google Cloud Platform (GCP), including familiarity with cloud services and deployment processes.
• Experience with Agile methodologies of planning work.
• Familiarity with Geographic Information Systems (GIS) and Geo-databases is a plus.