Our world is transforming, and PTC is leading the way. Our software brings the physical and digital worlds together, enabling companies to improve operations, create better products, and empower people in all aspects of their business. \n\nOur people make all the difference in our success.
Today, we are a global team of nearly 7,000 and our main objective is to create opportunities for our team members to explore, learn, and grow \u2013 all while seeing their ideas come to life and celebrating the differences that make us who we are and the work we do possible. \n\nAs a Data Warehouse Engineer, you will support the modeling, development, optimization, and automation of the CDOPS data warehouse. You will help ensure that our Business Intelligence (BI) teams have access to accurate, high-quality data that drives informed decision-making across the organization.\n\n
This role is ideal for someone early in their data engineering career who is eager to learn modern data modeling techniques, work with cloud data platforms, and contribute to improving data delivery processes in a dynamic environment.\n\nYou will collaborate with infrastructure developers, data engineers, BI developers, product owners, and data analysts across the organization. With guidance and mentorship, you\u2019ll help maintain the Snowflake data warehouse, contribute to an efficient data architecture, and support data integrity, performance, and cost-effectiveness.
\n\nYou will also gain experience following data warehousing and ETL best practices, documenting data models and processes, and learning how to maintain high standards of data quality. Staying curious and keeping up with industry trends will help ensure our data platform continues to evolve and improve.\n\nDay-to-Day Responsibilities\n\n
Data Modeling \u0026 Warehousing\n\n\u00b7 Support the development of dimensional data models for subject areas such as Technical Support ISO processes \u0026 Knowledge Centric Support, Operational Expenditure, Web Analytics, Data models.\n\n\u00b7 Assist in creating and maintaining ETL pipelines using tools such as DBT, Apache Airflow, and GitLab.
\n\n\u00b7 Help manage Snowflake data warehouse assets and learn to optimize storage and compute usage using tools like Terraform\n\n\u00b7 Participate in implementing data storage and transformation solutions in Snowflake.\n\n\u00b7 Contribute to the development of AI/BI products\n\nCollaboration \u0026 Support\n\n\u00b7 Work with BI developers to provide data sets (Business Data Marts) for analytics use cases.\n\n\u00b7 Collaborate with cross-functional teams to gather and understand business and data requirements.\n\n\u00b7 Help troubleshoot data warehouse and ETL issues with senior team members.\n\n\u00b7 Contribute to improving the performance and capabilities of the data warehouse.\n\nBest Practices \u0026 Continuous Improvement\n\n\u00b7 Learn and apply data warehousing and ETL best practices.\n\n\u00b7 Assist in documenting data models, processes, and system designs.\n\n\u00b7 Participate in efforts to improve data quality and documentation using tools like DBT and Great Expectations.\n\n\u00b7 Support internal process improvements such as automating manual tasks and optimizing data workflows.\n\n\u00b7 Stay informed about new trends and technologies related to data warehousing and Snowflake.\n\nPreferred Skills \u0026 Knowledge\n\n(You are not expected to be an expert\u2014experience through coursework, internships, or personal projects is welcome.)\n\n\u00b7 Basic understanding of analytical and dimensional modeling concepts.
\n\n\u00b7 Strong SQL fundamentals.\n\n\u00b7 Familiarity with Snowflake or other cloud data warehouse technologies.\n\n\u00b7 Exposure to DBT, Airflow, Git, or Docker is a plus.\n\n\u00b7 Experience with relational database concepts.\n\n\u00b7 Introductory experience with Python for data workflows.\n\n\u00b7 Strong communication skills and willingness to learn in a fast-paced environment.\n\n\u00b7 Organizational skills and a proactive mindset.\n\n\u00b7 Ability to work effectively with cross-functional teams.\n\nPreferred Experience\n\n(Nice to have, not required)\n\n\u00b7 Exposure to SaaS business models.\n\n\u00b7 Experience working in Agile environments.\n\n\u00b7 Familiarity with GitLab CI/CD.\n\n\u00b7 Basic understanding of Terraform or infrastructure-as-code concepts.\n\n\u00b7 Experience using Docker as a development environment.\n\nBasic Qualifications\n\n\u00b7 Bachelor\u2019s degree in Computer Science, Information Systems, Data Engineering, or a related field.\n\n\u00b7 Strong interest in data engineering and cloud data architectures.\n\n\u00b7 English fluency.\n\n\u00b7 Foundational understanding of data systems, ETL concepts, or database design (coursework acceptable).\n\n\u00b7 Internship, academic project, or equivalent experience working with data tools is a plus\n\nLife at PTC is about more than working with today\u2019s most cutting-edge technologies to transform the physical world. It\u2019s about showing up as you are and working alongside some of today\u2019s most talented industry leaders to transform the world around you. \n\nIf you share our passion for problem-solving through innovation, you\u2019ll likely become just as passionate about the PTC experience as we are. Are you ready to explore your next career move with us?\n\nWe respect the privacy rights of individuals and are committed to handling Personal Information responsibly and in accordance with all applicable privacy and data protection laws. Review our Privacy Policy here.\”\n
