Database Developer - I (USD)

Ampcus - New York, NY

Full-time

New York, NY

Professional, Scientific, and Technical Services

About the position

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team as a Database Developer. The position is based in the United States, NY, and requires the candidate to work on-site. The Database Application Analyst will play a crucial role in the Corporate Finance department, specifically within the Financial Systems database team. This team is responsible for providing the data warehouse that supports life insurance financial and valuation reporting for the Actuarial department. The Database Application Analyst position is responsible for maintaining and enhancing our internal financial reporting database applications for life insurance. This includes the implementation and enhancements for new and existing products, automation of reporting requirements, and ensuring the successful monthly load of the data warehouse. The role also involves creating control processes, producing reports (including automated reports), and conducting ad hoc analyses. The analyst will translate complex business and actuarial requirements into programming specifications and technology solutions, collaborating closely with business, finance, and technology teams. In addition to application development, this role includes production support, providing Level 2 and Level 3 support for FMD Oracle database applications. The ideal candidate will have a strong background in database application development or administration, with a focus on Oracle technologies and a solid understanding of financial systems in the life insurance sector.

Responsibilities

• Maintain and enhance internal financial reporting database applications for life insurance.
• Implement and enhance new and existing products in the database applications.
• Automate reporting requirements and ensure successful monthly data warehouse loads.
• Create control processes and produce reports, including automated reports and ad hoc analyses.
• Translate complex business and actuarial requirements into programming specifications and technology solutions.
• Collaborate with business, finance, and technology teams to deliver effective solutions.
• Provide Level 2 and Level 3 support for FMD Oracle database applications.

Requirements

• 4-year college degree with a minimum of 2 years in a database application development or database administrator role preferred.
• Proficiency in Oracle (11g/19c) including Oracle SQL, PL/SQL, SQL*Plus, and SQL*Loader.
• Experience with LINUX OS including shell scripting.
• Advanced Excel skills (e.g., VLookup/macros).
• Knowledge of scheduling tools (ESP/Stonebranch UAC) preferred.
• Familiarity with MS-Access and Python preferred.
• Business knowledge of Life Products.
• Ability to work on multiple projects with a sense of urgency and adaptability to changing priorities.
• Excellent oral and written communication skills.
• Strong interpersonal, organizational, and analytical skills with a problem-solution attitude.
• Detail-oriented with a comprehensive approach to validating and proofing deliverables.

Nice-to-haves

• Knowledge of scheduling tools (ESP/Stonebranch UAC) preferred.
• Knowledge of MS-Access and Python preferred.