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