IBM Cognos Architect / Data Engineering Lead

Purple Drive
Boston, MA

We are looking for a senior IBM Cognos Architect with strong Data Engineering expertise to design, develop, and modernize enterprise data and BI platforms. The ideal candidate will have deep experience in Cognos Analytics, Framework Manager, DataStage, and PL/SQL , along with exposure to modern data platforms such as Databricks and Apache Spark .

This role requires a blend of architecture, hands-on development, and leadership , especially within large-scale BFSI data environments .

Key Responsibilities

1. Architecture & Design

  • Lead enterprise BI and data warehousing architecture using IBM Cognos & DataStage
  • Design and implement scalable data models using Cognos Framework Manager (FM)
  • Define data architecture standards, governance, and best practices
  • Translate business reporting requirements into robust technical solutions
  • Drive data strategy and modernization roadmap

2. Cognos Development & Reporting

  • Architect and develop complex reports, dashboards, and packages in Cognos Analytics
  • Optimize query performance and report execution for large datasets
  • Ensure data accuracy, consistency, and reporting layer integrity
  • Implement reusable frameworks and semantic layers

⚙️ 3. Data Engineering (ETL & Database)

  • Design and develop ETL pipelines using IBM DataStage
  • Develop and optimize PL/SQL procedures, functions, and queries
  • Enable seamless data integration across multiple systems
  • Ensure data quality, validation, and transformation accuracy

☁️ 4. Modern Data Platform Integration

  • Contribute to data modernization initiatives using:
    • Databricks
    • Apache Spark (Scala / PySpark)
  • Integrate legacy BI platforms with cloud/big data ecosystems
  • Enable hybrid architectures (on-prem + cloud)
  • Support migration strategies from traditional BI to modern stacks

5. Performance & Optimization

  • Identify and resolve ETL and reporting performance bottlenecks
  • Implement performance tuning strategies across:
    • Cognos
    • DataStage
    • Databases
  • Drive automation, efficiency, and scalability improvements

6. Leadership & Stakeholder Management

  • Collaborate with business, data, and engineering teams
  • Lead technical design discussions and architecture reviews
  • Mentor junior developers and guide delivery teams
  • Participate in governance, compliance, and solution approval processes

Required Skills (ATS-Optimized)

Primary Skills

  • IBM Cognos Analytics (Advanced)
  • Cognos Framework Manager (FM)
  • IBM InfoSphere DataStage (ETL Design & Optimization)
  • Advanced PL/SQL programming
  • Data Warehousing & BI Architecture
  • Dimensional Modeling (Star/Snowflake Schemas)

Secondary / Good-to-Have

  • Databricks platform
  • Apache Spark (Scala / PySpark)
  • Cloud platforms (Azure / AWS / GCP)
  • Data integration with hybrid ecosystems
Posted 2026-06-15

Recommended Jobs

Manager, Salesforce Targeting & Engagement Analytics

Takeda Pharmaceutical
Boston, MA

By clicking the “Apply” button, I understand that my employment application process with Takeda will commence and that the information I provide in my application will be processed in line with Taked…

View Details
Posted 2026-06-06

Manager, Drug Product

Rhythm Pharmaceuticals
Boston, MA

Job Description Job Description Company Overview Rhythm is a global, commercial-stage biopharmaceutical company committed to transforming the lives of patients and their families living with r…

View Details
Posted 2026-05-30

Shift Lead

Pavement Coffeehouse
Boston, MA

Job Description Job Description At Pavement Coffeehouse, a Shift Lead is someone who is passionate about leading a team. They leverage their knowledge about the craft of coffee & food, build stro…

View Details
Posted 2026-06-13

Physical Therapist Assistant

Bay State Physical Therapy
Brockton, MA

Job Description Job Description Bay State Physical Therapy, a leading provider of outpatient physical therapy in the Northeast, is seeking passionate Physical Therapist Assistants to join our tea…

View Details
Posted 2026-04-04

Opener AM Daytime Team Member

Chick-fil-A Dedham
Dedham, MA

Benefits: ~Employee discounts ~Flexible schedule ~Opportunity for advancement ~Training & development Who We Are: One of the fastest-growing quick-service restaurants in the country Industry …

View Details
Posted 2026-05-27

Assistant Project Manager - Traffic Engineering

Bowman Consulting Group, Ltd.
Boston, MA

Short Description: Bowman has an opportunity for an Assistant Project Manager - Traffic Engineering to join our team. The position is flexible to be based out of Boston, MA - Taunton, MA or Westfield…

View Details
Posted 2025-06-23

Primary Care Physician

Bookmark Medical
Newton, MA

Internal Medicine Physician (MD / DO) Family Medicine Physician (MD / DO) Bring your expertise to a team that values collaboration, embraces innovation, and makes patient care feel personal again. …

View Details
Posted 2026-06-15

2026 GAC Travel Scholarship

QuantCo
Boston, MA

Job Description Job Description QuantCo is offering up to seven travel scholarships for students at German universities to attend the 2026 German American Conference (GAC) presented by students a…

View Details
Posted 2026-05-17

Private Soccer Coach

Dribbler LLC
Springfield, MA

Join Dribbler Soccer: Transform Your Passion for Soccer Into a Rewarding Career! Dribbler Soccer is a leading name in private soccer training across the United States. We’re expanding our team a…

View Details
Posted 2026-05-09

Stylist - PT - Wrentham Outlet - US

ALLSAINTS
Wrentham, MA

Stylist - PT - Wrentham Outlet Wrentham, Massachusetts, United States THE ALLSAINTS TEAM At AllSaints we are in the business of feelings - making our customers feel cool and con…

View Details
Posted 2025-11-13