„Cogent People“ yra IT ir verslo konsultacijų įmonė, padedanti federalinėms ir valstijų valdžios institucijoms duomenų, programinės įrangos, sistemų ir organizacinių pokyčių srityse. Nuo 2009 m. Kolumbijoje, Merilando valstijoje, įsikūrusi įmonė dirba duomenų strategijos, architektūros ir integracijos, analitikos ir ataskaitų rengimo, programinės įrangos inžinerijos, sistemų operacijų, programų ir projektų valdymo bei verslo procesų pertvarkymo srityse. Kaip sertifikuota 8(a) įmonė, taip pat mažoji, mažumos valdoma ir nepalankioje padėtyje esanti įmonė, „Cogent People“ veikia valstybinių sutarčių sektoriuje, daugiausia dėmesio skirdama patikimam įgyvendinimui, praktinėms naujovėms ir ilgalaikei vertei klientams. Įvairiapusė įmonės veikla gali sudominti specialistus, besidominčius technologijų ir konsultavimo pareigomis, susijusiomis su viešojo sektoriaus programomis.
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.
Aprašymas
- 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.
Reikalavimai
- 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.
Privalumai
- 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.