Under the direction of the Director of Technology Applications, the Data Warehouse Developer II will be responsible for developing and implementing queries as a Data Warehouse Developer. The work involves moderate to full-range tasks as assigned by the supervisor in the analysis, design/development and testing of full range of data warehouse activities.  The incumbent will be responsible for data warehouse reporting tools and analysis; applications developed must adhere to specified requirements which satisfy end-user needs and expectations, and meet the objectives of PGCPS.   

 

Perform full Data Warehouse life-cycle systems Implementation, development and support;

Work with clients to understand requirements, GAP Analysis and translate to appropriate technical solution and Documentation;

Develop and test programs using SQL, PL-SQL and SQL-Loader for database applications;

Develop and generate standard Operational Reports (ORS) and ad hoc reporting capabilities from new and existing data sources in a Data Warehouse environment;

Create and run reports using Oracle Discoverer;

Experience using Oracle Business Intelligence (OBI) toolset, BI Answers, Reports and Dashboards, Delivers/Alerts, Business Model-Repository(RPD) and BI Publisher;

Perform full Oracle BI Apps development with OBIEE, ETL Informatica/ODI and DAC;

Experience with eScholar K-20 CDW would be a plus; knowledge of eScholar Data Manager and Pitney Bowes Sagent ETL desirable;

Knowledge of Oracle SOA Suite / Oracle EBS would be a plus;

Knowledge of, and ability to write interfaces between third party systems and Oracle E-Business Suite / SchoolMax Student Information System preferred;

Familiarity with data access regulations such as FERPA desirable;

The ability to work independently as well as in a team environment;

Perform a wide variety of analysis including comparisons, trending and what-if analysis;

Assists with and/or conduct training programs for analysts/developers, consultants and users; and

Updates technical skills and knowledge through continuous self-study, self-discovery, tutorials, and classes.

 

 

Expertise in Oracle (11i/10g) relational database system, SQL, PL/SQL, SQL*Loader, SQL Plus and other Oracle Utilities;

Experience in at least one reporting/OLAP tool e.g. OBIEE 11g/10g, Oracle Express, Cognos;

At least one implementation experience on Oracle BI Apps/Analytics which includes Financial Analytics, HR Analytics or Procurement and Spend Analytics as Oracle EBS 11i/R12 Source

Expertise in Oracle BI Apps (OBIA) toolset which includes OBIEE 11g/10g, ETL-Informatica or Oracle Data Integrator (ODI) and DAC;

Experience in OBIA OOB Prebuilt Reports and Dashboards, RPD and Security model;

Experience in data modeling/analysis and life-cycle development methodology;

Manage unit, system and integration testing for accuracy and performance;

Working knowledge of Data Warehousing or Business Intelligence (BI);

Knowledge of Oracle Designer/2000 or other data modeling tools;

Ability to implement business rules using Oracle procedures, functions and triggers;

The ability to work independently as well as in a team environment;

Team player and the ability to interact well with others;

Strong RPD Development/Dashboard/Report Development Skills;

Ability to write interfaces between third party systems and Oracle ERP and SchoolMax; and

Good communications skills to express business and technical concepts.

 

Bachelor's degree from an accredited college or university in Computer Science or a related field with three to five years of proven record of success as a Oracle Data Warehouse Developer; preferred candidates will have Oracle BI Suite - Enterprise Edition (OBIEE), Oracle Discoverer, Performance Management and Business Process Analysis.

 

 

None Required.



No direct supervisory responsibilities.



The physical demands are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is frequently required to stand, talk, hear, walk, sit, and use fingers, tools or controls. The employee is occasionally required to reach with hands and arms and stoop, kneel, crouch, or crawl. Specific vision abilities required by this job include close vision such as to read handwritten or typed material, the ability to adjust focus, and depth perception. While performing the duties of this job, the employee may occasionally push or lift up to 25 lbs.




The work environment characteristics are representative of those an employee encounters while performing the essential functions of the job.




None.