Business Intelligence Developer

Britehouse is a home from home for technology futurologists – people who revel in anticipating rather than simply tracking the evolution of technology...

Britehouse Digital -> SS4M ->
Consulting Services

Job Type: Permanent |
Level: Senior |
Travel: Yes |
Location: Head Office - Bryanston, GP 2021 ZA (Primary)

Job Description: The role of a Data Analyst and Business Intelligence Developer is to transform data found inside an organization into new information that will be used to make business decisions. We are looking for a Data Scientist that will help us discover the information hidden in vast amounts of data, and help us make smarter decisions to deliver even better products.

• Designing, building and deploying data warehouse solutions using Microsoft SQL Server Business Intelligence technologies while ensuring that existing adopted data warehousing methodologies, Microsoft best practices and industry best practices are followed.
• Translating business requirements into functional and technical requirements and communicate these requirements to the business and relevant technical teams.

• Designing and implementing integration technology between Microsoft SQL Server Business Intelligence technologies and other business systems adhering to Microsoft and industry best practises.
• Designing, building and deploying, timeous, relevant and accurate management reporting, using Microsoft SQL Server Reporting Services and Microsoft Power BI.
• Monitoring Microsoft SQL Server Business Intelligence technologies performance
• Creating and maintaining architectural, project and operational documentation

• Respond to ongoing business requirements by improving the business intelligence solution through continual development, maintenance, support and enhancement
• Conducting root‑cause analysis to identify problems areas and risks in systems or application design.
• Assisting in aligning systems strategy and roadmap with business needs
• Designing and conducting a detailed system test plan to ensure an accurate and effective systems / application implementation
• Performing end‑user training and conduct workshops
• Performing analysis to determine scope and objectives for business, functional and technical requirements

• Minimum of 1 year SSIS experience.
• Minimum of 1 year experience in building and maintaining OLAP cubes in analysis services 2005.
• A demonstrated experience in complex reports, master reports and cube reporting.
• 1 – 2 years experience in database design and the normalization of data structures – must have developed a star schema and facilitated a team effort.
• 1 – 2 years experience in Database administration.
• A passion for the industry and be willing to do self‑study.

• Minimum of 2-5 years SSIS experience.
• Minimum of 2-5 years experience in building and maintaining OLAP cubes in analysis services 2005.
• A demonstrated experience in complex reports, master reports and cube reporting.
• 3 – 5 years experience in database design and the normalization of data structures – must have developed a star schema and facilitated a team effort.
• 2 – 4 years experience in Database administration.
• A passion for the industry and be willing to do self‑study.
• Experience in application design, development and performance tuning
• Understanding of Software Development Lifecycle (SDLC) methodologies
• Knowledge and Experience in SSIS, SSRS and SSAS
• Ability to create advanced data models using computised tools.
• Ability to cull data and extrapolate data patterns.
• Ability to design and implement meaningful reports and dashboards using computised tools.
• SSSIS
• Building and maintaining OLAP cubes in analysis services 2005
• Database administration
• Understanding of writing SQL statements
• SSAS and MDX
• Reporting services 2005
• Microsoft office package
• SQL, stored procedures, triggers, cursors and general scripting
• SharePoint Performance Point and Power Pivot (advantageous)
• Presentable.
• Pragmatic.
• Perseverant.
• Proactive.
• Planning and organising.
• Must be individually driven and motivated.
• Must be reliable and responsible.
• Must be enthusiastic.

• Strong analytical and…