LOG IN
SIGN UP
Canary Wharfian - Online Investment Banking & Finance Community.
Sign In
Forgot password?
Don't have an account?
or
Join Canary Wharfian
By signing up, you agree to our Terms & Conditions and Privacy Policy.
or

Lead Software Engineer - Cognos, BO, Snowflake, SQL

ExperiencedNo visa sponsorship
J.P. Morgan logo

at J.P. Morgan

Bulge Bracket Investment Banks

Posted 18 days ago

No clicks

**Lead Software Engineer – JPMorgan Chase | Mumbai, Maharashtra, India** Lead a team transforming BI landscapes using IBM Cognos, Snowflake, and Sigma Computing. Key responsibilities include: 1. **End-to-End BI Solutions**: Developments, from requirements to production support. 2. **SAP BO Exit & Migration**: Modernize IBM Cognos reports, migrate SAP BO content to Cognos, and manage cutover. 3. **Snowflake & Databricks**: Design efficient datasets and enhancements, optimize SQL, and tune performance. 4. **Data Governance**: Collaborate with data teams, reduce data extracts, and implement quality checks. 5. **Incident Management & Support**: Triage issues, find root causes, and promote fixes. 6. **Long-term BI Consolidation**: Build reusable metrics, semantic objects, and migration playbooks. **Required**: - **5+ Years in Software Engineering** with Cognos, SAP BO, and advanced SQL skills. - **Hands-on** experience with Snowflake, Databricks, and SQL optimizations. - Proven track record delivering reliable reporting solutions and migrating large report inventories. **Preferred**: - Sigma Computing, AWS, Python, automation tools, and financial services domain experience.

Compensation
Not specified

Currency: Not specified

City
Mumbai
Country
India

Full Job Description

Location: Mumbai, Maharashtra, India

We have an opportunity to impact your career and provide an adventure where you can push the limits of what's possible.  

As a Lead Software Engineer at JPMorgan Chase within the Commercial & Investment Bank's Sales & Research Technology team, you will develop semantic layers, data models, and dashboards, and partner with business and data teams to deliver reliable insights at scale. you will play an important role in our BI modernization strategy, including the SAP BusinessObjects exit program and establishing a scalable foundation for long-term platform consolidation and self-service analytics and support the long-term BI strategy transitioning toward Sigma Computing, Snowflake/Databricks, and the Master Data Lake (MDL). 

Job responsibilities

  • Build and enhance end-to-end BI solutions: requirements data modeling report/dashboard development testing production support.
  • Deliver the SAP BO exit outcomes by migrating and modernizing reporting content into IBM Cognos, including report rebuilds, validation, scheduling, and cutover support.
  • Develop and maintain IBM Cognos reports, packages, and frameworks (Framework Manager / data modules as applicable).
  • Design performant datasets and reporting layers on Snowflake and/or Databricks, including SQL optimization and cost/performance tuning.
  • Partner with data owners and data engineering to align reporting to governed, reusable datasets and data products (MDL aligned), reducing point-to-point extracts and improving consistency.
  • Drives team adoption of enterprise-authorized AI-assisted engineering practices within the work environment to improve code quality, delivery speed, and operational outcomes (e.g., AI-assisted code review/refactoring, test strategy acceleration, incident/root-cause analysis support), while establishing consistent validation standards (secure coding, peer review, automated testing) and promoting reuse of effective patterns across the team.
  • Applies knowledge of tools within the Software Development Life Cycle toolchain, including enterprise-authorized AI-assisted development and automation capabilities, to improve the value realized by automation. Follow SDLC practices (version control, peer reviews, release management) and contribute to standards for BI development.
  • Implement data quality checks, reconciliation, and monitoring to ensure trusted reporting during migrations and ongoing operations.
  • Support incident triage and root-cause analysis for reporting/data issues; drive permanent fixes and documentation.
  • Contribute to long-term BI consolidation by building reusable metric definitions, semantic objects, and migration playbooks that support future dashboard and self-service tooling adoption (including Sigma where applicable).
  • Participate in Sigma Computing PoC build dashboards, connect to Snowflake/Databricks via MDL. Collaborate with data owners to register data sources to MDL. Assess and migrate Tableau/QlikSense dashboards to Sigma. Evaluate Sigma maturity for future Cognos workload migration. Support AI/conversational analytics enablement

