Previous Job
Previous
Product Owner
Ref No.: 18-57803
Location: Chantilley, Virginia
Position Type:Contract
Start Date: 08/10/2018
 ESSENTIAL DUTIES & RESPONSIBILITIES
 
  • Design, develop, implement, and validate ETL processes.
  • Work with business users to clarify ETL requirements and business rules.
  • Create and execute unit test plans based on system and validation requirements.
  • Troubleshoot, optimize, and tune ETL processes.
  • Document all ETL-related work per clients methodology.
  • Maintain existing code and fix bugs whenever needed.
  • Ensure that timelines of loading/validating data are met.
  • Collaborate with various functional business units to gather reporting requirements.
  • Create ad-hoc and automated reporting solutions.
  • Performs other related duties and special projects as assigned.
 
CORE COMPETENCIES / KNOWLEDGE & SKILL REQUIREMENTS
 
  • Expertise with developing an ETL lifecycle to support enterprise-wide data processing projects (i.e., Enterprise Data Warehouse).
  • Strong database-related development skills (complex SQL queries, complex store procedures and user-defined functions in SQL Server).
  • Strong experience with Microsoft SSIS
  • In depth knowledge with data analysis, data modeling and data mart design skills.
  • Ability to synthesize data from various sources and perform various types of data analysis.
  • Experience with standard regulatory reporting requirements such as HEDIS measures.
  • In-depth knowledge of industry standard health data code sets such as ICD-9/ICD-10, CPT/HCPCS, revenue codes, and NDC (Pharmacy).
  • Knowledge of EDI file formats and processing.
  • Strong organization, time management and multi-tasking abilities.
  • Solid analytical skills and problem solving skills with the ability to formulate and communicate recommendations for improvement.
  • Have the ability to work effectively with others and have good interpersonal skills.
  • Be highly organized and work well under pressure.
  • Must be willing to accept responsibility and to show good judgment, initiative, and resourcefulness.
 
EDUCATION, EXPERIENCE & TRAINING REQUIRED
 
  • Bachelor's degree in Computer Science or equivalent experience.
  • 5+Years of ETL developer experience using SSIS or Pervasive tools.
  • 5+Years of SQL Server experience.
  • 5+Years of proven ability to interpret data in order to locate anomalies and recommending corrections plans.       
  • 5+Years of advanced SQL skills (SQL Server).
  • 1+Years with HIPAA/EDI X12 4010/5010 healthcare-related file formats including 834, 837, and NCPDP formats.