BI Data Analyst

Job description

Requisition Number and Contact Details
REQ # 113105
Talent Acquisition Consultant - Ezekiel Dube
Closing Date
26 November 2021
Job Family
Information Technology
Career Stream
It Application Development
Leadership Pipeline
Manage Self: Technical
Job Purpose
To ensure the support and maintain the data warehouse in line with the data model; metadata repository and to provide business intelligence analysis through performing strategic and operational support.
Job Responsibilities
  • Develop reporting solutions; write SQL stored procedures, functions, triggers to manipulate the data supplied by the source system and prepare it for reporting
  • Develop, implement, and maintain change control and testing processes for updates to databases
  • Manage projects to Analyze, design, develop and maintain database solutions to manage client data
  • Ad Hoc Reporting/Extracts using SQL/SSRS/SSIS/SSAS
  • Clear technical understanding across a broad range of technologies
  • Managing the SQL Design architecture in a complex model environment
  • Design SQL queries for ad hoc reporting
  • Continuously improve - identify opportunities, suggest and implement solutions.
  • Optimizing SQL queries to improve performance
  • Documentation of SQL Designs developed
  • Unit Testing own code
  • Ensure reporting, compliance and data quality processes are in place within projects
  • Extract or collect required data for analysis
  • Verify results against given specifications
  • Abide by the project guidelines to manage and secure client data
  • Develop data extracts to satisfy business needs
Minimum Experience Level
  • 8 years relevant experience of which 3-5 years experience is in a data management /business role
  • ETL, SQL Server, SSIS, SSRS, SSAS, Power BI, Advanced Excel
Preferred Qualification
Degree in Information Technology or Business Management, Mathematical/Statistics
Essential Certifications
  • Data Management (DAMA) Certification, Certification/formal training in relevant technology
Type of Exposure
  • Built and maintained stakeholder relationships
  • Client and Relationship Results
  • Developed and Implemented Communications Strategy
  • Improved Processes and Culture
  • Manage internal process
  • Managed Relationships
  • Managed Self
  • Supported Transformation, Change and continued Improvement
Technical / Professional Knowledge
  • Microsoft Office
  • Relevant regulatory knowledge
  • Business writing skills
Behavioural Competencies
  • Coaching
  • Communication
  • Initiating Action
  • Managing Work
  • Quality Orientation
  • Technical/Professional Knowledge and Skills
Please contact the Nedbank Recruiting Team at +27 860 555 566

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.