System Analyst - Kempton Park
Objective Personnel
- Kempton Park, Gauteng
- Permanent
- Full-time
Location: Spartan, Kempton ParkClient 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.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.