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