Business Analyst Systems Admin
Business Analyst Systems Admin
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Not Disclosed
Salary Not Disclosed
1 Vacancy
Job Description
Job Description
Position: SQL / BI Report Analyst / Report Developer
Location: Brackenfell (position is based onsite and is not hybrid)
Salary: Market related.
Own transport is a must.
Summary:
This role is a mix of technical skills (SQL report generation and data manipulation) and industryspecific knowledge (debt collection/legal). The candidate will primarily be responsible for creating and managing SQLbased reports maintaining data accuracy and ensuring that reporting is aligned with business goals while also potentially taking on some team management and operational oversight tasks.
Key Responsibilities:
- SQL Server Management:
- The candidate must have strong experience with Microsoft SQL Server 2012 including:
- Writing adhoc SQL queries to extract or analyze data.
- Understanding and working with stored procedures functions views and tables.
- Using Microsoft SQL Server Management Studio (SSMS) for database management and development.
- The candidate should have a solid understanding of Microsoft Reporting Services (SSRS):
- Maintaining and updating existing reports.
- Modifying or enhancing existing reports as needed.
- Creating new reports from scratch based on business needs.
- Proficiency in Microsoft Excel is critical particularly for report development:
- Advanced Excel functions such as pivots VLOOKUP SUMIF COUNTIF and conditional logic (e.g. IF statements).
- Ability to run SQL queries within Excel using its Query Manager for advanced data manipulation.
- Strong skills in Microsoft Word especially for:
- Using mail merge for document generation and publishing reports.
- Formatting and managing merge fields for creating professional documents.
- Experience in a Debt Collection or Legal Environment 23 years) which is crucial for understanding financial processes and legal terminology.
- Exposure to systems such as Excalibur Collection Systems Intecon ALLPS Capitec CORS and others (desirable but not mandatory).
- Experience managing a small team and handling relationships with service providers (this is an advantageous skill).
- A strong ability to learn systems and processes quickly.
- Resultdriven approach to problemsolving and meeting goals.
- Selfsufficient and capable of working independently though also able to collaborate in a team setting.
- Having a drivers license and a vehicle is a requirement for the role.
Required Experience and Skills:
- Microsoft SQL Server: Deep knowledge in managing databases creating queries and ensuring data integrity.
- Microsoft Reporting Services (SSRS): Creating modifying and maintaining business reports.
- Microsoft Excel: Advanced knowledge for building reports and analyzing data.
- Microsoft Word: Document publication and report formatting.
- Debt Collection/Legal Environment: Understanding financial ledgers accounting and how collections or legal processes work.
- Team Leadership (Advantageous): Managing a team or service providers.
Additional Requirements:
- Matric certificate as a minimum educational qualification.
- Strong understanding of financial ledgers and accounting principles essential.
- Work ethic: Independent selfstarter who can function with minimal supervision but also be a part of a collaborative team.
Required Experience:
IC
Employment Type
Full-Time
