IBM Cognos Architect / Data Engineering Lead
Purple Drive Technologies LLC
Boston, MA (In Person)
Full-Time
Skill Insights
Compare your current skills to what this opportunity needs—we'll show you what you already have and what could strengthen your application.
Job Description
a { text-decoration: none; color: #464feb; } tr th, tr td { border: 1px solid #e6e6e6; } tr th { background-color: #f5f5f5; } 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 / Google Cloud Platform) Data integration with hybrid ecosystems