Junior Data Analyst/Analytics Engineer

PTC is a leading company that brings the physical and digital worlds together through innovative software solutions. They are seeking a Junior Data Analyst/Analytics Engineer to support business stakeholders by building and maintaining reporting and analytics solutions, creating complex data models, and developing data pipeline integrations.

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
• Build, 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

Skills

• 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
• Ability to operate in a stakeholder-facing environment, translating business requirements into technical specifications
• 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
• Comfortable engaging with business and non-technical stakeholders to understand requirements and use cases, with support from Data Analysts
• Ability to 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
• Candidates must be authorized to work in the U.S. without current or future employer-sponsored visa support (including H-1B)
• 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
• Hands-on experience building or supporting data pipelines
• 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

Benefits

• A performance-based bonus
• Employees also have the opportunity to become a PTC shareholder through our employee share purchase program (ESPP), which allows for the purchase of discounted PTC stock.
• Certain roles may also be eligible for participation in our equity programs.
• Employees may be eligible for medical, dental and vision insurance
• Paid time off and sick leave
• Tuition reimbursement
• 401(k) contributions and employer match
• Flexible spending accounts
• Life insurance
• Disability coverage
• If you are an office-assigned employee, a generous commuter subsidy

Company Overview