Job Title Data Warehouse Developer II
Location Upper Marlboro, MD, US
Organization Name Information Technology/Technology Applications
Department Description
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.
Brief Description
This is an ASASP Unit III Table 900 position Grade 28
Salary Range: $71,896- $144,694
Closing Date: April 27, 2024
Detailed Description DUTIES & RESPONSIBILITIES:
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily.
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.
Job Requirements QUALIFICATIONS:
The requirements listed below are representative of the knowledge, skill, and/or ability required. 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.
EDUCATION REQUIREMENTS:
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. CERTIFICATION REQUIREMENTS:
None required. SUPERVISORY RESPONSIBILITIES:
No direct supervisory responsibilities. PHYSICAL DEMANDS:
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. WORKING ENVIRONMENT:
The work environment characteristics are representative of those an employee encounters while performing the essential functions of the job. ADDITIONAL INFORMATION:
None.
Additional Details
Direct Deposit is expected as a condition of new hire employment.
As a condition of employment, all applicants for employment must be qualified to work in the United States without sponsorship by PGCPS. If you are not work-authorized and would require PGCPS to sponsor you for a work visa you will not be considered for employment.
How To Apply
To submit an application online select apply.
Please provide three (3) current professional references on resume.
Please complete ALL sections and provide applicable details to ensure full consideration. If you need assistance with submitting your application online, please contact the HR Employee Services Center at .
Appropriate accommodations for individuals with disabilities are available upon request.
Minimum Salary
Maximum Salary
Currency USD
Shift Work Preferences
Certified Teacher?
Certification Subject Areas
Amount of Travel
Skills
Skill Minimum Level Maximum Level Desirability
No results found.
