**Insights & Analytics**
Data Gathering
- Extracts/generates quantitative information from a single or multiple tools (Business Intelligence Tools - ie: Power BI, SQL, Azure Data Lake Blob etc) and/or from databases using standard queries
- Communicates with resource person to get input/raw data needed for report generation
- Conducts research to gather qualitative information (sales analysis, competitive product information, industry trends, and product information, financial analysis) from internal & external sources that will be used for analyses
- Configures self-service and automated reporting from available tools - mainly Power Pivot and Power BI
Data Processing
- Combines extracted data from multiple resources using automated tools (excel, macro, database), and/or from different system tools in one single database using queries (SQL, Tableau/Power BI / Power Query) standardize data structure from different data sources
- Cleans extracted data using pre-defined guidelines or instructions
- Formats extracted data based on expected report output (with batching capability and multiple data formatting requirements)
- Calculates data using available fields within the gathered information (basic math and logic)
- Categorizes and segments extracted data using tools to convert data to information relevant to the report (excel, database)
Data Analysis
- Analyzes report requirements from stakeholders.
Identify and provide solution to general inquiries
- Analyzes gathered data using descriptive analytics (basic mathematics & comparative analysis), diagnostic analytics (root cause analysis, gap analysis), predictive and prescriptive analytics (data interpretation, data correlation & statistics)
- Analyzes stakeholder requirements from an existing report and provides improvement and recommendation based on customer request
- Evaluates and customizes reports aligned with customer requirements
Reporting
- Creates specifications for standard report templates as well as dynamic reports aligned with customers' requests
- Conceptualizes report design contents and methodologies based on gathered data and/or analysis for static or dynamic reports
- Provides insights and validates with stakeholders if recommended solutions address business questions and are aligned with the objectives
Data Project Management
- Attends scope reviews to learn what the project request is all about
- Assists end users in gathering, analyzing and clarifying requirements; uses technical knowledge to gauge complexity of the request
**System Support and Maintenance**
System Maintenance
- Implements the basic change request (dashboard enhancements, data source modifications)
- Performs testing of published dashboards
- Monitors errors and data inconsistencies.
- Recommends improvement on change request and processes
Database Maintenance
- Provide corrective actions to business users on improvements to integrity of data at source
Training and Development
- Conducts basic and/or intermediate and comprehensive overview and awareness training on products, processes and/or business tools
- Coaches and Mentors other analysts in a functional/technical capacity of Digital Intelligence
**MINIMUM REQUIREMENTS**
**Education**:University degree (Computer Science, Computer Engineering, Information Technology, Information Systems or similar)
**Job Related Experience**:Minimum of 3 years of experience in data analytics, business intelligence and reports
**Specific Knowledge**:
- Microsoft Office - Power Query, Power Pivot, Power BI
- Data Manipulation & Interpretation
- Database management/maintenance
- Root Cause / Gap Analysis
- Project Management
**Skills**:
- Advanced Microsoft Excel proficiency level 3 (Advanced formula, power pivot tables, VBA Macros, etc.)
- Oral and written communication skills
- Problem solving, decision making and analytical skills
- Presentation skills
- Training skills
- Project Management skills
- Data Storytelling
- Power BI (or similar tools)
- SQL Queries
- Data Warehousing
**Benefits**:
- Health insurance
- Life insurance
- Work from home
Schedule:
- Day shift
- Monday to Friday
Supplemental Pay:
- 13th month salary