NTT DATA North America · 6 days ago
BI Lead (BOE,Crystal,PBI)
United States
Full-time
Remote
Senior Level, Lead/Staff
8+ years expNTT DATA is a $30 billion business and technology services leader, serving 75% of the Fortune Global 100. They are currently seeking a BI Lead to analyze existing UNV universes, perform UNV to UNX conversions, and update data connections to ensure seamless reporting and data accuracy.
ConsultingDigital MarketingInformation ServicesInformation TechnologyIT Management
Responsibilities
Analyze existing UNV universes (joins, contexts, aliases, aggregate awareness, prompts, LOVs, security rules)
Perform UNV to UNX conversion using Information Design Tool (IDT), ensuring functional equivalence
Update and configure data connections to point from Yellowbrick to Snowflake (ODBC/JDBC, drivers, connection parameters)
Validate generated SQL against Snowflake to ensure correct semantics and performance
Update Web Intelligence (WebI) and Crystal Reports to use Snowflake-based universes or direct connections, without changing layout or KPIs
Ensure that: Report structure, formulas, variables, prompts, filters, and sections behave identically
All scheduled jobs, publications, and bursting continue to work after pointing to Snowflake
Fix issues where reports rely on Yellowbrick-specific SQL or functions, replacing them with Snowflake-compatible logic while preserving business behavior
Perform side-by-side comparisons of reports running on Yellowbrick vs Snowflake: Totals, subtotals, row counts, groupings, and key KPIs
Prompt behavior and filter logic
Monitor and compare report performance and refresh times before and after migration
Qualification
Required
8-10 years of experience in Business Intelligence / Reporting development, with strong hands-on work in SAP BusinessObjects and Crystal Reports
Direct experience in BI replatforming/migration projects, preferably involving database/platform changes (e.g., moving from MPP DWs like Yellowbrick/Teradata/Netezza to Snowflake or similar)
Strong experience with SAP BO tools: Universe Designer / IDT (Information Design Tool) – building and maintaining UNV and UNX universes
Web Intelligence (WebI) report development and troubleshooting
Knowledge of Publications, Scheduling, and Security (users, groups, folders)
Hands-on experience with Crystal Reports design, parameters, formulas, and data connectivity
Proven experience in UNV → UNX conversion and post-conversion validation
Solid SQL skills, including: Joins, aggregations, subqueries, derived tables, and performance-aware query writing
Good understanding of data warehouse concepts (facts/dimensions, SCDs, star/snowflake schemas)
Familiarity with version control tools (Git) and promotion/migration tools in BO environments
Strong attention to detail and quality-focused mindset, especially around data accuracy and report consistency
Ability to analyze and troubleshoot complex report/data issues
Preferred
Exposure to Snowflake (views, warehouses, roles, connectivity) is highly desirable; Yellowbrick/other MPP DW exposure is a plus
Company
NTT DATA North America
NTT DATA, Inc. is a trusted global innovator of business and technology services.
10001+ employees
H1B Sponsorship
NTT DATA North America 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 (144)
2024 (182)
2023 (257)
2022 (871)
2021 (809)
2020 (1266)
Funding
Current Stage
Late StageLeadership Team
John Barr
Vice President - Insurance Strategy
Recent News
2025-12-05
Company data provided by crunchbase