Business Analyst

Position Description

The Business Analyst (BA) uses their extensive knowledge of query language skills (SQL, PL/SQL etc.) and their background in statistical data analysis to help customers and stakeholders with ad-hoc data calls. This position will work at a strategic level with all levels of business and technical subject matter experts in the elicitation, modeling, documentation and management of data and business and systems requirements. The Business Analyst will be accountable for providing leadership and direction to ensure the appropriate collection of data; documentation of information; and presentation of findings. The BA will provide ad-hoc query support, create reports, and provide support to users who use the business intelligence tools. The primary work location will be in Washington DC with some travel to Rockville and Chantilly.

Responsibilities

  • Provide Ad-Hoc Query Support: This activity involves helping customers and stakeholders with ad-hoc data calls. It can include custom report generation, data analysis, and the creation of temporary, custom data marts.
  • Recurring Data Quality Reports: This activity involves generation of bi-weekly data quality reports to data providers.
  • Provide Data Analysis Tools Support: Provide guidance and technical support to customers and stakeholders who want to use business intelligence tools provided (assisting with configuration, and providing overviews of the tools).
  • Gathers and documents reporting requirements from business owners and/or business analysts, prepares functional and technical design documents.
  • Supports user acceptance testing of new data warehouse features.
  • Create database queries (SQL, PL/SQL etc.) with Oracle 11g and other databases.
  • Help the client with root cause analysis of Production data integrity issues. Create queries that will resolve the integrity issues.
  • Works closely with end-users to gather report requirements and ensure proper testing/validation.
  • Supports user acceptance testing on production data loading and new features.
  • Using Business Objects and similar reporting tools creates scheduled and ad hoc reports, and develops reports according to the software development lifecycle.
  • Train end-users on report creation.
  • Interfaces with data providers to ensure data is submitted in the correct format.
  • Gathers, reviews and edits requirements, specifications, business processes and recommendations related to proposed solution.
  • Supporting the client through early problem detection, idea generation, and advising on "best practices."
  • Assist the Program Manager in project management including plan, estimate, coordinate and execute system developmental projects, feasibility and cost/benefit and return on investment studies.
  • Works collaboratively with other entities to achieve program success.
  • Assist with developing proposals, work plans, schedules, and implementation strategies.

Required Experience

  • Background in Statistical Data Analysis
  • Must possess strong query language skills (SQL, PL/SQL etc.) with Oracle 10g or above — at least 2 years’ experience with query language (SQL, PL/SQL etc.) with Oracle 10g, 11g
  • US citizenship required
  • Must be able to achieve a Clearance
  • Minimum 2 years overall experience and an advanced degree
  • Experience working with federal agencies
  • Must have strong foundation in business intelligence tools and Decision Support Systems
  • Strong, end-to-end understanding and experience with knowledge of system development life cycles
  • Strong written and verbal communication skills
  • Ability to take little direction and achieve quality results independently
  • Strong customer service focus
  • Work well as part of a team
  • The ability to multi-task, prioritize commitments and manage time effectively
  • Attention to detail and follow-through
  • History of ethical performance

Technical Competencies

  • Proficient with MS Office Tools (e.g., Outlook, Word, Excel, Project, PowerPoint, Visio)
  • See ‘Required Elements’

Behavioral Competencies

  • Results Orientation
  • Customer Service Orientation
  • Highly self-motivated, self-directed, and attentive to detail
  • Teamwork and Commitment
  • Analytical Thinking

Desired Elements

  • Previous experience in federal government HR systems
  • Previous experience federal retirement data
  • Previous experience with federal shared service centers
  • Agile and SCRUM Methodology
  • BS, Computer Science, Mathematics

U.S. Equal Employment Opportunity/Affirmative Action Information

Individuals seeking employment at COE are considered without regards to race, color, religion, national origin, age, sex, marital status, ancestry, physical or mental disability, veteran status, or sexual orientation. You are being given the opportunity to provide the following information in order to help us comply with federal and state Equal Employment Opportunity/Affirmative Action record keeping, reporting, and other legal requirements.

Please Note: Completion of this form is voluntary

Completion of the form is entirely voluntary. Whatever your decision, it will not be considered in the hiring process or thereafter. Any information that you do provide will be recorded and maintained in a confidential file.

Gender:

  • Male
  • Female
  • Decline to self identify

Ethnicity:

  • Hispanic or Latino - A person of Cuban, Mexican, Puerto Rican, South or Central American, or other Spanish culture or origin, regardless of race.

Race:

  • White - A person having origins in any of the original peoples of Europe, the Middle East, or North Africa.
  • Black or African American - A person having origins in any of the Black racial groups of Africa.
  • Native Hawaiian or Other Pacific Islander - A person having origins in any of the original peoples of Hawaii, Guam, Samoa, or other Pacific Islands.
  • Asian - A person having origins in any of the original peoples of the Far East, Southeast Asia, or the Indian subcontinent including, for example, Cambodia, China, India, Japan, Korea, Malaysia, Pakistan, the Philippine Islands, Thailand, and Vietnam.
  • American Indian or Alaska Native - A person having origins in any of the original peoples of North and South America (including Central America), and who maintains tribal affiliation or community attachment.
  • Two or More Races - All persons who identify with more than one of the above races.
  • Decline to Self Identify

Veteran Status

  • Special Disabled Veteran - You are considered a disabled Veteran if you are entitled to disability compensation under laws administered by the Veterans Administration for disability rated at a 30 per cent or more; or were discharged or released from active duty for a disability incurred or aggravated in the line of duty while serving in the United States Armed Forces at any time.
  • Vietnam Era Veteran - A person who served on active duty for more than 180 days and was discharged or released other than dishonorably, any time in the Republic of Vietnam between February 28, 1961, and May 7, 1975; or between August 5, 1964 and May 7, 1975 in all other cases; or was discharged or released from active duty for service connected disability if any part of such act of duty was performed in the Republic of Vietnam between February 28, 1961, and May 7, 1975; or between August 5, 1964 and May 7, 1975 in all other cases.
  • Newly Separated Veteran - Any veteran who served on active duty in the U.S. military, ground, naval or air service during the one-year period beginning on the date of such veteran's discharge or release from active duty. To clarify, Newly Separated Veterans are considered as such during the year after they are released or discharged from active duty.
  • Other Protected Veteran - Person who served on active duty during a war (e.g. Korea), campaign (e.g. Desert Shield/Storm) or expedition (e.g. Persian Gulf, Panama) for which a campaign badge has been authorized.
  • Not a Veteran.
  • Decline to Self Identify

 

Submit Your Resume