BI Designer

Greetings This is Akhil from Softpath System LLC. We Softpath are a global staff augmentation firm providing a wide-range of talent on-demand and total workforce solutions. We have an immediate opening for a position of

• 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