4Bell Technology

Staffing & Recruiting

BSA - Business Intelligence & Reporting(R-1825)

2,000,000.00-2,500,000.00/A

Any Degree

IT (Information Technology)

Full-time

Bangalore/Bengaluru,Chennai

28-Aug-2026

Business Systems Analyst SQL BRD & FRD IBM Cognos BI / Analytics Data Modules. SQL Server/Oracle/Teradata DB2 Healthcare domain Power bi Tableau

Job Description

  • Key Responsibilities

    • Design and develop complex paginated reports, dashboards, active reports, and visualizations in IBM Cognos Analytics/Power BI
    • Build and maintain Framework Manager packages and modern Data Modules — define namespaces, query subjects, relationships, determinants, calculated items, and governors.
    • Translate business requirements into technical specs; work directly with business analysts, product owners, and end users.
    • Develop and optimize underlying SQL queries, stored procedures, and views on relational databases such as Oracle, PostgreSQL, SQL Server etc.
    • Implement prompts, drill-throughs, master-detail relationships, conditional formatting, and bursting.
    • Configure schedules, subscriptions, and distribution (email, file share, portal).
    • Implement row-level / object-level security using Cognos namespaces, capabilities, and authentication providers (LDAP, AD, SSO/SAML).
    • Perform performance tuning of reports, queries, and Cognos services — analyze query logs, indexing strategies, and caching.
    • Migrate legacy content (SSRS, Crystal, older Cognos versions, BusinessObjects) into the current Cognos environment.
    • Support deployments across environments (Dev → UAT → Prod) using deployment specifications, Lifecycle Manager, and Git-based version control.
    • Mentor junior developers; conduct code reviews and enforce BI standards.
    • Troubleshoot production issues and provide L3 support.

    Required Skills

    • 5–10 years of hands-on experience in IBM Cognos BI / Power BI
    • Strong expertise in Framework Manager modeling and Data Modules.
    • Expert in Report Studio / Cognos Reporting — list, crosstab, chart, dashboard, active report, drill-through, bursting.
    • Strong SQL skills — complex joins, window functions, query optimization, execution plan reading.
    • Solid grasp of dimensional modeling, star/snowflake schemas, slowly changing dimensions.
    • Experience with at least one enterprise RDBMS (SQL Server, Oracle, Teradata, DB2) and ideally a cloud warehouse (Snowflake, Synapse, BigQuery, Redshift).
    • Understanding of ETL concepts and exposure to tools like SSIS, Informatica, ADF, or DataStage.
    • Experience deploying Cognos in dev/test/prod lifecycles, version control, and CI/CD principles.
    • Experience working with multiple BI and analytics platforms such as Cognos, Apache Superset, Power BI, Tableau, Qlik, BusinessObjects, or similar tools.