Data Analyst--------------Only US citizens and GC------Need Locals

Job description

Job Title: Data Analyst Division: Operations and Technology Location: Washington, DC Only US citizens and GC 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 MSRB 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 MSRB 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. Knowledge of the municipal securities industry and the role of the MSRB as well as the interdependencies of the MSRB and other regulatory and enforcement agencies are preferred. 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. If you are interested please share your resume to Preethib@usmsystems(dot)com or can directly call me on 703 468 0398 USM Business Systems Inc. is a quickly developing worldwide System Integrator, Software and Product Development, IT Outsourcing and Technology assistance supplier headquartered in Chantilly, VA with off-shore delivery centers in India. We offer world-class ability in giving most astounding quality and administrations through industry best practices planned to convey remarkable worth to our customers. Utilizing our industry knowledge, administration service offering expertise and innovation abilities, we distinguish new business and innovation slants and create answers for help customers around the globe, giving top of the line solid and practical IT benefits which are cost effective services. Established in 1999, the organization has corner qualities in building and dealing with a Business Oriented IT environment with rich involvement in technology innovation, ERP and CRM counselling, Product Engineering, Business Intelligence, Data Management, SOA, BPM, Data Warehousing, SharePoint Consulting and IT Infrastructure. Our other offerings include modified solutions and administrations in ERP, CRM, Enterprise architecture, offshore advisory services ,e-commerce, Social , Mobile, Cloud, Analytics (SMAC) and DevOps. USM, a US ensured Minority Business Enterprise (MBE) is perceived as one of the fastest developing IT Systems Integrator in the Washington, DC zone. Most as of late, USM was positioned #9 on the rundown of the Top administrations organizations in the DC Metro Area – Washington Business Journal (2011). We are a project-driven firm that reliably meets the IT needs of our State and Government customers through development and business keenness.