Lead Software Engineer - Cognos, BO, Snowflake, SQL
JPMorgan Chase1 day ago
Mumbai, IndiaStaff+
Responsibilities
- Build end-to-end BI solutions covering requirements, data modeling, report and dashboard development, testing, and production support.
- Migrate and modernize SAP BusinessObjects reporting content into IBM Cognos, including report rebuilding, validation, scheduling, and cutover support.
- Develop and maintain IBM Cognos reports, packages, frameworks, and data modules.
- Design performant reporting datasets and data layers on Snowflake and/or Databricks, including SQL optimization and cost/performance tuning.
- Partner with data owners and data engineering teams to align reporting with governed, reusable datasets and data products in the Master Data Lake.
- Implement data quality checks, reconciliation, monitoring, incident triage, root-cause analysis, and permanent fixes for reporting and data issues.
- Participate in the Sigma Computing proof of concept, connect dashboards to Snowflake and Databricks through the Master Data Lake, and assess Tableau and QlikSense dashboard migrations.
- Build reusable metric definitions, semantic objects, migration playbooks, and tooling for BI consolidation and self-service analytics adoption.
- Lead responsible adoption of enterprise-authorized AI-assisted software development tools for coding, code review, testing, troubleshooting, and workflow automation.
- Follow software development lifecycle practices, including version control, peer review, release management, secure coding, and automated testing.
Requirements
- Formal training or certification in software engineering concepts and at least 5 years of applied experience.
- Strong hands-on experience with SAP BusinessObjects and IBM Cognos, including report authoring, packages, models, scheduling, and performance troubleshooting.
- Hands-on experience with Snowflake and/or Databricks, SQL, data modeling, and large datasets.
- Strong SQL skills, including joins, window functions, aggregations, query tuning, and optimization.
- Experience delivering production-grade reporting and analytics solutions with reliability, supportability, and governance considerations.
- Ability to translate business requirements into scalable reporting and data designs, including migration and coexistence scenarios.
- Experience leading the effective use of approved AI-assisted software development tools and validating AI outputs for correctness, performance, and security.
- Understanding of responsible AI use in engineering workflows, data sensitivity, secure input and output handling, resiliency, and security expectations.
- Hands-on experience with QlikSense, Tableau, or Sigma involving dashboarding, data visualization, or migration.
- Experience delivering end-to-end BI migration projects, including report inventory analysis, rationalization, prioritization, wave planning, and execution tracking.
- Working knowledge of data warehousing concepts such as dimensional modeling, facts and dimensions, and data marts.
- Preferred experience with Sigma workbook or dashboard development and warehouse-native analytics.
- Preferred experience with AWS, data lake architectures, Master Data Lake, data mesh, or data product concepts.
- Preferred experience with Databricks Genie, Snowflake Cortex, ChatGPT, or Copilot in controlled enterprise environments.
- Preferred Python experience for data processing, automation, testing, or utilities.
- Preferred experience creating migration factory tooling, templates, or automated validation for large report portfolios.
- Financial services, capital markets, or Commercial and Investment Bank domain experience is preferred.
About JPMorgan Chase
JPMorgan Chase provides consumer and commercial banking, payments, credit card, wealth management, and corporate and investment banking services to individuals, businesses, institutions, and governments. The public company (NYSE: JPM) earns revenue from interest, fees, trading, and asset management across operations in more than 100 markets. Headquartered in New York City with roots dating to 1799, it serves retail customers and prominent corporate and government clients through brands including Chase and J.P. Morgan.