CLEARANCE: Secret **Active Secret clearance required upon application.** REQUISITION NUMBER: 022718.09-A2 FUNCTIONAL / LABOR CATEGORY: Database Analyst POSITION TITLE: Subject Matter Expert I/II LOCATION: Crystal City, Virginia DESCRIPTION: To support and maintain the Department of Army’s General Fund Financial Statement Audit. This is a part of a large-scale effort with emphasis on the Army’s General Fund financial statement auditability initiatives. The data reconciliation team is responsible for ERP and legacy system data clean up and reconciliation to ensure the universe of transactions of data are accurate for audit testing. We are currently seeking a Database Analyst to support the various DoD full financial statement audit improvement efforts of this team.
EDUCATION: • Bachelor’s degree OR certification required
LABOR CATEGORY / DUTIES: • Reconciliation of a large amount of data between ERP and legacy feeder systems. • Identify irregularities within data transactions and identify causes of the issues. • Data extraction and data uploading within systems.
REQUIREMENTS: • At least four (4) years of demonstrated work experience. • Federal Financial Management / Accounting background and experience. • Design and develop Oracle database stored procedures, functions, views and triggers. • Strong knowledge of SQL, PL/SQL with ability to write and tune complex queries. • Design and develop ETL Source analysis, mappings, workflows and metadata management using Informatica. • Capture audit information during all phases of the ETL process. • Write and maintain documentation of the ETL processes via process flow diagrams. • Conduct appropriate functional and performance testing to identify bottlenecks and data quality issues. • Administer and monitor ETL repositories. • Working knowledge of UNIX/LINUX servers.
Founded in 2011, Sehlke Consulting is a rapidly-growing Service-Disabled Veteran-Owned Small Business (SDVOSB) and Historically Underutilized Business Zone (HUBZone) headquartered in Arlington, VA – an Equal Opportunity Employer that values the strength diversity brings into the workplace. Individuals with Disabilities and Protected Veterans are encouraged to apply.