Back to Job Search

Oracle/MS SQL Server Analyst

  • Location: Richmond, Virginia, 23219
  • Job Type:Contract

Posted about 2 months ago

Terrific Contract Opportunity!

Position: Oracle/MS SQL Server Analyst

Location: Richmond Virginia 23219

Term: 4 months

Day-to-Day Responsibilities:

  • Work with staff to develop baseline business requirements for dashboard / other reports as necessary.
  • Evaluate staff requests for new / modified processes and / or systems in support of reporting and dashboarding needs.
  • Determine best method for extracting data from host relational systems, ingest it into appropriate data mart(s), and organize it to best support reporting requirements.
  • Work with staff to determine optimal schedule for data processing.
  • Document all work, but not limited to all and, functional and technical requirements, ERDs, data flow diagrams, scripts, and report definitions.
  • Identify, and mitigate the effect of, incorrect or poorly formatted data through programmatic means.

 

Is this a good fit? (Requirements):           

  • 5+ years of experience and ability to translate between business requirements and technical / functional specifications.
  • 5+ years of experience and proven ability to communicate effectively with teams of varying technical and business expertise (examples of written communication strongly desired).
  • 5+ years of experience and functional knowledge in, and experience with, a range of technical capabilities including but not limited to: Relational and dimensional data modeling.
  • 5+ years of experience in Oracle or Microsoft SQL Server DBMS (experience with both preferred).
  • 5+ years of experience in ETL processing - experience with WhereScape preferred.
  • 3+ years of experience in Tableau, Socrata, or similar.
  • 3+ years of experience in R, Python, SAS.
  • 3+ years of experience and PL-SQL or T-SQL (experience with both preferred).
  • B.A. or B.S. in computer-related or data-related discipline, or equivalent experience.

Even better if you are:                         

  • Conversant in a range of business-specific areas, including but not limited to: Medical coding (ICD9 and ICD10).
  • Conversant in a range of business-specific areas, including but not limited to: Public health risk factors.
  • Conversant in a range of business-specific areas, including but not limited to: Quantitative data analysis.
  • Conversant in a range of business-specific areas, including but not limited to: Fatality Surveillance and/or research.
  • Have 2+ years of experience with GIS-related software / systems.
  • Have 2+ years of experience with SPSS.
  • M.A. or M.S in computer-related, data-related, or public-health related discipline.

If this sounds like the perfect fit, apply today!