SQL and PL/SQL Developer

SQL and PL/SQL
Full Time, perm
$95,000
Telecommuting not available Travel not required

Job Description

Performs data analysis in support of ad-hoc and standing requests from internal and external requestors. Supports a formal Meta Data repository and data quality program to include documenting, monitoring, reporting and analysis. Follows up, researches, and escalates data anomalies as they arise. Provides support to key data suppliers and consumers in addition to internal stakeholders. Adheres to existing development standards and practices, and recommends enhancements to continually improve the Data Management practice.

 ESSENTIAL DUTIES AND RESPONSIBILITIES

  • Performs data analysis in support of ad-hoc and standing requests from internal and external requestors with someassistance
    • Works with requestor to develop and understand request while tracking time and status in the work requestsystem
    • Routinely writes complex SQL and PL/SQL queries to extract results for a wide variety ofdata requests
    • Develops appropriate methodology for collecting, analyzing, and presentingresults
    • Evaluates the findings thoughtfully andthoroughly
    • Documents approach used to retrieve and manipulate data in order to allow reviewand replication ofwork
    • Creates polished reports for consumers of analysis, asneeded
    • Conducts presentations on analysis results including conclusions on the accuracy,usefulness, and completeness of thedata
    • Applies standard statistical methodologies to determine sample sizes, errors rates,standard deviations, and other required data, asneeded

 

  • Supports a formal data quality program to include monitoring, reporting and analysis
    • Creates, edits, and updates documents that describe the elements and flows of the data the organization collects, transforms, and disseminates, as well as the quality standards and specifications the Product Operations department seeks to achieve with thedata
    • Performs assessments of data quality pursuant to standard methodologies and reportsresults using standardformats
    • Performs risk assessments of various aspects of data quality consistent with risk management practices of thedepartment
    • Participates in projects utilizing continuous improvement principles to identify, select, and implement changes to data processes that will improve the quality ofdata
    • Creates, tests, validates, and documents corrections ofdata
  • Supports key data suppliers andconsumers
    • Supports and participates in regular meetings and communications with data suppliers; articulates the needs of the Market Information programs with respect to the quality and nature of the data supplied; seeks to build lasting relationships that will form the basis of continued improvement overtime
    • Meets with key knowledge workers who consume Market Information data; documents and reports on their needs and usage of the data and uses that knowledge to guide the standards of quality the department shouldseek
    • Represents data management as part of an Agile development team providing data analysis,data quality and datastandards
    • Conducts data quality testing to identify errors and inconsistencies on migrated dataand recommends correctivesolution
  • Provides input to management on decisions concerning Data Management projects by providing situation assessments, developing alternative solutions, evaluating risks, costs and benefits, and making recommendations
  • Writes and reviews queries used by back office and call center staff for the execution of standard operating procedures or in support of ordinary activities
  • EDUCATION/QUALIFICATIONS

Bachelor’s degree in business systems, computing or related field. Three to six years of experience in SQL and PL/SQL along with strong technical knowledge and skills in Databases – particularly Oracle 11g, with Stored Procedure development experience. Experience in performance tuning is desired. Ability to write sophisticated queries to extract complex datasets from Oracle and other SQL databases; ability to design, create and populate ad-hoc Oracle databases from a variety of sources to meet analytical goals. Ability to interpret front end issues into SQL scripts for further investigation, root cause analysis, and problem solving, and develop innovative or practical solutions to address these issues. Ability to conduct data quality testing on complex or migrated datain order to identify deficiencies or inconsistencies using innate curiosity, escalate to the correct business owner, and propose resolutions. 

 

For consideration, please submit your resume as a MS Word attachment to careers@consortiuminc.com

The Consortium

"Combining Talent with Technology

" www.consortiuminc.com

Posted By

4922 Fairmont Ave Bethesda, MD, 20814

Dice Id : 10183574
Position Id : 790589
Have a Job? Post it