JUNIOR DATA ANALYST

Location: NY

Salary: $70-80k

POSITION SUMMARY

The Junior Data Analyst supports the Analytics team by helping build accurate, repeatable reporting and data processes. The individual uses SQL, Python, and version-control tools to maintain and improve reports, dashboards, data feeds, quality-assurance processes, and analytical workflows.

The successful candidate does not need extensive professional experience, but should demonstrate strong problem-solving ability, technical curiosity, and practical SQL and Python experience gained through work, internships, academic projects, bootcamps, portfolio projects, or self-directed learning.

This role is ideal for an early-career technical analyst who is curious, detail-oriented, and interested in using code to solve business problems. The role combines hands-on data work with business-facing reporting and insight generation across offline and online marketing programs.

KEY RESPONSIBILITIES

Reporting and Dashboards

  • Maintain, improve, and automate recurring business, marketing, and client-facing reports, dashboards, and data feeds.
  • Use SQL and Python to improve reporting accuracy, reduce manual work, and create repeatable analytical workflows.
  • Ensure reports are accurate, consistent, and delivered on time according to established schedules and ad hoc needs.
  • Use GitHub to manage code, track changes, and collaborate with the Analytics team.
  • Partner with internal stakeholders to understand reporting requirements and translate them into repeatable reporting solutions.
  • Investigate data patterns, variances, and anomalies, and communicate findings to internal stakeholders.

Campaign Data Support

  • Support outbound marketing campaigns by developing and validating SQL-based audience and prospect selection routines in partnership with marketing stakeholders.
  • Ensure audience selections align with defined business rules, campaign objectives, and data quality standards.

Data Quality and Platform Support

  • Perform routine data validation, quality assurance, and maintenance of reporting datasets and platforms.
  • Build or improve quality-assurance checks that identify missing data, unexpected changes, outliers, and inconsistencies.
  • Identify data issues, investigate root causes, and collaborate with internal teams to resolve them.
  • Work within a cloud-based analytics environment to support automated reporting and data workflows.

EXPERIENCE AND SKILLS REQUIRED 

  • BA or BS in a quantitative, technical, or related field, or equivalent practical experience.
  • 0 to 2 years of experience in a data, analytics, reporting, business intelligence, or technical project environment. Internship, academic, bootcamp, portfolio, or self-directed project experience will be considered.
  • Practical SQL proficiency, including querying, joining, filtering, aggregating, validating, and troubleshooting data.
  • Python experience used for data analysis, reporting automation, and workflow support.
  • Strong quantitative and problem-solving skills with attention to detail.
  • Ability to translate data into meaningful business insights.
  • Clear written and verbal communication skills.
  • Ability to manage multiple priorities and work independently in a fast-paced environment.

 ADDITIONAL QUALIFICATIONS 

  • Understanding of cloud-based data environments, including AWS services such as S3, Lambda, and Athena, is a plus.
  • Familiarity with AI-assisted coding or analytics tools, including the ability to validate generated work, is a plus.
  • Familiarity with Git or another version-control system through professional, academic, or personal projects is a plus.
  • Experience writing SQL to support marketing audience selection, segmentation, or targeting workflows is a plus.
  • Experience in the publishing or media industry is a plus.

LOCATION AND WORK ARRANGEMENT

 This position is primarily remote. The Junior Data Analyst is expected to work from the New York office 2 to 3 times per month on a preset schedule.

COMPENSATION

 The anticipated base salary range for this position is $70,000 to $80,000 annually. Actual compensation within the range will be based on relevant experience, skills, and qualifications.

WORK AUTHORIZATION

 Applicants must be legally authorized to work in the United States. PWX Solutions does not provide employment visa sponsorship for this position and is not currently enrolled in E-Verify.

To apply for this job email your details to amanda.maguire@pwxsolutions.com

Strategic Planning

Any new client relationship begins with a comprehensive review of your current business, pinpointing immediate needs, challenges, and goals. We study your recent successes and obstacles, identify methods to best meet your objectives, and then rigorously test those assumptions. Once clear goals have been outlined, we create a customized plan and regularly review progress to ensure we remain on target.

