Junior Data Analyst/Analytics Engineer

About the role

The Velocity business unit is a fast-moving, start-up-like organization within the broader PTC ecosystem. We support the Onshape and Arena businesses and own the analytics ecosystem that enables data-driven decision-making. We are hiring a Data Analyst/Analytics Engineer who is both business-savvy and eager to grow their technical analytics skills.

Responsibilities

• Partner with data analysts and stakeholders to translate business questions into clear metrics aligned with GTM objectives
• Deliver actionable, data-driven insights to stakeholders that clearly demonstrate business impact and inform decision-making
• Create, model, and optimize datasets in Amazon Redshift to support analytics and reporting use cases
• Design, build, and maintain scalable and reliable data pipelines for ingesting, transforming, and storing data using Python and Apache Airflow
• Monitor, troubleshoot, and optimize data pipelines to ensure data quality, performance, and reliability
• Contribute to data quality initiatives, including validation, testing, and automation
• Participate in code reviews and follow established engineering best practices

Requirements

• Bachelor’s degree (or equivalent experience) in Data Engineering, Computer Science, Mathematics, Statistics, Engineering, or a related field
• Experience building dashboards in Looker or other business intelligence tools
• Experience using SQL for querying data, building data models, and implementing transformation logic
• Strong analytical, problem-solving, and communication skills
• Professional experience in data engineering, software engineering, analytics engineering, or a related role (internship or co-op experience included)
• Exposure to Python, particularly for data processing or pipeline development

Nice to Have

• Experience with CI/CD tools such as GitHub Actions, Bitbucket Pipelines, or similar
• Experience deploying, monitoring, and maintaining ETL applications or services in AWS
• Familiarity with Jira or similar agile project management tools
• Experience or familiarity with Apache Airflow or other workflow orchestration tools
• Exposure to Amazon Redshift or similar cloud data warehouse technologies
• Familiarity with Git-based source control and collaborative development workflows

Additional Requirements

• Comfortable engaging with business and non-technical stakeholders to understand requirements and use cases, with support from Data Analysts
• Clearly explain code, data models, and technical decisions
• Willingness to learn data engineering architecture and best practices
• Strong collaboration skills and comfort working in a hybrid, team-oriented environment
• Attention to code quality, maintainability, and long-term scalability