The Antwi Group is seeking an analytical, detail-oriented, curious, and technically capable Data Analyst to join our Data & Business Intelligence Department.
Working under the direction of the Director / Manager of Data & Business Intelligence and Business Intelligence Manager, and collaborating with Senior Data Analysts and Business Intelligence Analysts, the Data Analyst will collect, prepare, validate, analyze, and report business information supporting operations and decision-making across The Antwi Group and its businesses.
The Data Analyst will analyze business performance, identify trends, prepare recurring and ad hoc reports, write analytical queries, validate data, investigate discrepancies, support dashboards, maintain reporting datasets, assist with KPI tracking, and communicate analytical findings to appropriate business stakeholders.
The position may support The Antwi Group’s creative, entertainment, music, media, technology, production, distribution, sales, marketing, customer-service, administrative, and related operations.
This position requires strong analytical thinking, attention to detail, accuracy, problem-solving ability, technical aptitude, business curiosity, communication, organization, integrity, and confidentiality.
Key Responsibilities
- Analyze business and operational data.
- Prepare recurring reports.
- Perform ad hoc analysis.
- Write analytical queries.
- Prepare datasets for analysis.
- Clean and validate data.
- Identify trends and patterns.
- Conduct variance analysis.
- Support KPI reporting.
- Assist with dashboard development.
- Investigate reporting discrepancies.
- Identify data-quality problems.
- Maintain reporting documentation.
- Develop tables, charts, and other visualizations.
- Support forecasting activities.
- Prepare analytical summaries.
- Assist Senior Data Analysts.
- Support Business Intelligence Analysts.
- Maintain assigned reporting schedules.
- Help automate repetitive analytical tasks.
- Respond to approved data requests.
- Protect confidential information.
- Escalate significant data-quality concerns.
- Support continuous improvement of analytical processes.
Analytical Workflow
Assignments may follow:
Business Question → Data → Validation → Analysis → Findings → Communication → Follow-Up
Business Questions
The Data Analyst may help answer questions such as:
- How is performance changing?
- Which products or services are growing?
- Where are operational delays occurring?
- Which customer groups are most active?
- How are campaigns performing?
- What trends are appearing in sales?
- How is project activity changing?
- Where are service issues increasing?
- Which metrics require further investigation?
Data Sources
The Analyst may work with authorized information from:
- CRM systems
- Financial systems
- Marketing platforms
- Website analytics
- Customer-service systems
- Project-management systems
- Production systems
- Distribution platforms
- Operational databases
- Human Resources systems
- Other approved business sources
Data Preparation
Before analysis, the Analyst may:
- Remove appropriate duplicate records from analytical datasets.
- Standardize formats.
- Validate dates.
- Review missing values.
- Correct approved analytical classifications.
- Combine approved datasets.
- Create derived fields.
- Prepare summary tables.
- Document transformations.
Changes to authoritative source records require appropriate authorization.
SQL & Data Queries
Depending on the company’s systems, the Analyst may:
- Write SQL queries.
- Filter records.
- Join tables.
- Aggregate data.
- Create calculations.
- Develop reusable queries.
- Validate query results.
Spreadsheet Analysis
The Analyst may use spreadsheets for:
- Data preparation
- Pivot tables
- Calculations
- Lookups
- Charts
- Variance analysis
- Forecast support
- Quality checks
- Reconciliation
Data Validation
The Analyst should verify:
- Record counts
- Totals
- Date ranges
- Calculations
- Categories
- Relationships
- Filters
- Expected values
Data Quality
Potential problems may include:
- Missing information
- Duplicate records
- Invalid values
- Incorrect classifications
- Inconsistent formats
- Stale information
- Unexpected changes
- Broken relationships
Data Quality Workflow
Issues may follow:
Detection → Validation → Source Identification → Escalation → Correction → Verification
Data Integrity
The Analyst should not modify source information merely to force reports to match expected results.
Discrepancies should be investigated and documented.
KPI Reporting
The Analyst may help maintain standardized KPIs involving:
- Sales
- Marketing
- Customers
- Projects
- Production
- Distribution
- Operations
- Customer service
- Workforce
- Other approved areas
KPI Documentation
Each KPI may identify:
Metric → Definition → Formula → Data Source → Frequency → Owner
Recurring Reports
The Analyst may prepare:
- Daily reports
- Weekly reports
- Monthly reports
- Quarterly reports
- Annual reports
- Other scheduled reporting
Reporting Calendar
Assigned reports should be delivered according to established schedules.
Potential delays should be communicated promptly.
Ad Hoc Analysis
Business leaders may request analysis involving:
- Specific trends
- Performance questions
- Operational problems
- Customer activity
- Projects
- Campaigns
- Production
- Other legitimate business questions
Trend Analysis
The Analyst may compare information across:
- Days
- Weeks
- Months
- Quarters
- Years
- Business units
- Products
- Services
- Channels
- Customer segments
- Territories
- Projects
Variance Analysis
Analysis may compare:
- Current versus prior period
- Actual versus target
- Actual versus budget
- Forecast versus actual
- Business unit versus business unit
- Channel versus channel
- Other approved comparisons
Official budget interpretation remains with Finance & Accounting.
Root-Cause Support
The Analyst may help investigate significant performance changes by:
- Identifying relevant variables.
- Segmenting data.
- Comparing periods.
- Testing potential explanations.
- Presenting supporting information.
The Analyst should avoid presenting correlation as proven causation.
Statistical Analysis
Depending on experience and assignment, analysis may involve:
- Descriptive statistics
- Percentages
- Rates
- Distributions
- Correlations
- Basic regression
- Time-series analysis
- Other appropriate techniques
Forecasting Support
The Analyst may assist with forecasts involving:
- Demand
- Sales
- Revenue
- Customer activity
- Work volume
- Production
- Operational capacity
- Staffing requirements
Official financial forecasts should be coordinated with Finance.
Dashboard Support
The Analyst may support dashboard development by:
- Preparing datasets.
- Creating calculations.
- Validating metrics.
- Building visualizations.
- Testing filters.
- Checking refreshes.
- Investigating discrepancies.
Data Visualization
The Analyst may create:
- Tables
- Scorecards
- Line charts
- Bar charts
- Scatter plots
- Distribution charts
- Maps where appropriate
- Other suitable visualizations
Visualization Standards
Visualizations should:
- Use appropriate scales.
- Clearly identify measures.
- Provide relevant context.
- Avoid misleading presentation.
- Remain understandable to the intended audience.
Sales Analytics
The Analyst may support analysis involving:
- Leads
- Opportunities
- Pipeline
- Conversion
- Sales activity
- Revenue
- Customer segments
- Account activity
Marketing Analytics
The Analyst may support:
- Website traffic
- Campaign performance
- Engagement
- Lead generation
- Conversion
- Acquisition channels
- Audience activity
Customer Analytics
Analysis may include:
- Customer acquisition
- Retention
- Engagement
- Segmentation
- Service usage
- Customer activity
- Support interactions
Customer Service Analytics
Reporting may include:
- Request volume
- Response time
- Resolution time
- Escalations
- Issue categories
- Recurring problems
- Service trends
Project Analytics
The Analyst may support reporting involving:
- Project status
- Milestones
- Schedules
- Completion
- Risks
- Deliverables
- Resource information
Production Analytics
Analysis may include:
- Production volume
- Schedules
- Completion
- Delays
- Capacity
- Resource utilization
- Operational performance
Music & Distribution Analytics
Where applicable, authorized analysis may include:
- Release activity
- Catalog activity
- Distribution activity
- Platform activity
- Territory activity
- Artist or label activity
- Audience trends
- Operational revenue indicators
Official royalty calculations and financial reporting remain with appropriate Finance and business-unit personnel.
Workforce Analytics
Working with Human Resources, authorized aggregated reporting may include:
- Headcount
- Hiring
- Turnover
- Training
- Staffing
- Workforce planning
Individual employee information should remain appropriately restricted.
Financial Analytics
Working with Finance & Accounting, the Analyst may support:
- Revenue trends
- Expense trends
- Budget comparisons
- Business-unit reporting
- Forecast support
- Management analysis
Official accounting records and financial statements remain with Finance.
Operational Analytics
The Analyst may examine:
- Work volume
- Completion rates
- Cycle time
- Error rates
- Service levels
- Capacity
- Resource utilization
- Process performance
Reporting Automation
The Analyst may help automate repetitive:
- Data preparation
- Spreadsheet processes
- Report generation
- Quality checks
- Scheduled calculations
- Other appropriate analytical tasks
Programming
Depending on experience and company systems, the Analyst may use:
- SQL
- Python
- R
- Spreadsheet automation
- BI platform languages
- Other approved analytical tools
Documentation
Analytical work should document, where appropriate:
- Purpose
- Data sources
- Definitions
- Calculations
- Filters
- Assumptions
- Limitations
- Reporting period
Reproducibility
Recurring analysis should be structured so results can be reproduced consistently where practical.
Report Review
Before distributing important reports, the Analyst should check:
- Data
- Calculations
- Labels
- Dates
- Filters
- Totals
- Visualizations
- Written interpretation
Reporting Errors
If an error is discovered after distribution, the Analyst should promptly notify appropriate Data & BI personnel and assist with correction.
Self-Service Analytics Support
The Analyst may help business users understand:
- Standard reports
- Dashboard filters
- KPI definitions
- Refresh schedules
- Appropriate exports
Artificial Intelligence & Analytical Tools
Where approved, the Analyst may use AI-assisted or automated analytical tools to support:
- Data preparation
- Coding assistance
- Classification
- Summarization
- Analytical exploration
Outputs must be appropriately validated before use.
Data Access
The Analyst should access only information necessary for authorized work.
Data Security
The Analyst must not:
- Share credentials.
- Circumvent access controls.
- Store restricted information in unauthorized locations.
- Send confidential datasets to unauthorized recipients.
- Use unapproved external services for restricted information.
Confidentiality
The Data Analyst may encounter:
- Customer information
- Employee information
- Financial information
- Sales information
- Marketing information
- Contracts
- Production information
- Distribution information
- Business plans
- Unreleased projects
Such information must only be accessed, analyzed, and shared for legitimate authorized purposes.
Analytical Integrity
The Data Analyst must not knowingly:
- Fabricate information.
- Manipulate results to support a desired conclusion.
- Conceal material limitations.
- Alter standardized metrics without authorization.
- Present assumptions as facts.
- Misrepresent analytical findings.
Cross-Department Collaboration
Data & Business Intelligence Leadership — priorities, reporting standards, and analytical guidance.
Senior Data Analysts — advanced analytical guidance.
Business Intelligence Analysts — dashboards and reporting solutions.
IT & Digital Systems — databases, integrations, access, and security.
Finance & Accounting — financial analytics.
Sales — commercial analytics.
Marketing — campaign analytics.
Human Resources — authorized workforce analytics.
Operations & Administration — operational analytics.
Project Management — project reporting.
Customer Service & Support — service analytics.
Production & Creative Teams — production reporting.
Business Units — specialized analytical requirements.
Qualifications
- Bachelor’s degree in Data Analytics, Business Analytics, Statistics, Mathematics, Economics, Computer Science, Information Systems, Finance, Engineering, Business Administration, or a related field preferred.
- Relevant professional experience, internships, academic projects, or substantial analytical training may be considered.
- Working knowledge of SQL preferred.
- Strong spreadsheet skills.
- Familiarity with data-visualization or BI tools preferred.
- Strong analytical and problem-solving ability.
- Strong numerical ability.
- Excellent attention to detail.
- Good written and verbal communication.
- Ability to organize and analyze information.
- Ability to learn new analytical tools and systems.
- Strong professional judgment.
- High level of integrity and confidentiality.
Preferred Skills
Experience or training involving any of the following is a plus:
- SQL
- Excel
- Power BI
- Tableau
- Looker
- Python
- R
- Statistics
- Data visualization
- Data cleaning
- Data modeling
- CRM analytics
- Web analytics
- Reporting automation
- Entertainment analytics
- Music analytics
- Media analytics
Professional Expectations
The successful candidate should demonstrate:
- Analytical thinking
- Accuracy
- Curiosity
- Objectivity
- Organization
- Technical aptitude
- Problem solving
- Communication
- Integrity
- Accountability
- Confidentiality
- Strong attention to detail
- Willingness to learn
Career Development
A potential career path may include:
Data Analyst → Senior Data Analyst / Business Intelligence Analyst → Business Intelligence Manager → Director / Manager of Data & Business Intelligence
Employees may also develop toward Data Science, Analytics Engineering, Data Engineering, Data Governance, Advanced Analytics, or Business Strategy.
Location
Poconos, Pennsylvania
The position may involve office-based analytical work and collaboration with teams across company locations and business units.
Projects, system implementations, reporting deadlines, business reviews, or operational requirements may occasionally require travel, evening, weekend, holiday, or irregular-hour availability.
Employment Type
Full Time
Department
Data & Business Intelligence
Reports To
Director / Manager of Data & Business Intelligence / Business Intelligence Manager / Assigned Senior Data & BI Personnel
About The Antwi Group
The Antwi Group is a growing organization operating across creative, entertainment, media, and related business sectors. Our teams bring together creative talent, technical expertise, management, financial discipline, technology, production, operations, and business development to build projects and opportunities designed for long-term growth.
Application
Interested candidates should submit an application outlining their education or training, data-analysis, statistics, reporting, SQL, spreadsheets, visualization, programming, research, business-analysis, or related experience and other relevant qualifications.
Applicants may also be asked to provide a résumé/CV, professional references, and examples or descriptions of analytical projects, reports, dashboards, statistical work, academic projects, or programming work that they are legally permitted to share.
Candidates beginning their professional analytics careers are encouraged to apply if they demonstrate strong analytical ability, accuracy, curiosity, technical aptitude, communication, integrity, attention to detail, and willingness to learn.
Applicants should not submit confidential datasets, proprietary dashboards, source code belonging to another organization, database credentials, customer records, employee information, trade secrets, unreleased financial information, or other confidential materials belonging to current or previous employers, clients, vendors, or business partners.
The Antwi Group is an equal opportunity employer. We consider qualified applicants without regard to characteristics protected by applicable law.