Strategic planning may include the following:

  • SWOT Analysis
  • Annual Review of Goals and Objectives
  • Predictive Modeling
  • Budgets and Financial Planning
  • Test Planning and Evaluation
  • Research and Competitive Analysis

Acquisition and Retention

At PWX Solutions, we understand the multi-faceted approach needed for an effective and comprehensive marketing strategy. For maximum success and revenue growth, we focus on both new business acquisition and retention marketing to help our clients reach profitability and longevity.

Driving New Business

New business acquisition is key for growing and maintaining your business. From the top of the acquisition funnel, we assist clients with identifying their target audiences, communicating effectively to prospects, and converting those prospects into paid customers or donors. Investing in a robust new business strategy will ultimately pay off over time, leading to increased ROI and profitability.

Maximizing Customer Retention

While new business feeds the funnel, a solid retention strategy is essential for revenue growth. Strong retention rates indicate satisfied customers, which is always our goal! Nurturing and engaging with existing customers is vital – replacing a customer is much more costly than keeping an existing one – and thus contributes to long-term profitability. Our marketers are experts at managing subscription and membership businesses, optimizing retention rates and maximizing overall net revenue.

Multi-Channel Marketing

A comprehensive marketing plan includes outreach across numerous channels to achieve the greatest possible results. We understand every client’s needs differ and provide customized offerings. PWX Solutions draws from expertise across digital and brick-and-mortar channels to recommend tactics to help clients exceed their goals. A staff of 150+ experts are organized by function and collaborate to deliver results. Our long-standing relationships with top vendors enable us to negotiate favorable pricing and bring best-in-class services, systems and processes to our clients.

Digital Marketing Solutions:

  • Website Optimization
  • Email Marketing
  • Social Media Marketing
  • Audience Development
  • Email Acquisition
  • Search Engine Marketing & Display
  • Paywalls / Content Monetization
  • eCommerce
  • Digital Partner Collaboration (Amazon, Apple, etc)

Offline Marketing Channels:

  • Direct Mail
  • Retail Sales / Distribution
  • 3rd Party Partnerships
  • TV and Video Advertising
  • Telemarketing

Marketing Operations:

  • Payment and Billing Optimization
  • Automatic Renewal
  • Vendor Relationships & Management
  • Service Selection and RFPs
  • Customer Service

Insights and Analytics

At PWX Solutions, we believe in collecting comprehensive data to inform our marketing campaigns, which contributes to their effectiveness. We provide clients with a suite of reports that helps them to track performance. Reports are customized to meet a client’s needs and objectives, and can be viewed, downloaded or emailed via our private client website.

We regularly review promotion reports – as well as daily/weekly campaign and source performance – for ways to optimize response. With an eye on the competition and industry trends, we execute regular testing to maximize P&L potential. We continually evaluate the long-term profitability of each source to ensure every marketing tactic we employ is making a valuable contribution toward a client’s objectives and bottom line.

Insights and Analytics may include the following:

  • Comprehensive Reporting/Analytics
  • Sophisticated Financial Modeling
  • Competitive Research
  • Price Optimization
  • Lifetime Value Analysis
  • P&L Management

ONLINE ORDER FORM OPTIMIZATION

CLIENT: LEADING SCIENTIFIC AND EDUCATIONAL NON-PROFIT AND MEDIA ORGANIZATION

Better UX Improved Customer Experience - and Reduced Costs


Objective:
Optimize online subscription order pages across marketing channels.

Challenge:

  • Layout of existing order pages limited the number of offers/options and the user journey spread across multiple pages.
  • Client wanted increased flexibility for updating marketing messaging and legal disclosures.
  • Alternative payment options were not available.

Solution:

  • Designed new order page that clearly displayed the specific benefits of each offer in a user-friendly format.
  • Consolidated regional offers/types of orders within the same page to avoid users having to navigate between pages.
  • Redesigned order flow to include alternative payment options seamlessly.
  • Created the ability to incorporate updates and toggle dynamically based on type of offer or other business need.

