Intermediate BI Consultant (3rd Party)

Job Title:           Intermediate BI Consultant

Reports to:       Practice Head Data & Analytics

ROLE OVERVIEW

The successful individual would be responsible for using data to determine market and business trends for companies to increase profitability and efficiency.

KNOWLEDGE AND SKILLS

• BI Knowledge: Practical work knowledge of SSRS, SSIS, SSAS, Power BI, ETL/DI design and implementation
• Practical Work experience within AZURE, specific to BI and Data analytics
• Development Knowledge: SQL Server 2012, T-SQL, MDX, ETL, Cube Development, OLAP
• Technical Skills: use complex computer programs to mine data sources and look for trends
• Analytical Skills: determine what data trends mean. Being able to analyze the data is crucial
• Communication Skills: Once the data is analyzed, communicate findings to the line manager or client
• Problem-Solving: look at the data trends and recommend solutions for creating more revenue and reducing loss
• Presentation skills: A proven track record of presenting and persuading both clients and peers
• Technology Trends: Aware of advanced BI concepts such as predictive analytics, AI and IOT with a desire to experiment with them
• Time Management: the ability to work on large projects and many data streams and many deadlines. Being able to “juggle it all” is crucial to the job

MINIMUM EXPERIENCE:

• 5 - 7 years’ experience in BI and Data Analytics
• Preferably in a consulting, banking, insurance & telecoms industry

CORE COMPETENCIES (TECHNICAL):

• Develop SSRS reports
• Develop Power BI reports and Dashboards
• Develop SSIS and\or Data Factory Packages
• Design and Maintain a data warehouse
• Write, test, and trouble-shoot SQL code
• Design tables, stored procedures, views and functions
• Complete SQL query performance optimization
• Ensure that development standards and processes are adhered to
• Create analytical solutions using Microsoft Excel
• Work with large SQL data sets

FUNDAMENTAL COMPETENCIES:

• Strong written and oral communication skills
• Creative eye for details
• Positive attitude
• Able to multitask effectively
• Display excellent time management, task planning and prioritization skills
• Able to adapt quickly to changing client requirements
• Able to work effectively with minimal supervision
• Work under pressure

 

 

MINIMUM EDUCATION:

• A formal tertiary qualification in a field relevant to BI and Data Analytics
• Microsoft MCSE is highly favoured, if not yet obtained, a commitment in obtaining this certification is required