> Markdown version of [/jobs/ext/1447837-junior-data-analyst](https://www.wearedevelopers.com/jobs/ext/1447837-junior-data-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Junior Data Analyst - **Company:** PWX Solutions - **Location:** New York, NY, United States (Remote available) - **Experience:** Starter - **Salary:** $70,000.0 - $80,000.0 - **Contract:** Internship / Graduate position - **Skills:** Artificial Intelligence, Amazon Web Services, Amazon S3, Data Analysis, Cloud Computing, Cloud Database, Data Validation, Database Queries, Github, Revision Control Systems, Python (Programming Language), SQL Databases, Git, Tools for Reporting, Software Version Control - **Published:** July 26, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=6a4f557a975d7ec9 ## About the Role 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., * 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. ## Description 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. ## Related Videos - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Innovating Developer Tools with AI: Insights from GitHub Next](https://www.wearedevelopers.com/videos/1268-innovating-developer-tools-with-ai-insights-from-github-next) - [WeAreDevelopers LIVE - CSS is DOOMed](https://www.wearedevelopers.com/videos/1838-wearedevelopers-live-css-is-doomed) - [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail) - [Git for Code Reviews](https://www.wearedevelopers.com/videos/429-git-for-code-reviews) - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Dev Digest 120 - Apple and peers](https://www.wearedevelopers.com/magazine/455-dev-digest-120-apple-and-peers) - [Dev Digest 121 - AI goes offline](https://www.wearedevelopers.com/magazine/456-dev-digest-121-ai-goes-offline)