Cogent People este o firmă de consultanță IT și de afaceri care sprijină agențiile guvernamentale federale și statale în domeniul datelor, software-ului, sistemelor și transformării organizaționale. Din 2009, compania cu sediul în Columbia, Maryland, activează în domenii precum strategia datelor, arhitectura și integrarea, analiza și raportarea, ingineria software, operațiunile sistemelor, managementul programelor și proiectelor, precum și reproiectarea proceselor de afaceri. În calitate de întreprindere mică certificată în cadrul programului 8(a), deținută de persoane aparținând minorităților și clasificată ca întreprindere defavorizată, Cogent People activează în sectorul contractelor guvernamentale, punând accent pe livrarea fiabilă, inovația practică și valoarea durabilă pentru clienții săi. Activitatea sa multidisciplinară poate fi de interes pentru profesioniștii interesați de roluri în tehnologie și consultanță asociate programelor din sectorul public.
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.
Descriere
- 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.
Cerințe
- 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.
Beneficii
- 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.