System Analyst - Kempton Park
Kempton Park
R Market elated
Qualification
Bachelor's degree in a relevant field.
Certification in database administration or relevant technologies.
Experience working in an Agile development environment.
Requirements
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.
Duties
1. SQL Design and Development:
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.
2. Data Analysis/BI:
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.
3. Database Administration and Maintenance:
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.
4. C# Back End and Front End Development:
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.
5. Python Full Stack Development:
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.