Tata Consultancy Services · 18 hours ago
Cognos Technical Lead
Portland, OR
Full-time
Onsite
Mid, Senior Level
$100K/yr - $140K/yrTata Consultancy Services is a global leader in IT services, consulting, and business solutions. They are seeking a Cognos Technical Lead who will be responsible for advanced report development, data modeling, and ETL processes using IBM Cognos Analytics and other BI tools.
Business Information SystemsConsultingInformation TechnologyIT Management
Responsibilities
Required - Advanced proficiency in IBM Cognos Analytics (11.x): Report Studio, Analysis Studio, Event Studio, Framework Manager, Dynamic Cubes, Transformer
Required -Expertise in designing complex dashboards, visualizations, multidimensional reports, and report bursting
Required -Skilled in migrating legacy BI solutions (Series 6 → Cognos 8/10/11) and converting reports to tools like Tableau and Power BI
Required -Strong experience in dimensional modeling (star/snowflake schemas), relational modeling, and building data warehouse layers
Required -Hands-on experience with ETL processes, data mapping, data transformation, and documenting end-to-end data flows
Required -Ability to perform deep data profiling, validation, cleansing, and quality checks
Required - Strong command over SQL, PL/SQL, stored procedures, triggers, and performance optimization
Required - Familiar with MDX and query debugging/troubleshooting for Cognos-generated SQL
Preferred - Additional programming experience: Python, R, Java (Core), C, C++
Required - Expertise in working with SQL Server, Oracle, IBM DB2, ODS, Cognos Content Store
Preferred - Experience with Hadoop ecosystem, Spark, Sqoop, Jupyter Notebook, Cloudera environment
Preferred - Competent with Tableau, Power BI (data modeling, DAX, dashboarding), and Business Objects (WebI, Universe design)
Required - Healthcare Basics
Required - Knowledge of ERP systems (Banner), PeopleSoft (Compensation, Global Payroll), HR, Payroll, AR, Financial Aid
Preferred - Strong experience managing onshore-offshore models, client communication, requirement gathering, and documentation
Preferred - Proven ability to interact with business stakeholders, gather reporting requirements, and deliver scalable BI solutions
Qualification
Required
Advanced proficiency in IBM Cognos Analytics (11.x): Report Studio, Analysis Studio, Event Studio, Framework Manager, Dynamic Cubes, Transformer
Expertise in designing complex dashboards, visualizations, multidimensional reports, and report bursting
Skilled in migrating legacy BI solutions (Series 6 → Cognos 8/10/11) and converting reports to tools like Tableau and Power BI
Strong experience in dimensional modeling (star/snowflake schemas), relational modeling, and building data warehouse layers
Hands-on experience with ETL processes, data mapping, data transformation, and documenting end-to-end data flows
Ability to perform deep data profiling, validation, cleansing, and quality checks
Strong command over SQL, PL/SQL, stored procedures, triggers, and performance optimization
Familiar with MDX and query debugging/troubleshooting for Cognos-generated SQL
Expertise in working with SQL Server, Oracle, IBM DB2, ODS, Cognos Content Store
Healthcare Basics
Knowledge of ERP systems (Banner), PeopleSoft (Compensation, Global Payroll), HR, Payroll, AR, Financial Aid
BACHELOR OF COMPUTER SCIENCE
Preferred
Additional programming experience: Python, R, Java (Core), C, C++
Experience with Hadoop ecosystem, Spark, Sqoop, Jupyter Notebook, Cloudera environment
Competent with Tableau, Power BI (data modeling, DAX, dashboarding), and Business Objects (WebI, Universe design)
Strong experience managing onshore-offshore models, client communication, requirement gathering, and documentation
Proven ability to interact with business stakeholders, gather reporting requirements, and deliver scalable BI solutions
Benefits
Discretionary Annual Incentive.
Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
Family Support: Maternal & Parental Leaves.
Insurance Options: Auto & Home Insurance, Identity Theft Protection.
Convenience & Professional Growth: Commuter Benefits & Certification & amp; Training Reimbursement.
Time Off: Vacation, Time Off, Sick Leave & Holidays.
Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
Company
Tata Consultancy Services
Tata Consultancy Services is a business solutions company that specializes on information technology services and consulting.
Founded in 1968
10001+ employees
H1B Sponsorship
Tata Consultancy Services has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (7880)
2024 (9690)
2023 (8537)
2022 (11159)
2021 (9813)
2020 (11984)
Funding
Current Stage
Public CompanyTotal Funding
unknown2004-08-25IPO
Leadership Team
K. Krithivasan
Chief Executive Officer & Managing Director
Aarthi Subramanian
President and Chief Operating Officer
Recent News
Hindu Business Line
2026-01-21
2026-01-20
Company data provided by crunchbase