Oracle PL/SQL Developer-- JASDC5783881

Job Description • The Enterprise Analytics and Data Services team requires (1) a consultant proficient in the design and development of Oracle SQL. PL/SQL, analytical models, tools, and programs. This consultant must have advanced experience interpreting business data requirements and developing complex SQL queries, PL/SQL programs and have experience in Pension, Health Insurance, Customer Service, Finance, and/or Risk. This should include a strong understanding and experience with information technology, business intelligence development, change management best practices, project management, and system development lifecycle fundamentals. The consultant will support high volume data extract requests from internal program areas, data extracts needed to fulfill Public Records Act requests, court orders, legal requests, audit requests, data extracts needed to fulfill Employer Data Extract requests, and data extracts that support public-facing reports such as the Annual Comprehensive Financial Report (ACFR). The consultant will perform data extracting, transforming, and validating for various enterprise customers. The consultant will also work on developing Pension data marts to fulfill reoccurring Pension data requests. Qualifications • At least five (5) years of experience supporting the design and development of analytical models, tools, or programs using Oracle tools • At least five (5) years of experience with interpreting requirements and developing complex PL/SQL and SQL • Proven ability to reason logically and creatively and use a variety of analytical and research techniques to solve complex problems; visualize data sets; analyze situations and propose an effective course of action; analyze data; identify the need for and provide creative thinking related to complex problems, develop and evaluate alternatives. • At least five (5) years of experience in some or all areas of Pension and Health Insurance.