Previous Job
Business Intelligence Solutions Modeler-Designer /Dallas TX, Denver, CO or Los Angeles
Ref No.: 18-00498
Location: Dallas, Texas
Position Type:Contract
Client needs more BI Designer Profiles. Candidates can sit in Dallas TX, Denver CO or LA CA

Need BI Designer with Datamodeling in Hadoop Environment with 8+ years of experience.

A Business Intelligence Solutions Modeler/Designer works under limited supervision to analyze and design analytical data integration solutions that include both structured and unstructured data, to develop and manage metadata from analytical data stores and data access tools, and to monitor and manage data quality. The ideal candidate will have the ability to promote the value and potential of BI across the Enterprise, understand how information is used to drive strategic and tactical decisions for the Business, and understand and anticipate the information needs of the Business.

  • 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 (designs that including testing strategies and data quality controls) 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)
  • 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
  • Participate in the definition of best practices, standards and procedures for the Enterprise Analytical Data environment including the Extract/Load/Transform (ETL) processes
  • 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 BI Information Management environment in conjunction with Business stakeholders and BI team
  • May mentor the activities of others for BI activities or projects.

Along with their outstanding drive for accomplishment, the successful candidate will bring with them:

· BA/BS in Computer Science, Management Information Systems or equivalent Business degree / work experience
· Minimum 7 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.
· Extensive experience with various data modeling paradigms for both structured and unstructured data
· Extensive experience with various data querying languages (such as SQL and HiveQL)
· Minimum 5 years of experience with Vertica/Teradata databases / tools
· Experience with ETL tools such as Informatica is a plus
· Experience with Hadoop environment is a plus (including Hive, Impala, Sqoop, Spark, etc.)
· Experience with scripting tools is a plus (including unix shell, Python, Ruby, PHP, etc.)
· Familiarity with Business Intelligence tools (including OLAP / Metadata Management / Reporting tools)
· 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 including Information Technology)
· Self-motivated and highly adaptable; ability to work in a fast-paced, dynamic, and changing environment