Database Developer - I (USD)

$123,365 - $123,365/Yr

Spectraforce Technologies - Holtsville, NY

posted about 1 month ago

Full-time - Entry Level
Remote - Holtsville, NY
Administrative and Support Services

About the position

The Database Developer position at SPECTRAFORCE is a critical role within the Corporate Finance team, specifically focusing on the Oracle Database Application Analyst responsibilities. This position is designed for individuals with a minimum of 2 years of experience in database application development or administration, particularly within the financial services sector. The primary function of this role is to maintain and enhance internal financial reporting database applications that support the Actuarial department's needs for life insurance financial and valuation reporting. As a Database Application Analyst, you will be responsible for implementing and enhancing database applications for both new and existing life insurance products. This includes automating reporting requirements, ensuring the successful monthly load of the data warehouse, and creating control processes. You will also be tasked with producing various reports, including automated reports and ad hoc analyses. A significant aspect of this role involves translating complex business and actuarial requirements into programming specifications and technology solutions, necessitating collaboration with business, finance, and technology teams. In addition to application development, this role includes providing production support, specifically L2 and L3 support for FMD Oracle database applications. The ideal candidate will possess a strong understanding of Oracle databases, proficiency in SQL and PL/SQL, and experience with Linux operating systems, along with excellent communication and analytical skills. This position is remote and is expected to last for 12 months, offering a dynamic work environment where you can contribute to the financial systems database team.

Responsibilities

  • Maintain and enhance internal financial reporting database applications for life insurance.
  • Implement and enhance database applications for new and existing products.
  • Automate reporting requirements and ensure successful monthly data warehouse loads.
  • Create control processes and produce various reports, including automated and ad hoc analyses.
  • Translate complex business and actuarial requirements into programming specifications and technology solutions.
  • Collaborate with business, finance, and technology teams to meet project goals.
  • Provide L2 and L3 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.
  • Familiarity with TOAD for database management.
  • Advanced Excel skills, including VLookup and macros.
  • Knowledge of scheduling tools such as ESP/Stonebranch UAC preferred.
  • Familiarity with MS-Access and Python preferred.
  • Business knowledge of Life Products is a plus.
  • 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.
  • Familiarity with MS-Access and Python preferred.

Benefits

  • ACA compliant health benefits
  • Dental insurance
  • Vision insurance
  • Accident insurance
  • Critical illness insurance
  • Voluntary life insurance
  • Hospital indemnity insurance
  • Commuter benefits
  • 401K plan with matching
  • Referral bonus program
  • Paid sick leave when required by law
  • Unpaid leave.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service