Cogent People
Cogent People
11 – 50 Employees
HealthcareLegalLogistics
Cogent People is an IT and business consulting firm that supports federal and state government agencies with data, software, systems, and organizational transformation. Since 2009, the Columbia, Maryland-based company has worked across data strategy, architecture and integration, analytics and reporting, software engineering, systems operations, program and project management, and business process re-engineering. As a certified 8(a), minority-owned small and disadvantaged business, Cogent People operates in the government contracting sector with a focus on dependable delivery, practical innovation, and lasting value for its customers. Its multidisciplinary work may appeal to professionals interested in technology and consulting roles connected to public-sector programs.

Senior SQL Developer, Oracle PL/SQL

Develop and tune Oracle data systems supporting federal healthcare finance. Manage recurring reports, EDI processing, and modernization of reporting workloads for cloud platforms.

Description

  • Build and operate database processing for a critical federal healthcare finance system.
  • Run scheduled data validation and reporting, delivering accurate results on time.
  • Develop and maintain Oracle PL/SQL packages and procedures.
  • Ingest and validate large XML and EDI files.
  • Load staging and fact tables.
  • Create outbound data files and reconcile results across connected systems.
  • Convert ad hoc client requests into accurate, documented query results and extracts.
  • Explain data findings and discrepancies to stakeholders.
  • Optimize queries on large partitioned tables.
  • Troubleshoot and recover failed batch jobs.
  • Automate repeatable processes that currently rely on spreadsheets.
  • Move changes through formal releases, including testing, security reviews, and approvals.
  • Support production changes.
  • Document processes and systems.
  • Coach junior developers.
  • Help modernize reporting workloads on cloud data platforms.

Requirements

  • Bachelor’s degree in computer science, information systems, or a related field, or equivalent experience.
  • At least six years developing and supporting production Oracle database applications.
  • At least three years in data warehousing, financial transaction processing, or regulatory reporting.
  • Advanced Oracle SQL and PL/SQL, including packages, procedures, cursors, collections, bulk operations, dynamic SQL, exception handling, and job and error instrumentation.
  • Query tuning skills, including execution plans, indexing, and large partitioned tables.
  • Experience working with datasets containing hundreds of millions of rows.
  • XML parsing and loading with XMLTYPE and XMLTABLE.
  • Experience with delimited and fixed-width files, SQL*Loader, and external tables.
  • Working knowledge of healthcare or financial EDI, such as X12 834, 810, 820, 835, or 824, or comparable formats.
  • Enterprise batch scheduling with IBM Workload Scheduler/TWS, Control-M, Autosys, or a similar tool.
  • Linux shell scripting.
  • Python for data automation and report generation.
  • Git-based version control.
  • Familiarity with AWS, particularly Oracle RDS and S3.
  • Experience with agile methods, including SAFe and Scrum.
  • Working knowledge of DevSecOps, CI/CD, formal release management, and change control with documented test evidence.
  • Ability to handle sensitive healthcare and financial data under federal security controls.
  • Strong written and verbal communication.
  • Ability to explain data discrepancies to nontechnical business leads and government stakeholders.
  • Must have lived in the United States for at least three of the past five years.
  • Must be authorized to work in the United States as a citizen, permanent resident, or EAD holder.
  • Public Trust clearance or ability to obtain it.

Benefits

  • Health, dental, and vision insurance.
  • 401(k) plan with matching contributions.
  • Company-paid life insurance and short- and long-term disability coverage.
  • Three weeks of annual paid time off plus 10 holidays.
  • Career development opportunities.
  • Supportive, inclusive culture.
  • Competitive salaries.

Related Jobs