Global Data Consultants

  • Database Reporting Analyst

    Job Locations US-PA-Carlisle
    Posted Date 2 months ago(5/2/2019 3:23 PM)
    Job ID
    2019-2400
    Recruiter
    Cara Cianfichi
  • Overview

    GDC IT Solutions is currently seeking a Database Reporting Analyst in the Carlisle, PA area.

    Position Overview

    The Database Reporting Analyst will solve complex business problems in a fast-paced environment and will design the warehouse for flexibility and performance. The successful candidate effectively communicates and is comfortable explaining technical concepts to non-technical people.

    Responsibilities

    • Manage all database integrity, structures and reporting.
    • Respond to and support all business requests for data and reporting.
    • Respond to and support of all external client requests for data and reporting.
    • Participate in optimizing database performance.
    • Develop and maintains data dictionary.
    • Develop and maintains all management level reporting for executive management team.
    • Enforce field name, presentation and formatting consistency across all internal and external reports.
    • Coordinate reporting or database impacts of all changes to all environments.
    • Create internal and external ad hoc reporting upon request.
    • Analyze, design, build and support current and new data feeds from various data sources to the data warehouse.
    • Create Entity Relationship models to capture business concepts.
    • Create metadata mappings for technical and process data lineage reporting.
    • Actively participate in the definition and creation of an improved data warehouse environment.
    • Is proactive and a forward thinking person who will address and formulate long range plans based on the business direction.
    • Participate in on-call or after hours support.

    Minimum Qualifications

    • 2-5+ years data analysis, modeling, and design including the use of Erwin or other data modeling tools
    • Expert with SSIS
    • Experience with MS SQL Server
    • Experience with software tools, SSRS, Red-gate, Idera and Power BI a plus
    • Experience with data quality, data profiling, metadata management and reporting
    • Excellent oral and written communication skills is required
    • Knowledge of SQL/MDX/DAX and database concepts in a dimensional large data warehouse environment, including star and snowflake schemas, cubes, dimensions, and measures
    • Understand XML and Data Warehousing concepts

    Preferred Experience

    • MS SQL Server Certification a plus

    What We Do

    GDC is a full-service IT Staffing and Solutions company specializing in the areas of IT talent placement, application development, multilingual service desk, networking and infrastructure, business intelligence, and project management.

    Why Work for GDC?

    • Cutting Edge Technology and Innovation
    • Career Growth Opportunities
    • Employee-Centric Environment
    • Comprehensive Benefits Package
    • Holiday and Vacation

    Equal Opportunity Workplace:

    GDC is proud to be an equal opportunity workplace and is an affirmative action employer. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or Veteran status. All qualified applicants will receive consideration for employment.

     

    Visit our Career Center for the latest employment opportunities.

    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!

    Not ready to apply? Connect with us for general consideration.