Cogent People je svetovalno podjetje za IT in poslovanje, ki zveznim in državnim vladnim agencijam pomaga na področju podatkov, programske opreme, sistemov in organizacijske preobrazbe. Podjetje s sedežem v Columbii v Marylandu od leta 2009 deluje na področjih podatkovne strategije, arhitekture in integracije, analitike in poročanja, programskega inženirstva, sistemskih operacij, upravljanja programov in projektov ter prenove poslovnih procesov. Kot certificirano malo podjetje po programu 8(a), ki je v lasti pripadnikov manjšin in spada med prikrajšana podjetja, Cogent People deluje v sektorju državnih naročil s poudarkom na zanesljivi izvedbi, praktičnih inovacijah in dolgoročni vrednosti za svoje stranke. Njeno multidisciplinarno delo lahko pritegne strokovnjake, ki jih zanimajo tehnološke in svetovalne vloge, povezane s programi javnega sektorja.
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.
Opis
- 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.
Zahteve
- 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.
Ugodnosti
- 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.