System Analyst - Kempton Park

SUMMARY:
Systems Analyst - SQL, BI, and Full Stack Development
Location: Spartan, Kempton Park

Client is seeking a highly skilled and motivated Systems Analyst with expertise in SQL design and development, data analysis, business intelligence (BI), database administration, and full-stack
development. The ideal candidate should have hands-on experience with T-SQL, PostgreSQL,SSRS, Python data tools, Excel, Query Analyzer, C#, and Python frameworks like Flask and Bottle.
This role requires a versatile professional who can seamlessly transition between database design,data analysis, and full-stack development to support and enhance our IT systems.

POSITION INFO:
Qualification

• Bachelor's degree in a relevant field.
• Certification in database administration or relevant technologies.
• Experience working in an Agile development environment.

• Must be highly motivated and versatile Systems Analyst with a minimum of 5 years of experience, looking to contribute your skills in SQL, BI, and full-stack development.
• Proven experience in SQL design and development, BI, and database administration.
• Strong proficiency in T-SQL, PostgreSQL, SSRS, Python data tools, Excel, Query Analyzer, C#,and Python frameworks (Flask, Bottle).
• Solid understanding of software development life cycle and best practices.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills.

• Develop and optimize complex SQL queries using T-SQL and PostgreSQL to ensure efficient data retrieval and manipulation.

• Design and maintain relational databases, ensuring data integrity and performance.

• Utilize SSRS, Python data tools, and Excel for data analysis and reporting.
• Design and create BI reports and dashboards to provide actionable insights to stakeholders.
• Collaborate with business users to understand reporting requirements and translate them into effective BI solutions.

• Administer and maintain databases using tools like Query Analyzer.
• Perform routine checks, backups, and updates to ensure database security and stability.
• Troubleshoot and resolve database-related issues promptly.

• Engage in back-end development using C# to support business logic and functionality.
• Develop and maintain front-end components to enhance user interfaces and overall user experience.

• Build and maintain full-stack applications using Python frameworks such as Flask and Bottle.
• Collaborate with cross-functional teams to integrate front-end and back-end components seamlessly.