Business Intelligence Developer
Duties and Responsibilities
- Translate business needs to technical specifications.
- Design, build and deploy BI solutions (e.g. reporting tools).
- Maintain and support data analytics platforms (e.g. MicroStrategy).
- Create tools to store data (e.g. OLAP cubes).
- Conduct unit testing and troubleshooting.
- Evaluate and improve existing BI systems.
- Collaborate with teams to integrate systems.
- Develop and execute database queries and conduct analyses.
- Create visualizations and reports for requested projects.
- Develop and update technical documentation.
Essential Criteria
- Proven experience as a BI Developer or Data Scientist.
- Industry experience is preferred.
- Background in data warehouse design (e.g. dimensional modelling) and data mining.
- In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.
- Familiarity with BI technologies (e.g. Microsoft Power BI, Oracle BI, etc)
- Knowledge of SQL queries, SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).
- Experience working on Azure or AWS will be beneficial.
- Proven abilities to take initiative and be innovative.
- Analytical mind with a problem-solving aptitude.
- Minimum 3-5 years’ experience in SQL development.
- Minimum 3-5 years’ experience in Business intelligence and data warehousing.
- Relevant certifications will be an advantage.
Skills Required
- Good verbal and written communication skills.
- Creative thinking and problem-solving skills.
- Tenacity to pursue finding solutions to complex problems.
- Ability and willingness to learn from and share skills with colleagues.
- Team-working Skills.
- Ability to work independently and efficiently under deadlines.
- Ability to complete work within estimated time constraints.
- Time management skills to handle multiple tasks and prioritize work appropriately.
- The drive and natural tendency to keep your technology skills up to date.
- Ability to develop code and supporting unit tests. (Coverage assessment, mocking).
- Must be detailed oriented.
hr@emortechnologies.co.za
