Data Analyst

SQL; data; reports; Oracle
Full Time
$80-87K
Telecommuting not available Travel not required

Job Description

Data Analyst

EnvoyIT has an immediate opening for a Full-time Data Analyst with a solid and growing client in Washington, DC.  EnvoyIT’s client deals with large amounts of financial data and is looking for a self-starter who is proficient with SQL (PL/SQL is a plus) to join their fast-paced team. 

Summary:

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 some assistance o Works with requestor to develop and understand request while tracking time and status in the work request system

o Routinely writes complex SQL and PL/SQL queries to extract results for a wide variety of data requests o Develops appropriate methodology for collecting, analyzing, and presenting results

o Evaluates the findings thoughtfully and thoroughly o Documents approach used to retrieve and manipulate data in order to allow review and replication of work

 o Creates polished reports for consumers of analysis, as needed o Conducts presentations on analysis results including conclusions on the accuracy, usefulness, and completeness of the data

o Applies standard statistical methodologies to determine sample sizes, errors rates, standard deviations, and other required data, as needed

 · Supports a formal data quality program for Programs to include monitoring, reporting and analysis

o 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 the data o Performs assessments of data quality pursuant to standard methodologies and reports results using standard formats

o Performs risk assessments of various aspects of data quality consistent with risk management practices of the department o Participates in projects utilizing continuous improvement principles to identify, select, and implement changes to data processes that will improve the quality of data

o Creates, tests, validates, and documents corrections of data

  • Supports key data suppliers and consumers

o 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 over time

 o 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 should seek

o Represents data management as part of an Agile development team providing data analysis, data quality and data standards o Conducts data quality testing to identify errors and inconsistencies on migrated data and recommends corrective solution

 · 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
  • Pursues ongoing skill and knowledge development to extend the range and depth of knowledge and skills, within the scope of assigned duties
  • Stays abreast of rules and their impact to the data that is analyzed
  • Performs other duties as assigned

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 data in order to identify deficiencies or inconsistencies using innate curiosity, escalate to the correct business owner, and propose resolutions.

Continuously learns and stays current with industry changes, trends, and relevant activities of other regulatory and enforcement agencies. Identifies, analyzes, and resolves problems in connection with defined objectives.

Generates or identifies innovative and practical solutions to address those problems.

Effectively adjusts to new priorities, processes, requirements and/or environments. Responds quickly to change and facilitates the acceptance of change.

Ability to work in a positive and constructive manner with others to achieve organizational and individual goals.

Commits to and holds self-accountable for individual and group goals when working on a team. Listens to others, seeks to understand what is being said, and reflects that understanding appropriately.

Demonstrates and conveys information clearly and precisely using both written and oral means to inform, persuade, or compel others to action.

Takes action to ensure objectives are achieved and all requirements are satisfied. Quickly overcomes obstacles to achieve objectives in a timely and accurate manner. Successfully engages in multiple initiatives simultaneously.

Candidates must be authorized to work in the US without sponsorship.  EnvoyIT’s client is unable to sponsor H-1b visas at this time.

Qualified candidates please send resumes in Word format to:  abecker@envoyit.com

 

 

 

 

 

 

 

Posted By

Amy Becker

Dice Id : 10177475
Position Id : 726
Have a Job? Post it