System Architect II/Java or Oracle

Ouzinkie Native Corporation; Northern (KY); Hybrid; USD 120,000 - 140,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

401(k) Savings Plan

Paid Vacation & Personal Time

11 Federal Holidays

Leave of Absence

Job summary

Ouzinkie Native Corporation seeks a senior technical lead to ensure the Decennial Budget Integration Tool (DBiT) supports the Census Bureau program with robust data architectures and secure DevSecOps practices. You will design, implement, and sustain highly available Oracle and PostgreSQL environments, and guide BI optimization and integration across diverse data systems.

The role involves collaborating with USCB teams to document business requirements in Confluence, migrate schemas to

Qualifications

• Must be able to meet and maintain eligibility for a Public Trust position; US work authorization required.
• Bachelor’s degree in information systems, CS, data science or analytics, engineering, or related field; Master’s preferred.

Responsibilities

• Support the PM to ensure program artifacts are accurate, actionable, and aligned with USCB objectives.
• Design, develop, and improve DBiT implementations, interconnections, and business processes; document modernization recommendations.
• Contribute to Agile Scrum tasks to meet contract deliverables, milestones, and reporting requirements.
• Provide senior-level knowledge on applications, documentation, modernization, and best practices to maintain continuity.
• Support Oracle APEX, Cognos Analytics, Oracle databases, AWS, and migration to PostgreSQL; assist Census DMS migrations.
• Document business requirements and policies in Confluence; update the DBiT data model and data connections.
• Coordinate with USCB customers; ensure regular attendance and perform other duties as assigned.

Skills

Oracle APEX

Cognos Analytics

Java

Angular/React

CI/CD tooling

Jenkins

GitHub

SQL-based environments

AWS

Agile/Scrum

Education

Bachelor's degree in Information Systems, Computer Science, Data Science or Analytics, Engineering, or a related field

Master’s degree (preferred)

Job description

SUMMARY

Responsible for efforts supporting the Decennial Budget Integration Tool (DBiT) Support Services contract with the U.S. Census Bureau. Support the DBiT technical execution strategy by designing and sustaining complex data architectures, including highly available Oracle and PostgreSQL environments, while ensuring seamless data integration, business intelligence optimization, and strict adherence to federal Development, Security, and Operations (DevSecOps) and cybersecurity compliance standards.

ESSENTIAL DUTIES & RESPONSIBILITIES

• Support the PM in ensuring that program artifacts, from strategic plans to weekly status reports, are accurate, actionable, and aligned with USCB objectives.
• Leverage analytical output from business intelligence and systems administration teams to design, develop, and improve DBiT implementations, interconnections, and business processes. Provide formal, documented recommendations for code modernization, assist in implementing automation of manual processes through the CI/CD pipeline, and design or detail the optimization of system architectures.
• Work in an Agile Scrum execution team to ensure all contract deliverables, program milestones, and reporting requirements are met to support program objectives.
• Provide senior-level knowledge related to these applications, associated documentation, modernization, and industry best practices to improve and maintain continuity of program operations.
• Provide senior-level knowledge and experience with Oracle APEX, Cognos Analytics, Java legacy frameworks, Oracle databases, AWS, and Agile development.
• Support schemas, views, and other database functions on the Oracle platform and support migration to the PostgreSQL platform.
• Support the Census Database Migration Service (DMS) team with migration from Oracle 19 to PostgreSQL.
• Work directly with USCB customers to understand and document business requirements, processes, procedures, and policies within Confluence.
• Update Confluence with documentation related to the DBiT data model, database structures, business intelligence optimizations, and external data connections.
• Maintain regular and punctual attendance.
• Perform other duties as assigned.

SUPERVISORY RESPONSIBILITIES

None.

MINIMUM QUALIFICATIONS

• Must be able to meet and maintain eligibility requirements for a Public Trust position in accordance with Department of Commerce and OPM requirements. U.S. work authorization is required.
• Bachelor’s degree in information systems, Computer Science, Data Science or Analytics, Engineering, or a related field. Master’s preferred.
• Eight (8) or more years of progressively responsible experience including software development programs.
• Demonstrated knowledge of Agile / Scrum practices in a Government CI/CD environment.
• Experience producing status reports, staffing plans, and risk communications.

DESIRED QUALIFICATIONS & SKILLS

• Proficiency and demonstrated experience with delivery environments involving Oracle APEX, IBM Cognos Analytics, Java, Angular/React, legacy-code modernization, and CI/CD tooling (Jenkins, GitHub), and/or SQL-based environments.
• Excellent written and verbal communication skills.

WORK SCHEDULE

Full-time. May be required to work additional hours as needed to complete assignment or project.

TRAVEL

The expected travel time is less than 15%.

DRIVING REQUIREMENTS

Must have or be able to attain a valid state driver's license and be insurable on the company’s automobile insurance policy. Driving, with or without accommodation, may be required when traveling for training and/or short occasional amounts of local driving. The expected driving time is less than 15%.

WORK ENVIRONMENT

Work is expected to be remote; however, the company reserves the right to require onsite work.

PHYSICAL DEMANDS

Position consists of sitting for long periods of time, bending, stooping, crouching, and lifting weights up to 20 pounds. Frequently uses hands/fingers for manipulation of keyboard and mouse. It is Katmai's business philosophy and practice to provide reasonable accommodations, according to applicable state and federal laws, to all qualified individuals with physical or mental disabilities.

Compensation & Benefits:

• Pay: $120,000-$140,000 annually
• Eligible Benefits: Medical, Dental, Vision, Life & AD&D Insurance, Long-Term & Short-Term Disability Insurance, 401(k) Savings Plan, Employee Assistance Program (EAP), Vacation & Paid Personal Time, 11 Paid Federal Holidays, and Leave of Absence.

Compliance:

We are a VEVRAA Federal Contractor.

We are an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to age, race, color,religion, sex, sexual orientation, gender identity or national origin, disability status, protected veteran status, marital status, familial status or any other characteristic protected by law.

Preference will be given to Ouzinkie Shareholders, Descendants of Shareholders and Spouses of Shareholders in accordance with Title 43 U.S. Code 1626(g) and Title 42 U.S. Code 2000e - 2(i).