Job Closed
This listing is no longer active.
Get the best talent from South Africa
SQL Analyst
Location
South Africa
Posted
101 days ago
Salary
0
Seniority
Senior
Job Description
SQL Analyst
Remote Choice
• Engage directly with managers and stakeholders to understand reporting and business requirements • Translate business requirements into robust SQL-based solutions • Remotely connect to client servers to install, configure, and support the reporting software • Identify where relevant data is stored across client systems (not limited to SQL Server) • Extract and interpret data from a range of database platforms and business systems • Analyse and understand existing database structures and data relationships • Understand how the software connects to and interacts with SQL databases • Create and modify: SQL views, Stored procedures, Functions, Tables • Apply fixes, updates, and performance improvements within SQL Server • Troubleshoot database, connectivity, and networking issues • Work within Windows Server environments and liaise with client IT teams • Deliver training sessions to clients on effective use of the software • Provide post-implementation support and guidance to users • Take ownership of implementations from initial setup through to completion
Job Requirements
- Strong experience with Microsoft SQL Server
- Advanced SQL querying (joins, aggregations, subqueries, troubleshooting)
- Experience creating views, stored procedures, and functions
- Solid understanding of relational database design
- Experience working within Windows Server environments
- Good understanding of networking fundamentals (permissions, ports, firewalls, DNS)
- Experience remotely accessing and working on client infrastructure
- Confident communicator able to work with non-technical stakeholders
- Ability to work independently and proactively solve problems
- Understanding of bookkeeping principles and core financial structures (desirable)
- Experience working with financial accounting systems or ERP platforms (desirable)
- Experience deploying or supporting applications via IIS (desirable)
- Exposure to APIs and application integrations (desirable)
- Exposure to other SQL dialects (e.g. MySQL, PostgreSQL) (desirable)
- Experience working with other database management systems (DBMS) (desirable)
- Experience working with C# (desirable)
- Familiarity with JSON used within application environments (desirable)
Benefits
- Flexible work arrangements
- Professional development opportunities
Related Guides
Related Categories
Related Job Pages
More Analyst Jobs
Provider Scheduling Analyst – Capacity Management
Ochsner HealthOchsner is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, or disability status. Are you ready to make a difference? Apply Today! Please refer to the job description to determine whether the position you are interested in is remote or on-site. Individuals who reside in and will work from the following areas are not eligible for remote work position: Colorado, California, Hawaii, Illinois, Maryland, Massachusetts, Minnesota, New Jersey, New York, Vermont, Washington, and Washington D.C.
• Communicate with managers/directors and end users to optimize scheduling • Work with regions to standardize scheduling processes • Develop and distribute reports to regional leadership team • Assist with creating new departments in Epic and notify relevant teams • Process provider and ancillary schedules timely to optimize access
HSE Analyst – Data Intelligence
CapcoCapco, a Wipro company, is a management & technology consultancy dedicated to the financial services & energy industries
• Design and implement Business Intelligence solutions • Work on software programming
Senior Analyst – Trading Hypercare
The LeafletAn independent platform for cutting-edge, progressive, legal, and political opinion.
• Continuously monitor activity across high-staking customer accounts to identify behavioural trends, potential risks, and opportunities. • Provide ongoing evaluation of individual customer performance, highlighting any significant changes in staking patterns, frequency, or other relevant behaviors. • Analyze and report on key account metrics, including profitability, risk exposure, and customer lifecycle trends. • Trade high-stakes accounts with precision, ensuring profitability while managing exposure to risk. • Collaborate with trading teams to adjust pricing or betting limits based on customer profiles and behavioural insights. • Work with stakeholders to develop tailored strategies for high-impact accounts based on analysis and business objectives. • Deliver detailed reports on high-stakes customer performance, providing actionable insights for internal teams. • Escalate concerns about suspicious behavior, unusual activity, or emerging trends that may pose a risk to the business. • Present findings and strategy recommendations during regular stakeholder meetings.
Cloud Services Support Analyst
Advanced Solutions International Inc.Advanced Solutions International is a global software company focused on helping not-for-profits and membership organizations grow revenue, reduce expenses, improve performance, engage and serve members and donors through innovative software solutions.
Role Description We are looking for a skilled Cloud Services Support Analyst who is responsible for installation, configuration, administration, and maintenance of networks, and computer systems. Provide technical support and troubleshoot problems on Hosting customer’s systems as appropriate in a Microsoft Azure hosting environment. - Support/administer/maintain all Hosting customer systems as appropriate (Microsoft Azure) - Support/administer/maintain all Hosting customer backup/restore processes - Support/administer/maintain Hosting infrastructure monitoring systems - Support/administer/maintain all system security related issues - Maintain iMIS knowledge to effectively support and upgrade Hosting customer’s iMIS systems as necessary - Azure Automation - User account administration for all Hosting customers - Azure SQL database management/administration activities for Hosting customers as necessary - SQL Managed Instance management/administration activities for Hosting customers as necessary - SQL Server database management/administration activities for Hosting customers as necessary - Upgrade iMIS implementation to latest release as necessary - Support ASI initiatives as necessary/required - Administering Hosting Issues Management queue as necessary - Participate in quarterly Departmental and Corporate BSC reviews - Manage attainment of personal BSC initiatives - Complete yearly professional development initiatives - Mentor team members as necessary - Address Hosting Issues Management queue items in a timely fashion and close as required - Participate in Hosting On Call program - Other duties as assigned by Manager, Hosting Operations, Global Director of Technical Support or Senior Management Qualifications - 3-5 years of IT/Cloud experience delivering and supporting technology solutions - Microsoft Azure Administration - iMIS systems management experience - Good oral, written, analytical, and people skills - Ability to work independently in a fast-paced technology environment - Azure SQL administration skills - Azure Automation - Zendesk Ticketing system - Understanding of ASP .NET and related technologies - Understanding of IIS technologies - Understanding of virtualization technologies - Strong Microsoft operating system and applications knowledge - Basic iMIS knowledge - Some after hours and weekend work is required to support product upgrades and on call Hosting support. Benefits - Generous Paid Time Off - Optional Private Medical Insurance - Wellness Benefits - Retirement Pension Plan - Opportunities for Professional Growth and Development - Volunteer Time Off - Study Leave - Flexible remote working
