Job Purpose:
The Data Analyst is responsible for analysing and interpreting large sets of data from various sources for extracting insights and document source to target mappings for BI Solutions.
The successful candidate will work closely with cross-functional teams to document PLSQL queries from schemas, facts and dimensional data structures for a BI Portal Migration project.
Key Responsibilities:
Collect, analyse, and interpret complex data sets by examining PLSQL queries from an Oracle Data warehouse
Document source to target mappings and create specifications for migration team
Collaborate with cross-functional teams to support the development and implementation of data-driven strategies
Collaborate with business stakeholders to document meta data and business definitions for report metrics
Create and maintain documentation of data processes, data dictionaries, and data analysis reports
Requirements:
Senior Oracle professional with Data warehouse background
Proven experience in data analysis and source to target mappings
Excellent analytical and problem-solving skills, with the ability to work with large and complex data sets.
Strong communication and interpersonal skills, with the ability to present complex data and analysis to non-technical stakeholders.
Proficiency in Oracle PLSQL, Excel.
Experience with data visualization tools such as PowerBI is a plus.
Knowledge of database management systems and data warehousing concepts.
Ability to work independently and manage multiple projects tasks simultaneously.
Skills Required
- Senior Oracle professional with data warehouse background
- Proven experience in data analysis and source-to-target mappings
- Proficiency in Oracle PL/SQL
- Proficiency in Microsoft Excel
- Knowledge of database management systems and data warehousing concepts
- Excellent analytical and problem-solving skills with ability to work with large complex data sets
- Strong communication and interpersonal skills to present analysis to non-technical stakeholders
- Ability to work independently and manage multiple project tasks simultaneously
- Experience with data visualization tools such as Power BI
What We Do
Our vision is to offer the best in class digital solutions and technology services to organizations, big or small. To achieve this, we created a specialized team with a deep understanding of business domains and digital technologies to assist organizations in accelerating their “Digital Transformation” by leveraging the power of Analytics & AI. Our focus is to help customers stay ahead of the curve from their competitors, to help them be leaders in their respective areas, and to be able to assist them in making the right decision for their businesses with the help of data at hand