Required qualifications, capabilities, and skills

  • Formal training or certification on software engineering concepts and 5+ years applied experience
  • Strong hands-on experience with SAP Business Objects and IBM Cognos (report authoring, packages/models, scheduling, performance troubleshooting).
  • Hands-on experience with Snowflake and/or Databricks (SQL, data modeling, working with large datasets).
  • Strong SQL skills (joins, window functions, aggregations, query tuning).
  • Experience delivering production-grade reporting/analytics solutions with attention to reliability, supportability, and governance.
  • Ability to translate business requirements into scalable reporting and data designs, including migration and coexistence scenarios.
  • Demonstrated experience leading effective use of approved AI-assisted software development tools (e.g., for coding, code review, test acceleration, troubleshooting) with the ability to set team expectations for validating AI outputs for correctness, performance, and security.
  • Strong understanding of responsible AI use in engineering workflows, including data sensitivity considerations, secure handling of inputs/outputs, and adherence to resiliency and security expectations; experience coaching engineers on safe, compliant adoption within delivery practices
  • Hands-on experience with one of the tool QlikSense or Tableau or Sigma   dashboarding, data visualization best practices, migration experience
  • BI (reports/dashboards) end to end migration project experience (any platform). Experience analyzing, rationalizing, and migrating large report inventories, including prioritization, wave planning, and execution tracking.
  • Working knowledge of data warehousing concepts (for example: dimensional modeling, facts and dimensions, and data marts) sufficient to assess migration impacts and dependencies.

 

Preferred qualifications, capabilities, and skills

  • Sigma (workbook/dashboard development, warehouse-native analytics concepts)
  • Cloud data platforms AWS, data lake architectures, MDL / data mesh / data product concepts
  • Experience using analytics automation or artificial intelligence-enabled tools (e.g. Databricks Genie, Snowflake Cortex, Chat GPT/Copilot) to accelerate dataset analysis or workflow efficiency in a controlled enterprise environment.
  • Python (data processing, automation, testing, utilities).
  • Experience creating migration factory tooling, templates, or automated validation for large report portfolios.
  • Financial services / Capital Markets / CIB domain experience
Lead Software Engineer - Cognos, BO, Snowflake, SQL

Lead Software Engineer - Cognos, BO, Snowflake, SQL

Compensation

Not specified

City: Mumbai

Country: India

J.P. Morgan logo
Bulge Bracket Investment Banks

18 days ago

No clicks

at J.P. Morgan

ExperiencedNo visa sponsorship

**Lead Software Engineer – JPMorgan Chase | Mumbai, Maharashtra, India** Lead a team transforming BI landscapes using IBM Cognos, Snowflake, and Sigma Computing. Key responsibilities include: 1. **End-to-End BI Solutions**: Developments, from requirements to production support. 2. **SAP BO Exit & Migration**: Modernize IBM Cognos reports, migrate SAP BO content to Cognos, and manage cutover. 3. **Snowflake & Databricks**: Design efficient datasets and enhancements, optimize SQL, and tune performance. 4. **Data Governance**: Collaborate with data teams, reduce data extracts, and implement quality checks. 5. **Incident Management & Support**: Triage issues, find root causes, and promote fixes. 6. **Long-term BI Consolidation**: Build reusable metrics, semantic objects, and migration playbooks. **Required**: - **5+ Years in Software Engineering** with Cognos, SAP BO, and advanced SQL skills. - **Hands-on** experience with Snowflake, Databricks, and SQL optimizations. - Proven track record delivering reliable reporting solutions and migrating large report inventories. **Preferred**: - Sigma Computing, AWS, Python, automation tools, and financial services domain experience.

Full Job Description

Location: Mumbai, Maharashtra, India

We have an opportunity to impact your career and provide an adventure where you can push the limits of what's possible.  

As a Lead Software Engineer at JPMorgan Chase within the Commercial & Investment Bank's Sales & Research Technology team, you will develop semantic layers, data models, and dashboards, and partner with business and data teams to deliver reliable insights at scale. you will play an important role in our BI modernization strategy, including the SAP BusinessObjects exit program and establishing a scalable foundation for long-term platform consolidation and self-service analytics and support the long-term BI strategy transitioning toward Sigma Computing, Snowflake/Databricks, and the Master Data Lake (MDL). 

