Writing SQL queries to extract data from various sources
Cleaning, transforming, and validating raw data to ensure accuracy, completeness, and consistency for analysis; creating report and driving resolutions for data quality issues
Performing data wrangling to structure datasets for specific analytical tasks.
Developing data transformation process based on business rules.
Data Analytics and Business Analytics
Analyzing customer profile data, researching business processes and identifying how process and segmentation rules drive customer classifications
Identifying anomalies in customer classifications, inconsistencies in business processes and data; performing deep dive to uncover the root causes
Creating recommendations to address customer profile anomalies and process / data inconsistencies
Reporting And Visualization
Communicating findings, trends, and recommendations to stakeholders through clear presentations and written reports.
Ad-hoc analysis to answer specific business questions from various stake holders
Collaboration And Stakeholder Management
Working closely with business teams to understand their data needs and translate them into analytical requirements.
Presenting findings and insights to management and cross-functional teams to support data-driven decision-making.
CORE COMPETENCIES
Bachelor's degree in Computer Science, Information Systems, or related field.
At least 1-2 years of experience in Excel / or foundation in (pivot tables, advanced formulas, charts).
At least 1-2 years of experience or strong foundation in SQL for macro programming.
At least 1-2 years of experience or strong foundation in Business Analytics, data analytics, financial modeling, business casing, performance reporting.
Solid knowledge in data structure; strong data reconciliation skills; strong data QA skills
Knowledgeable in PowerPoint.
Effective verbal and written communication skills, with the ability to collaborate across cross-functional teams.
Demonstrates strong learning agility with the ability to quickly understand new tools, processes, and business concepts.
Complementary Competencies (Nice-to-have)
Telecom experience will be a bonus if also experienced in other industries.
Salesforce knowledge
Customer analytics experience
Qualifications
Work Conditions
Work Setup: Work From Home
Schedule: 9:00 AM – 6:00 PM EST / 9:00 PM – 6:00 AM Philippine Time during onboarding/training.
Once the resource if fully dependent, he/she will move to Golden Hours which is (4:00 AM – 1:00 PM EST / 4:00 PM – 1 AM Philippine Time).