A well-established pharmaceutical industry has an exciting opportunity for a BI Specialist to join the company.
Main Purpose of Job :
To offer interactive visualisation and advanced analytics capabilities that empower the business to make smarter and real-time decisions.
Key Performance Areas :
Summary
PowerBI development : data processing, modelling, transformation and building visualisations
ETL development using ETL tools and techniques
Developing stored procedures, views, joins, aggregates, temp tables, etc
Understanding and implementing data processing techniques
Understanding and implementing data transformation techniques
Data trouble-shooting (source files, source systems, databases, etc)
Thorough testing of unit and data set groupings is required
Analyse, design and trouble shoot data, visualisations and ETL packages
Building reports, dashboards and other visualisations
Verbally communicate with team members and other stakeholders and present to small groups
Elicit requirements verbally without the benefit of documentation
Detail :
Understand business requirements in BI context and design data models to transform raw data into meaningful insights
Create dashboards and interactive visual reports using Power BI
Identify key performance indicators (KPIs) with clear objectives and consistently monitor those
Analysing data and present data through reports that aid decision-making
Convert business requirements into technical specifications and decide timeline to accomplish
Create relationships between data and develop tabular and other multi-dimensional data models
Chart creation and data documentation explaining algorithms, parameters, models and relations
Design, develop, test and deploy Power BI scripts and perform detailed analytics
Perform DAX queries and functions in Power BI
Analyse current ETL process, define and design new systems
Data warehouse development and work with SSAS, SSIS, and SSRS
Redefine and make technical / strategic changes to enhance existing business Intelligence systems
Create customised charts and custom calculations as per requirements
Design, develop and deploy business intelligence solutions as per needs
Work with users and team members at all levels for performance improvement and suggestions
EDUCATION
Bachelor’s degree in Data Analytics,
Bachelor’s degree with Mathematics and / or Applied Mathematics
EXPERIENCE .
Minimum experience of 2 or 3 years working with BI tools or any data-specific roles.
Must have experience in BI tools, have a sound knowledge of database management, SQL querying, data modelling, data warehousing, business intelligence.
Experience working ERP solutions would be advantageous.
SKILLS AND COMPETENCIES :
Essential
Analytical mindset with a problem-solving approach
MS SQL
Data Processing
Data Transformation
Data Analysis
Testing
BI Support and Analysis
Visualisations
Presentation and Communication
Verbal Requirements Elicitation
Database Management
Advantageous
Documentation
Research and Implementation
C# or similar
Excel
Dimensional Modelling
Stay updated with advancements and best practices in design and development
BEHAVIOURAL QUALITIES :
Attention to detail,
Precise, analytical approach to work tasks.
Working without close supervision.
Meeting deadlines.
Ability to interact with business as well as technical teams
Strong communication and management skills
Ability to learn and respond quickly to the fast-changing business environment
Ability to multitask and excellent interpersonal skills
Ability to work in an agile environment with a focus on continuous improvement
Self-motivated and eager to learn
A team player and able to lead and initiate
DESIRABLE SKILLS AND EXPERIENCE :
Data Analytics :
Be able to see the big picture and communicate insights in layman’s terms to everyone in the organisation
Able to drill-down data and visualise data in the best possible way through charts / reports / dashboards
Software Development Skills :
You don't have to be an expert in software development, but to meet diversified needs, know how to develop a custom BI solution.
It is essential to understand technical aspects as well as software development architecture to transform requirements into technical presence.
