Junior Data Analyst

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.

• Full Time
• New York
• Posted 5 days ago

NY

$70-80k

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.

• 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 Git Hub 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.

• 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.

• 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.

• 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.

• 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.

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.

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.

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.