Business Intelligence Developer

Britehouse; Evergreen (AL); On-site; USD 70,000 - 90,000; Full time

Job summary

Britehouse, located in Evergreen, Alabama, is on the lookout for a skilled Data Analyst and Business Intelligence Developer to transform data into actionable insights. The role involves designing and implementing data warehouse solutions using Microsoft SQL Server technologies, ensuring adherence to best practices.

The ideal candidate will possess experience in OLAP cubes and database design, with a strong problem-solving ability. Join us to help drive smarter decision-making and improve product offerings.

Qualifications

• Minimum of 2-5 years SSIS experience.
• Strong experience with OLAP cubes.
• Proficiency in database design, including star schema.

Responsibilities

• Design and deploy data warehouse solutions.
• Translate business requirements into technical specifications.
• Monitor BI performance and troubleshoot issues.

Skills

Analytical problem solving

Team collaboration

SQL proficiency

Data modeling

Report design

Communication skills

Tools

Microsoft SQL Server

SSIS

SSRS

Power BI

Data warehousing

Job description

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.

Key Performance Areas

General

• 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.

Technical

• 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

Functional

• 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

Qualifications and Experience

Junior BI Developers

• 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.

Intermediate and Senior BI Developers

• 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 PerformancePoint and PowerPivot (advantageous)
• Presentable.
• Pragmatic.
• Perseverant.
• Proactive.
• Planning and organising.
• Must be individually driven and motivated.
• Must be reliable and responsible.
• Must be enthusiastic.

Skills

• Strong analytical and problem solving abilities
• Clear and logical thinking
• Team player that is easy to work with and that functions in any size team
• Demonstrates personal motivation and a positive attitude
• Uses initiative, shows determination and commitment to delivery
• Copes under pressure
• Demonstrates resilience
• Facilitation Skills
• Strong work ethic and drive for results
• Values quality and produce high quality work at all times
• Good verbal and written communication skills, including an extensive vocabulary of general language and ICT terminology
• Reliable – ensures that if an assignment is allocated, it will be completed as agreed
• Willing to learn other platforms
• Demonstrates high ethics and adherence to Dimension Data values
• Self‑motivated, with a keen passion to stay ahead of the trends.
• Strong analytical and problem solving abilities
• Clear and logical thinking
• Team player that is easy to work with and that functions in any size team
• Be able to give accurate technical estimates.
• Be able to work in a team environment.
• Be able to interact well with management and colleagues.
• Be able to successfully adapt to changing demands and conditions.