Results:

  • Improved user experience by creating an all-in-one shop that the client desired.
  • Reduced cost for future maintenance and changes in content/offers; after testing changes rolled out to the client’s other brands.

RENEWAL REVENUE OPTIMIZATION

CLIENT: ICONIC MUSIC AND LIFESTYLE MEDIA BRAND

Model Increased Consumer Revenue more than 30%

 
Objective:
Generate additional revenue from existing customer base.

Challenge:

  • Introduce new, higher prices to support a premium product while limiting the number of customers lost.
  • Maximize the revenue on an individual basis, not by source of business/length of time as customer.

Solution:

  • Created and tested a scalable price structure to build a sample set of data.
  • Built a model to identify individuals who will likely support higher renewal prices.
  • Allowed the model to assign prices based on model score (not previous source of business).
  • Tested the model’s success in generating higher renewal prices while minimizing customer churn.

Results:

  • Identified individuals who were price insensitive.
  • Increased average price up to 33%.
  • Improved total revenue more than 30%.
  • Determined the optimal balance of increased price and minimal churn.

DIRECT MAIL PACKAGE OPTIMIZATION

CLIENT: GLOBAL MEDIA BRAND THAT CELEBRATES ENTREPRENEURIAL CAPITALISM

Saved $50k Annually with Direct Mail Best Practices

 
Objective:
Identify expense savings in direct mail program.

Challenge:

  • Client has mailed out an effective acquisition piece for more than ten years. Despite continual testing, it could not be beat.
  • Control package was expensive: a 6×9 envelope with a label and the contents of the package included a personalized order form that required a mail match process to include the correct form with addressing on the envelope.

Solution:
Developed testing that resulted in winner using standard practices to create more traditional business envelope size mail piece that improved or maintained response in the various offers mailed.

Results:

    Created new package that greatly reduced costs two-fold:

  • Simplified mail production process
  • Printed less expensive new mail piece

    • Recurring annual savings: $50k+

PAID SEARCH/SOCIAL

CLIENT: INDEPENDENT REGIONAL MEDIA COMPANY

Introduced SEM and Social for 43% Increase in Online Revenue

 
Objective:
Invest in new online channels that renew automatically to add to long term revenue growth. Diversify source mix to reduce reliance on direct mail.

Challenge:
In recent years, significant focus was placed on optimizing website and email channels to drive incremental new business.
Based on the success of existing web channels and automatic renewals, client was interested in expanding to paid social and SEM to increase online-generated subscriptions.

Solution:

    Launched offers in both channels with extensive testing and monitoring:

  • Optimized price point and varied premium offers for specific audience targets
  • Tested creative to increase conversions, stay up-to-date with seasonality and match product’s social branding
  • Adjusted bidding strategies to drive spend or reduce budget as needed to maximize ROI

    • Based on successful results, expanded SEM and Social promotions to another brand in client’s portfolio.

Results:

  • Generated over 17,000 new subs from search and social promotions to date.
  • Primary product offer increased revenue from online sources 46% in 2 years, due to the addition of new channels.
  • For the second product introduced, both SEM and Facebook generated profitable subscriptions in year 1, with significant profit growth projected as customers renew.

SEARCH ENGINE MARKETING

CLIENT: MULTI-CHANNEL CONTENT PROVIDER FOR DESIGN OBSESSED AUDIENCE

Lowered CPA 20% in Search Engine Marketing

 
Objective:
Find new business subscribers within the target CPA through SEM. Utilize Google’s advertising platforms to drive magazine subscriptions.

Challenge:
Client needed to strengthen their marketing tactics in order to increase market share among a growing list of competitors.

Solution:

  • Initiated SEM to increase digital marketing presence.
  • After discovering which keywords and terms were most profitable, created multiple separate campaigns to further optimize results.
  • Established appropriate cost per acquisition goals and efficiently divided the budget to target the most relevant traffic to the most profitable areas of the business.

Results:

    Achieved positive results over first 12 months:

  • 130% higher click to conversion rate compared to Googles benchmarks
  • 20% lower cost per acquisition than target
  • 3% higher average order value

    • Increased SEM budget in accordance with ROI and continued to experience exceptionally positive results.