The Role: We are recruiting a mid to senior level BI Developer to join our team in Johannesburg.
The purpose of this role is to analyze, design, implement and maintain business intelligence solutions to provide business-to-business reporting for informed decision-making.
The Technical Analyst will need to develop and support business logic using SQL to generate reporting data stores for a variety of [URL Removed] The analyst will also design and develop Bi reports using Power BI or OBIEE.
Skills and experience: Required qualities :
- Bachelors?? Degree in computer science, GIS or information management
- OR any BI accreditation
Preferred degree:
- Relevant IT/BI qualification
Relevant MS Certification
Experience required:
- Minimum 3-5 years?? development experience in a business intelligence environment, including storyboarding, reporting and data visualization or a similar role
- Excellent command of SQL (both Oracle SQL and Hive SQL)
- Proficiency in data modeling and data mart design
- Development experience in Power BI/OBIEE or any other visualization tool.
- Experience with Big Data environments (Hadoop)
- Telecommunications experience is a plus
- Worked in environments with large volumes of data
- Experience in Microsoft SQL Server Analysis Services (SASS) would be an advantage.
- Confident in engaging with business and technical stakeholders
- Excellent analytical and problem solving skills
- Excellent written and spoken English
- Must be autonomous
- Knowledge of industry leading business intelligence support best practices
- Technical knowledge of data governance practices, business and technology issues related to enterprise information asset management, and business intelligence approaches
- Technical knowledge of data-related government regulatory requirements (if applicable) and emerging trends and issues
- Knowledge of the Agile project management framework
Main responsibilities: Tasks/Responsibility:
- Design and develop logic for creation of data marts as needed and hand over to data engineering team for automation
- Develop interactive visual dashboards and reports using Power BI
- Create ad-hoc reports/data extracts from the organization’s database
- Interpret data and develop relevant recommendations based on the results of data analysis
- Resolve enterprise source system data issues and provide guidance and/or present solutions to those issues
- Provide advice and assistance to end user queries
- Participate in design and peer reviews
- Review the impact that any code changes may have on data stores.
- Oversee data integration with the data warehouse
- Maintain the organization’s intellectual property by documenting solutions on the organization’s wiki platform
- Provide feedback on improving system maintenance, performance and support initiatives
- Oversee report integrity, both when building new reports and when running existing scripts to ensure data is presented accurately.
- Build and maintain strong relationships with business unit stakeholders
- Collaborate with assigned business units to understand their business intelligence needs and design possible solutions
- Work collaboratively with key business unit stakeholders to prioritize projects and data requests
- Be the single point of contact for business intelligence for the assigned business unit
- Work with project teams to prioritize business and information needs
- Organize regular sessions with clients to inform, educate and facilitate feedback
- Mentor junior staff to ensure they have the opportunity to apply the developer skills they have learned
- Maintain technical knowledge of technology within client’s Business Intelligence landscape.
- Identify new opportunities to improve data collection and analysis processes
- Filter and ??clean? data by reviewing reports and performance metrics to locate and identify/fix code issues
Find out more/Apply to this position
