Senior Software Developer

This is an on-site position located in Roslyn, NY.

About the Role

The Senior Software Developer works closely with business operations to gather and analyze specifications and requirements. The position requires strong hands-on experience in data warehouse technologies, ETL processing, reporting and analytics, enterprise application integration, and automation. The developer will design and implement scalable database solutions, executive dashboards, Origami Risk customizations, and secure integrations with third-party vendors while providing technical leadership, mentoring team members, and driving architecture and best practices.

Responsibilities

• Provide production support, development, and implementation for PRIMMA’s data warehouse/database environments, SAP reporting application, and any supporting environments and tools.
• Drive architectural decisions and contribute to long-term technology strategy in partnership with the IT team and leadership.
• Design, develop, and maintain database solutions using Oracle and SQL Server.
• Write complex SQL queries, stored procedures, and ETL transformations to support various applications and reporting needs.
• Work with the Origami Risk application to customize and enhance its functionality, including understanding its backend data structure and table relationships.
• Create and maintain Origami Risk batch jobs and data transfer shell scripts in Linux OS.
• Develop and maintain user interfaces using JavaScript and related technologies.
• Create and manage mail merge templates to automate document generation.
• Develop, maintain, and enhance business reports and dashboards using SAP BusinessObjects, Power BI, and Tableau to support operational and executive reporting.
• Analyze business and operational data to identify trends, provide actionable insights, and present information in a meaningful format for executive leadership.
• Design, develop, and support system integrations with third-party vendors using secure file transfer technologies (SFTP), automated file processing, and data exchange workflows.
• Create, monitor, and troubleshoot automated data exchange processes to ensure reliable integration between internal applications and external vendor systems.
• Collaborate with cross-functional teams to gather requirements, design solutions, create source-to-target mappings, and ensure project delivery.
• Act as a go-to technical expert and mentor to junior and mid-level developers.
• Create innovative solutions to automate business operations and analyze database environments to improve operational efficiency and scalability.
• Assist with planning and performing database upgrades and updates.
• Create and maintain technical documentation as it relates to specific applications.
• Other duties as assigned.

Requirements

• Bachelor’s degree in Computer Science, Software Engineering, Information Technology, or a related field.
• Minimum 5 years of experience with Oracle or SQL Server, including packages, procedures, and functions.
• Minimum 2 years of experience developing business intelligence applications and reports using SAP BusinessObjects, Power BI, and/or Tableau.
• Strong analytical and problem-solving skills with the ability to interpret complex data, identify trends, and present actionable insights to executive management.
• Demonstrated experience leading technical projects, mentoring junior developers, and providing technical guidance to development teams.
• Experience integrating enterprise applications with third-party vendors using file transfer technologies such as SFTP, secure file exchange, and automated batch processing.
• Experience with Linux shell scripting and automation of file transfer processes is highly preferred.
• Experience with the Origami Risk application is a plus.
• Experience in the insurance, financial services, or other regulated industries is a plus.
• Good knowledge of database/data warehouse modeling and design concepts.
• Experience with programming languages such as C#, .Net, Java, or Python (preferred).
• Proficiency in JavaScript and user interface development.
• Proven experience in creating mail merge templates.
• Familiarity with source control tools, GIT preferred.
• Ability to maintain effective working relationships with departments, employees, management, and clients.
• Ability to function in a professional office environment and utilize standard office equipment.

Pay

The actual compensation for this position will be determined by experience and other factors permitted by law.