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.
Our 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 – all while seeing their ideas come to life and celebrating the differences that make us who we are and the work we do possible.
The Cognos BI Analyst is responsible for ensuring reports, analysis, and dashboards are shared with respective stakeholders, using intelligence tools such as IBM Cognos, SQL and PLSQL. Must have experience in connecting, cleansing and blending data within an ETL or SQL environment.
Job Description
- Design and develop BI solution including reports, visualizations, cubes, and metadata models using Cognos Analytics.
- Develop Business Intelligence (BI) reports from discovery through deployment
- Must have prior experience in Pentaho and ETL development
- Creates databases and schema objects including tables, indexes, stored procedures, and functions as a part of ETL Design
- Design and Develop dashboards and drill-through reports using Cognos
- Troubleshoot and provide recommend solutions for optimized design techniques to build dashboards and reports using Cognos 12, Cognos Framework Manager, Unix Script/ Cognos SDK
- Analyze and refine business requirements to translate them into detail design specifications and build analytical reports and dashboards.
- Develop complex SQL Programs and database procedures using PL/SQL, and database queries using relevant tools
- Expert knowledge in SQL skills including stored procedure, trigger, index etc.
- Create Dashboards and reports in IBM Cognos.
- Identify issues and optimize reports performance using IBM Cognos, BIRT and related tools
- Automate report schedules using UNIX and Shell Script.
- Ability to support Adhoc Requests
Additional Job Description:
- Must be detail-oriented with strong mathematical and written abilities
- Ability to communicate effectively to department teams, cross-functional partners, and upper management
- Exceptional planning skills with the ability to adapt to a rapidly changing environment
- Must be able to prioritize work and manage time effectively
- Understand the business operations and principles of retail business management
- Must convey information clearly and concisely
- Must be able to work effectively in teams and make meaningful and relevant contributions
Life at PTC is about more than working with today’s most cutting-edge technologies to transform the physical world. It’s about showing up as you are and working alongside some of today’s most talented industry leaders to transform the world around you.
If you share our passion for problem-solving through innovation, you’ll likely become just as passionate about the PTC experience as we are. Are you ready to explore your next career move with us?
We 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."
Skills Required
- Experience designing and developing reports, dashboards, cubes, and metadata models using Cognos Analytics/Cognos 12
- Experience with Cognos Framework Manager and Cognos SDK
- Strong SQL and PL/SQL skills, including stored procedures, triggers, indexes, and complex queries
- Prior experience in Pentaho and ETL development
- Create databases and schema objects (tables, indexes, stored procedures, functions) as part of ETL design
- Design and develop dashboards and drill-through reports in IBM Cognos
- Troubleshoot and optimize report/dashboard performance using IBM Cognos and BIRT
- Automate report schedules using UNIX or shell scripts
- Experience connecting, cleansing, and blending data within an ETL or SQL environment
- Ability to support ad-hoc reporting requests and communicate effectively with cross-functional teams
- Understanding of retail business operations and principles
PTC Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about PTC and has not been reviewed or approved by PTC.
-
Strong & Reliable Incentives — Bonuses are routinely part of offers and widely expected, providing predictable variable pay. This consistency helps bolster total compensation beyond base salary.
-
Leave & Time Off Breadth — PTO is portrayed as generous and is complemented by flexible work arrangements. Additional paid volunteer time broadens time-away options.
-
Equity Value & Accessibility — Accessible equity through ESPP and RSUs is available for many roles, adding meaningful long-term value. This ownership upside strengthens overall total compensation, particularly in higher-level roles.
PTC Insights
What We Do
PTC (NASDAQ: PTC) unleashes industrial innovation with award-winning, market-proven solutions that enable companies to differentiate their products and services, improve operational excellence, and increase workforce productivity. With PTC, and its partner ecosystem, manufacturers can capitalize on the promise of today’s new technology to drive digital transformation.
