Global Data Consultants

  • Database Reporting Analyst

    Job Locations US-PA-Carlisle
    Posted Date 3 months ago(1/8/2019 3:15 PM)
    Job ID
    Cara Cianfichi
  • Overview

    GDC IT Solutions is currently recruiting for 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.


    • 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 IT Solutions (GDC) is a full-service Information Technology (IT) company providing solutions that empower businesses to increase employee productivity, maximize investments, and improve operational efficiencies. With experienced and certified professionals, we deliver services in the areas of application development, data center, 24/7 multilingual service desk, desktop lifecycle management, project management, business process consulting, and IT staff augmentation. 

    What Makes GDC Different:

    Our employees are our greatest asset continually driving our success each and every day. We attract and maintain the best talent to provide a personal customer experience at every touchpoint. Our technology professionals care about day-to-day client interactions and resolving customer issues quickly and efficiently, the first time. We deliver services with a code of high ethical responsibility, both to protect our clients and to assure that the work is carried out at the maximum level of professionalism. We are technology experts remaining one step ahead as technology evolves and constantly engaging to understand our clients’ business technology needs in order to deliver the best possible solution. 

    Why Work for GDC?

    • Cutting Edge Technology and Innovation: GDC fully supports and embraces continuing education and industry certifications to stay ahead of trends and remain current within the technology landscape. We recognize that our employees add the real value to our clients and to our business. By approaching our daily operations with a passion for innovation and a shared-learning environment, everyone can make a positive difference.
    • Career Growth: GDC is one of the fastest growing companies in the region!  Sustained growth means ongoing opportunity. Many of our senior leaders have grown within the company, starting with the helpdesk or other entry-level roles to become thought leaders in the fields of IT infrastructure, application development, project management, and business development.
    • Employee-Centric Environment: GDC prides itself on employee satisfaction with a firm belief that happy employees are the most productive employees. In appreciation of our employees and their contributions, we sponsor numerous events throughout the year including an annual gala, golf, lunch barbeques and more.
    • Comprehensive Benefits Package: GDC offers competitive compensation, excellent benefits, and a positive work environment designed around the philosophy of mutual respect. Our comprehensive benefits package includes medical, dental, prescription, vision, 401(k), short and long-term disability, and group life
    • Holiday and Vacation: GDC firmly believes in a comfortable work-life balance, and we offer comprehensive holiday and paid-time-off (PTO) packages.  We provide a generous PTO package, and we encourage our staff to use it — whether it’s for vacation or other personal reasons everyone needs time to relax and refresh.

    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.


    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.