Business Intelligence Advisor

NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. We are a $30 billion trusted global innovator of business and technology services, serving 75% of the Fortune Global 100.

About the role

Design, develop, and optimize Snowflake data solutions supporting manufacturing and Integrated Supply Chain business processes.

Responsibilities

• Extract and ingest data from multiple source systems using Fivetran and Informatica Intelligent Cloud Services (IICS), ensuring reliable, scalable, and auditable data pipelines.
• Develop and maintain Snowflake objects, including databases, schemas, tables, views, streams, tasks, stored procedures, functions, stages, file formats, and secure data-sharing components.
• Perform data transformation, integration, and validation activities to deliver trusted datasets for supply chain planning, procurement, inventory, logistics, manufacturing operations, and related reporting use cases.
• Collaborate directly with clients and business stakeholders to gather, clarify, and analyze functional and technical requirements.
• Analyze source-to-target mappings, business rules, data dependencies, and data-quality requirements in collaboration with business analysts, architects, and client stakeholders.
• Prepare deployment packages and deploy Snowflake, Fivetran, and IICS objects to QA and Production environments in accordance with release-management and change-control procedures.
• Develop, schedule, monitor, troubleshoot, and deploy Control-M jobs and workflows across development, QA, and Production environments.
• Coordinate with offshore teams to manage Control-M configurations, dependencies, calendars, alerts, and production deployment activities, and validate successful execution after release.
• Manage Opsera-based CI/CD development and deployment activities, including pipeline configuration, release orchestration, approvals, environment promotion, and deployment of Snowflake and related data integration objects across Development, QA, and Production environments.
• Monitor deployment execution, troubleshoot pipeline failures, coordinate with offshore teams, and perform post-deployment validation.
• Coordinate with security team for masking review and security testing.
• Coordinate with the offshore development team and operations team to plan and execute QA and Production deployments, including prerequisite checks, deployment sequencing, rollback planning, and post-deployment validation.
• Execute functional, integration, regression, and production smoke testing; reconcile data across source and target systems and document test evidence and results.
• Coordinate User Acceptance Testing (UAT) with client business and IT teams, track defects, investigate data and application issues, and provide timely status updates.
• Debug UAT, QA, and Production issues by performing root-cause analysis across Snowflake, Fivetran, IICS, source systems, orchestration workflows, and downstream reporting layers.
• Work closely with offshore developers to implement fixes, complete peer reviews, retest resolved issues and promote approved changes through the deployment lifecycle.
• Monitor pipeline performance, data freshness, failed jobs, warehouse utilization, and query performance; proactively recommend improvements for reliability, cost, and scalability.
• Maintain technical documentation, deployment runbooks, test cases, operational support guides, and knowledge-transfer materials.
• Attend daily Scrum meetings, client requirement discussions, backlog-grooming sessions, sprint-planning meetings, deployment reviews, UAT discussions, and other project meetings scheduled during US business hours.
• Collaborate with onsite and offshore teams to provide status updates, clarify requirements, resolve blockers, and support timely project delivery.
• Maintain timely and accurate JIRA story updates, including status, progress, estimates, dependencies, risks, blockers, testing results, deployment details, and acceptance criteria.
• Perform any additional activities required to meet the scope of the project.

Requirements

• Minimum 10+ years of overall experience in data engineering, data warehousing, ETL/ELT, or analytics-platform development.
• Minimum 6+ years of hands-on Snowflake development experience on enterprise implementation or modernization projects.
• Minimum 2+ years of experience building and supporting data ingestion pipelines using Fivetran and/or Informatica IICS.
• 5+ years of strong hands-on experience with advanced SQL, dimensional data modeling, performance tuning, query optimization, and Snowflake cost-management practices.
• 2+ years of experience in manufacturing-domain projects, specifically within Integrated Supply Chain functions.
• 3+ years of experience in handling data from SAP source systems.
• Bachelor’s degree in computer science or equivalent work experience.

Nice to Have

• SnowPro Core or advanced Snowflake certification.

Travel

Travel may be required based on client and project needs.