Alex Lee

  • Information Analyst

    Job Locations US-NC-Hickory
    Posted Date 1 week ago(1 week ago)
    Requisition ID
    2018-39834
    # of Openings
    1
    Category
    Information Technology
    Company
    Alex Lee
  • Overview

    The Information Analyst will work alongside business partners to model scalable, flexible, and resilient data architectures in support of the analytic and business intelligence environments. This role will bring knowledge of data and understanding of the power of data to create optimal technical solutions that can be delivered effectively to business partners who consume the data.  The Information Analyst will use strong problem solving skills and curiosity to assist business partners to use data to find solutions to complex business problems.  They will develop and own processes required to extract, transform, clean, and move data into a data warehouse, data mart, or operational data store.  They will develop and implement logical and physical data models, ETL scripts, metadata definitions and models, queries and reports, schedules, work processes, and maintenance procedures.

    The Information Analyst will use relational and multi-dimensional designs to deliver required data for use in analytics.  They will assist business partners with report and dashboard development.

    Responsibilities

    1) Create a robust, sustainable data architecture that supports analytic requirements
    2) Work with business users to identify and understand source data systems
    3) Map source system data to data warehouse models
    4) Develop and test extraction, transformation, and load (ETL) processes
    5) Adapt ETL processes to accommodate changes in source systems and new business user requirements
    6) Install, configure, deploy, troubleshoot and tune BI and Analytic tools and analytic servers
    7) Create reporting standards, report templates and dashboards
    8) Ensure proper backup and recovery processes are in place

     

    Qualifications

    1) Understanding of SQL Cognos and relational and multidimensional designs
    2) Strong problem-solving and metadata skills
    3) Knowledge of data warehousing architectural approaches
    4) Translation of business questions and requirements into reports, views, and BI query objects
    5) Knowledge of BI tool architectures, functions, and features
    6) Technical design including conceptual and analytical skills
    7) Data modeling, database administration, and performance tuning
    8) Ten + years of information technology experience
    9 ) Five + years working with relational databases (Oracle, SQL) Cognos, ETL Tools, UNIX and Windows

    Options

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