Velocity Staff

  • Data Analyst

    Location US-KS-Leawood
    Posted Date 2 months ago(1/10/2019 12:07 PM)
    # Positions
    1
  • Overview

    Velocity Staff is working with our client located in Overland Park, KS to identify a Data Analyst to join their team. The right candidate will be responsible for working with IT architects and project teams to translate business requirements into data model designs, creating data mappings, performing data analysis, and ensuring data quality that enable the strategic information objectives of the company.

    Responsibilities

    • Create new and edit existing logical and physical models, XML, file formats - using ER/Studio, XML Spy or other equivalent enterprise tools.
    • Identify, analyze and profile data sources.  
    • Create standard SQL to query, update, insert, and delete data. Creates Stored Procedures.
    • Work with business and technical teams toward solution. The ability to extract and document data requirements to fulfill business need or requirement.
    • Promote and apply client enterprise architecture best practices and standards at a project, program and department level.
    • Adhere to best practice and data governance standards. This includes the use of the toolset provided by the enterprise.
    • Ensure the use of industry and internal data standards and internal enterprise data services.

    Qualifications

    • Proficient in data modeling for both transactional and dimensional data warehouse databases.
    • Proficient in creation of ETL mappings; mapping of tables, files, XML schemas, etc. from source to target.
    • Working experience of a standard data modeling tool-set, working knowledge of ER/Studio a strong plus.
    • Data mining skills (including data auditing, aggregation validation and reconciliation).
    • Ability to work with SQL databases including working SQL knowledge of SQL Server and/or Netezza DBMS a plus.
    • Data Analysis experience with data profiling and data validation.
    • Data Quality understanding of DQ concepts and familiarity with DQ tools and methods.
    • Communicate with customers to obtain data requirements and perform data analysis on data provided.
    • Knowledge of or exposure to Hadoop Platform and data components like Hive, Hbase, Impala a strong plus.
    • Knowledge of real-time analytics and BI platforms.
    • Strong oral and written communication and presentation skills.
    • Ability to communicate complex findings and ideas in plain language.
    • Ability to work with teams toward a shared goal.
    • Ability to change direction quickly based on data analysis.
    • Ability to pro-actively seek clarification of requirements and directions.
    • Bachelor’s degree in computer science, engineering or networking related technologies or commensurate experience.
    • Possess or has made progress toward receiving a TDWI or CDMP Certification or equivalent experience.
    • Minimum 5+ years work experience.
    • 3+ years of experience using Data Modeling tools.
    • 2+ years of project management experience.

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Connect With Us And We Promise Not To Overwhelm Your Inbox!

    Not ready to apply? Connect with us to learn about future opportunities.