• Sr. Data Analyst

    Location US-PA-Audubon
    Posted Date 5 months ago(6/28/2018 11:30 AM)
    Job ID
    # Positions
    Information Technology
  • General Position Summary

    The (Sr.) Data Analyst is responsible for leading, planning and coordinating PJM’s data design efforts, from the investigation of all required data sources for completeness and accuracy, through implementation of the completed design. This includes the routines used to obtain, transform, and store the requisite data. The data analyst is responsible for:

    • the architecture and design of all database objects in business systems, data warehouses and associated data marts (tables & ETL routines)
    • working with business owners to understand business data flows and optimize the organization, reporting and visualization of this data per business requirements
    • implementation of business intelligence tools to enable effective access to the data in systems and tools that require it
    • ensuring the satisfaction of all business intelligence users by frequently inquiring as to their evolving data needs and making sure their requests for additional data are handled in a timely and efficient manner

    Essential Duties and Responsibilities

    • Customer Solution - Understand the development needs of the business units and establish a positive, service-oriented relationship by ensuring timely and accurate delivery of application systems
    • Establish and maintain high client satisfaction levels
    • Document, track and resolve problems to meet client’s needs
    • Solution delivery - Design and implement data marts per business requirements
    • Design and implement the structures needed to support complex business data analysis and reporting
    • Support the design and implementation of BI and Data Management strategies.
    • Implementation of data archiving strategy according to the DW / BI Lifecycle Management process.
    • Assist with overall design and modeling of the PJM Information Warehouse logical model.
    • Work with business owners to understand their requirements and physical design and model.
    • Assist with data architecture, data modeling and tuning
    • Develop and maintain physical data model diagrams
    • Provide support to the development effort by helping developer to identify and address performance problems
    • Participate in the development and review of standards associated with data warehouse design, security and implementation
    • Determine and document conceptual and technical requirements for data warehouse systems and data marts
    • Demonstrate the ability to plan, execute, and complete complex analyses on schedule and within budget.
    • Ensure quality of implementation of Golden Gate replication from the source system to the PJM Information Warehouse / MOD.

    Characteristics and Qualifications


    • BS, Computer Science, Management Information Systems or equivalent work experience
    • At least 5 years of experience data warehousing concepts and support tools with data modeling and data structure design/supporting Oracle 11g/12c in an AIX/UNIX environment: SAP PowerDesigner / Erwin or other data modeling tool, Oracle Enterprise Manager (OEM) and Various Oracle development tools (SQL*Plus, Toad)
    • Ability to produce high-quality work products with attention to detail
    • Ability to visualize and solve complex problems
    • Ability to apply analytical and mathematical solutions
    • Experience with conceptual and logical data modeling including developing and maintaining data model diagrams (ERD), facilitating structured data modeling meetings
    • Experience designing and building business intelligence architectures including data marts, data warehouses, and reporting and analysis applications
    • Experience with MS Suite of Business Intelligence Tools including SSIS, SSRS, SSAS
    • Experience with SQL Tools, such as SQL Navigator, TOAD, SQL*Plus
    • Experience with Oracle 11g database management system


    • MS, Computer Science
    • Experience with PJM operations, markets, and planning functions
    • Experience with Alteryx and SAS Experience with visualization and reporting tools such as Tableau, SAS Visual Analytics, Qlik etc Experience in end to end delivery and lifecycle of analytical business solutions


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

    Need help finding the right job?

    We can recommend jobs specifically for you! Click here to get started.