Job responsibilities

  • Build and enhance end-to-end BI solutions: requirements data modeling report/dashboard development testing production support.
  • Deliver the SAP BO exit outcomes by migrating and modernizing reporting content into IBM Cognos, including report rebuilds, validation, scheduling, and cutover support.
  • Develop and maintain IBM Cognos reports, packages, and frameworks (Framework Manager / data modules as applicable).
  • Design performant datasets and reporting layers on Snowflake and/or Databricks, including SQL optimization and cost/performance tuning.
  • Partner with data owners and data engineering to align reporting to governed, reusable datasets and data products (MDL aligned), reducing point-to-point extracts and improving consistency.
  • Drives team adoption of enterprise-authorized AI-assisted engineering practices within the work environment to improve code quality, delivery speed, and operational outcomes (e.g., AI-assisted code review/refactoring, test strategy acceleration, incident/root-cause analysis support), while establishing consistent validation standards (secure coding, peer review, automated testing) and promoting reuse of effective patterns across the team.
  • Applies knowledge of tools within the Software Development Life Cycle toolchain, including enterprise-authorized AI-assisted development and automation capabilities, to improve the value realized by automation. Follow SDLC practices (version control, peer reviews, release management) and contribute to standards for BI development.
  • Implement data quality checks, reconciliation, and monitoring to ensure trusted reporting during migrations and ongoing operations.
  • Support incident triage and root-cause analysis for reporting/data issues; drive permanent fixes and documentation.
  • Contribute to long-term BI consolidation by building reusable metric definitions, semantic objects, and migration playbooks that support future dashboard and self-service tooling adoption (including Sigma where applicable).
  • Participate in Sigma Computing PoC build dashboards, connect to Snowflake/Databricks via MDL. Collaborate with data owners to register data sources to MDL. Assess and migrate Tableau/QlikSense dashboards to Sigma. Evaluate Sigma maturity for future Cognos workload migration. Support AI/conversational analytics enablement

Required qualifications, capabilities, and skills

  • Formal training or certification on software engineering concepts and 5+ years applied experience
  • Strong hands-on experience with SAP Business Objects and IBM Cognos (report authoring, packages/models, scheduling, performance troubleshooting).
  • Hands-on experience with Snowflake and/or Databricks (SQL, data modeling, working with large datasets).
  • Strong SQL skills (joins, window functions, aggregations, query tuning).
  • Experience delivering production-grade reporting/analytics solutions with attention to reliability, supportability, and governance.
  • Ability to translate business requirements into scalable reporting and data designs, including migration and coexistence scenarios.
  • Demonstrated experience leading effective use of approved AI-assisted software development tools (e.g., for coding, code review, test acceleration, troubleshooting) with the ability to set team expectations for validating AI outputs for correctness, performance, and security.
  • Strong understanding of responsible AI use in engineering workflows, including data sensitivity considerations, secure handling of inputs/outputs, and adherence to resiliency and security expectations; experience coaching engineers on safe, compliant adoption within delivery practices
  • Hands-on experience with one of the tool QlikSense or Tableau or Sigma   dashboarding, data visualization best practices, migration experience
  • BI (reports/dashboards) end to end migration project experience (any platform). Experience analyzing, rationalizing, and migrating large report inventories, including prioritization, wave planning, and execution tracking.
  • Working knowledge of data warehousing concepts (for example: dimensional modeling, facts and dimensions, and data marts) sufficient to assess migration impacts and dependencies.

 

Preferred qualifications, capabilities, and skills

  • Sigma (workbook/dashboard development, warehouse-native analytics concepts)
  • Cloud data platforms AWS, data lake architectures, MDL / data mesh / data product concepts
  • Experience using analytics automation or artificial intelligence-enabled tools (e.g. Databricks Genie, Snowflake Cortex, Chat GPT/Copilot) to accelerate dataset analysis or workflow efficiency in a controlled enterprise environment.
  • Python (data processing, automation, testing, utilities).
  • Experience creating migration factory tooling, templates, or automated validation for large report portfolios.
  • Financial services / Capital Markets / CIB domain experience
Lead Software Engineer - Cognos, BO, Snowflake, SQL