Cognos BI Developer - Senior Associate

Line of Service

Advisory

Industry/Sector

Not Applicable

Specialism

Product Innovation

Management Level

Senior Associate

Job Description & Summary

At PwC, our people in data and analytics engineering focus on leveraging advanced technologies and techniques to design and develop robust data solutions for clients. They play a crucial role in transforming raw data into actionable insights, enabling informed decision-making and driving business growth.

In data engineering at PwC, you will focus on designing and building data infrastructure and systems to enable efficient data processing and analysis. You will be responsible for developing and implementing data pipelines, data integration, and data transformation solutions.

Focused on relationships, you are building meaningful client connections, and learning how to manage and inspire others. Navigating increasingly complex situations, you are growing your personal brand, deepening technical expertise and awareness of your strengths. You are expected to anticipate the needs of your teams and clients, and to deliver quality. Embracing increased ambiguity, you are comfortable when the path forward isn’t clear, you ask questions, and you use these moments as opportunities to grow.

Examples of the skills, knowledge, and experiences you need to lead and deliver value at this level include but are not limited to:

• Respond effectively to the diverse perspectives, needs, and feelings of others.
• Use a broad range of tools, methodologies and techniques to generate new ideas and solve problems.
• Use critical thinking to break down complex concepts.
• Understand the broader objectives of your project or role and how your work fits into the overall strategy.
• Develop a deeper understanding of the business context and how it is changing.
• Use reflection to develop self awareness, enhance strengths and address development areas.
• Interpret data to inform insights and recommendations.
• Uphold and reinforce professional and technical standards (e.g. refer to specific PwC tax and audit guidance), the Firm's code of conduct, and independence requirements.

Experience: Sr. Associate (5+ Years) Associate (3+ years)

Minimum Degree Required: Bachelor's degree in Engineering

Responsibilities The Cognos BI Developer will play a pivotal role in the migration of the Enterprise Data Warehouse (EDW) from Teradata to Google BigQuery. This role involves transitioning existing Cognos reports and dashboards, ensuring their functionality and performance in the new environment, and supporting the overall migration process.

Required Skills and Qualifications:

· Strong experience with IBM Cognos Analytics, including Report Studio, Framework Manager, and Query Studio.

· Proficiency in SQL and experience working with Teradata.

· Hands-on experience with Google BigQuery, including data loading, querying, and optimization.

· Familiarity with ETL processes and data integration tools.

· Understanding of data warehousing concepts, architectures, and best practices.

· Familiarity with scripting languages (Python, Shell scripting) is a plus.

Preferred Knowledge/Skills

· Prior experience in migrating Enterprise Data Warehouses from Teradata to Google BigQuery.

· Experience with other Business Intelligence tools and platforms.

· Knowledge of cloud computing and related services.

· Expertise in tracing the lineage of an existing collection of Cognos Reports

Education (if blank, degree and/or field of study not specified)

Degrees/Field of Study required:

Degrees/Field of Study preferred:

Certifications (if blank, certifications not specified)

Required Skills

Optional Skills

Accepting Feedback, Accepting Feedback, Active Listening, Agile Scalability, Amazon Web Services (AWS), Analytical Thinking, Apache Hadoop, Azure Data Factory, Communication, Creativity, Data Anonymization, Database Administration, Database Management System (DBMS), Database Optimization, Database Security Best Practices, Data Engineering, Data Engineering Platforms, Data Infrastructure, Data Integration, Data Lake, Data Modeling, Data Pipeline, Data Quality, Data Transformation, Data Validation {+ 18 more}

Desired Languages (If blank, desired languages not specified)

Travel Requirements

Not Specified

Available for Work Visa Sponsorship?

No

Government Clearance Required?

No

Job Posting End Date