BI Architect/Application Lead

company banner
Contract W2, Contract Independent, Full Time, 6+ mos
Work from home not available Travel not required

Job Description

My customer, located in Culver City, CA has a long term contract opportunity available for a BI Architect.

This is a Techno-Functional role with skills around core BI Architecture with hands-on and a functional head to lead a team. Ability to define and maintains both vision and guidelines by encapsulating significant architectural best practices for current and future state systems that align with Enterprise Architecture roadmaps to enable business success. Establish and formalize standards and guiding principles necessary to define and build business and data models to integrate with ETL and Application Interfaces along with data quality management solutions.

Experience in implementing consumer data warehouse or maintained w/ encrypted data and industry standard key rotation policy. Experience in managing ETL and database backend teams and supporting front end users including data scientists with various tools like python, R and BI tools.

Able to construct and analyze both functional and business requirements and design solutions based on existing BI solution tool sets following Agile methods. Highly skilled in profiling the data sources and conceptualizing and guiding technical team. Familiarity with Big Data stack is desired and must have been involved in AWS Cloud Architecture and hands-on is a plus.

Highly skilled in driving enterprise standards for report design, development and deployment into BI Platform in compliance with Industry and Security Architecture best practices.

Media & Entertainment experience is a plus. Teradata and Erwin experience are a must. Experience in any Master Data Management product, cloud and Big Data Technologies is an added skill set. Experience in running BI projects in Agile Methodology is preferred.

Experience in BI Tools like Tableau and Alteryx is a plus along with Managing Resources and Projects.

Responsibilities include:

* Interacting with Business Users/ Business Relationship Managers to understand the BI needs

* Identify the right data sources / data completeness to meet the BI needs

* Data profiling to build the entity relationships across multiple sources

* Build and Review conceptual and logical data models based on the BI needs

* Develop and maintain Business Glossary across the organization LOBs

* Recommend Data Quality Management methodologies for various projects

* Develop optimized database design to achieve acceptable performance by tuning views, tables and indexes for proper response time -rollup to Teradata in depth skillset (see below)

* Provides consultation to ETL teams on the data load strategy

* Identify the right End User Reporting/Strategy solutions.

* Maintain the data lineage for the data acquisitions and reporting done

Key outputs include:

* Data entity relationship and models for new data sources

* Data integration solutions for syndicate data with internal data

* Reporting recommendations considering the analytical nature of the BI solutions

* Recommend best practices to manage Data Quality and Data integrity

* Contribution of documentation to IT knowledge database

Core Responsibilities:

25% 1. Work with Business Users and IT team to gather the business requirements in BI space and convert these into functional and technical requirements

25% 2. Data profiling, building conceptual and logic models, delivering effective and efficient physical models

20% 3. BI Strategy around data acquisition for integrating transactional systems or syndicate/industry data into Enterprise Data Warehouse or DataMart.

20% 4. Maintain the Business Glossary, Data Lineage and a governance process for Data Quality Management

5% 5. Assist reporting teams and Business Users in designing and building reporting solutions

5% 6. Evaluation of the latest BI tool set that fits or enhances the existing BI tool stack.


* 10+ of years of IT work experience and 5+ years in the similar role of BI Data Modeler/Architect. Any Media & Entertainment experience is an added plus

* Any Teradata or BI related Certification is a plus.

* Teradata Master Certification is a plus.

* Strong with data modeling concepts (star schemas, snowflake schemas, highly normalized data models)

* Data modeling tools - Erwin is a must and familiarity with ER studio, Visio and Embardigo

* Data Warehouse database platforms - Teradata is a must and any experience with EDW platforms like Exadata, HP blade or Netezza or Greenplum is and added advantage.

* Experience with Business Objects/Tableau and any BI Reporting tools is required

* Knowledge of BI tools like PowerBI is a plus and any familiarity with Tools that interact and interface with Big Data is a plus; such as Alteryx

* Knowledge and experience of any data profiling tool is required

* Familiar with any major ETL tools is required; DataStage / Informatica, Talend

* Experience with any Data Quality Management full life cycle is an added advantage.

* In depth hands on experience with SQL programming skills

* Both Traditional RDBMS and Document Oriented databases

* Excellent Analytical skills

* Excellent communication skills with both business and technical customers

* Demonstrate a high level of integrity and maturity

* Take a proactive approach to cross-functional communication

* Actively seek out feedback from management and peers, to improve own performance based on that feedback
Contractor Benefits*


*benefits are available only to W2 Contractors

Who is NTT Data?

NTT DATA is a leading IT services provider and global innovation partner with 100,000 professionals based in over 50 countries. NTT DATA emphasizes long-term commitment and combines global reach and local intimacy to provide premier professional services, including consulting, application services, business process and IT outsourcing, and cloud-based solutions. We're part of NTT Group, one of the world's largest technology services companies, generating more than $100 billion in annual revenues and partner to 80% of the Fortune 100. Visit to learn how our consultants, projects, managed services, and outsourcing engagements deliver value for a wide range of businesses and government agencies.

The Company is an equal opportunity employer and makes employment decisions on the basis of merit and business needs. The Company will consider all qualified applicants for employment without regard to race, color, religious creed, citizenship, national origin, ancestry, age, sex, sexual orientation, genetic information, physical or mental disability, veteran or marital status, or any other class protected by law. To comply with applicable laws ensuring equal employment opportunities to qualified individuals with a disability, the Company will make reasonable accommodations for the known physical or mental limitations of an otherwise qualified individual with a disability who is an applicant or an employee unless undue hardship to the Company would result.

Posted By

Mike Shorey

Company Information

NTT DATA Services

NTT DATA means Business

NTT Group one of the largest Telecommunications Companies in the world owns NTT DATA Services. 
NTT Group is ranked in the top 5 largest global IT services provider in the world. Collectively, the integrated company generates $108B in annual revenues with over 300,000 employees across 88 countries. 

Visit to learn how NTT DATA Americas' Strategic Staffing group provides our clients with top notch technical talent to augment their core IT staff. Our approach is customer centric, partnering to assist you in achieving your strategic goals and IT initiatives. We get to know your company’s culture and the type of technical staff that thrive within your organization. We understand your specific technical and business requirements, timing, and budget

Dice Id : 10229323a
Position Id : 19-13212
Originally Posted : 1 month ago

Similar Positions at NTT DATA, Inc.