Required Skills

BI Designer

Work Authorization

  • Us Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 3rd Aug 2021

JOB DETAIL

· Assist in interviewing business users to obtain information requirements.
· Perform analysis on data sources to verify expected data content, relationships and quality
· Design and communicate conceptual and logical data models
· Develop and communicate high-level technical designs in order to resolve complex technical and business issues.
· Evolve Business Intelligence solutions and data models to meet new and changing business requirements
· Develop processes for capturing and maintaining metadata from all data warehousing components (from databases and big data repositories to data access tool catalogs)
· Work with CDO solution architect and Data Platform architect/developers to define best practices (including detail source-to-target mapping design and transformation ETL logics, etc.) for Derived Data Sets and Business Ready Data design.
· Proactively monitor data quality; provide direction and guidance in improving the data load process
· Support and advise business users on data conflicts or inappropriate data usage
· Adhere to and set data management, security, development policies, procedures and standards
· Be proactive, motivated and flexible
· Possess analytical skills and have the ability to support and manage multiple priorities
· Cultivate long-term strategic goals for CDO BI Information Management environment in conjunction with Business stakeholders and CDO team
· May support the activities of others for BI activities or projects.

QUALIFICATIONS:
· BA/BS in Computer Science, Management Information Systems or equivalent Business degree / work experience
· 10+ years of experience in Business Intelligence area (specifically with structured and unstructured data analysis; solution design; metadata management)
· Strong analytical, conceptual and technical skills; facile ability to translate business needs into technical solutions
· Capable of developing a deep understanding of source data: its strengths, weaknesses and semantics.
· Mastery of various data modeling tools and data modeling paradigms for both structured and unstructured data
· Mastery of various data querying languages (such as SQL and HiveQL)
· 8+ years of experience with Oracle/Teradata/Vertica databases and tools
· Experience with ETL tools (such as Informatica)
· Experience with Hadoop environment (including Hive, Impala, Sqoop, Spark, etc.)
· Experience with scripting tools (including unix shell, Python, Ruby, PHP, etc.)
· Familiarity with Business Intelligence tools (including OLAP/Metadata Management/Reporting/ visualization tools) such as Microstrategy, Qlikview, Cognos, Tableau, etc.
· Extensive client facing skills with the ability to lead customer/business user meetings (as appropriate)
· Excellent communication skills both written and oral
· Strong partnering and teamwork skills;
· Flexibility, diplomacy, and problem-solving skills
· Strong interpersonal and communications skills; ability to effectively with people at all levels of the enterprise from executives to developers (across the organizational spectrum from Business to Engineering)
· Self-motivated and highly adaptable; ability to work in a fast-paced, dynamic, and changing environment

 

Company Information