About the Role
The Senior Software Developer will gather and analyze specifications and requirements, design and implement scalable database solutions, executive dashboards, Origami Risk customizations, and secure integrations with third-party vendors. This role also involves providing technical leadership, mentoring team members, and driving architecture and best practices.
Responsibilities
- Provide production support, development, and implementation for data warehouse/database environments, SAP reporting application, and supporting tools.
- Drive architectural decisions and contribute to long-term technology strategy.
- Design, develop, and maintain database solutions using Oracle and SQL Server.
- Write complex SQL queries, stored procedures, and ETL transformations.
- Customize and enhance the Origami Risk application.
- Understand Origami Risk backend data structure and table relationships.
- Create and maintain Origami Risk batch jobs.
- Create and maintain data transfer shell scripts in Linux OS.
- Develop and maintain user interfaces using JavaScript and related technologies.
- Create and manage mail merge templates for automated document generation.
- Develop, maintain, and enhance business reports and dashboards using SAP BusinessObjects, Power BI, and Tableau.
- Analyze business and operational data to identify trends and provide actionable insights.
- Design, develop, and support system integrations with third-party vendors using secure file transfer technologies.
- Create, monitor, and troubleshoot automated data exchange processes.
- Collaborate with cross-functional teams to gather requirements, design solutions, and ensure project delivery.
- Act as a technical expert and mentor to junior and mid-level developers.
- Create innovative solutions to automate business operations.
- Analyze database environments and suggest methods to improve efficiency and scalability.
- Assist with planning and performing database upgrades and updates.
- Create and maintain technical documentation.
Requirements
- Bachelor’s degree in Computer Science, Software Engineering, Information Technology, or a related field.
- Minimum 5 years' experience with Oracle or SQL Server, using 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.
- Demonstrated experience leading technical projects, mentoring junior developers, and providing technical guidance.
- 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 utilizing various programming languages (C#, .Net, Java, Python preferred).
- Proficiency in JavaScript and user interface development.
- Proven experience in creating mail merge templates.
- Familiarity working with source control tools, GIT preferred.
- Must demonstrate 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.
Skills
- Data Warehouse Technologies
- ETL Processing
- Reporting and Analytics
- Enterprise Application Integration
- Automation
- Oracle
- SQL Server
- SQL Queries
- Stored Procedures
- ETL Transformations
- Origami Risk
- Linux Shell Scripting
- JavaScript
- SAP BusinessObjects
- Power BI
- Tableau
- SFTP
- C#
- .Net
- Java
- Python
- GIT
Location
- Roslyn, NY
Work Type
- On-site
Experience Level
- Senior
- Minimum 5 years' experience Oracle or SQL Server
- Minimum 2 years of experience developing business intelligence applications and reports
Education Level
- Bachelor’s degree in Computer Science, Software Engineering, Information Technology, or a related field.
Salary/Compensations
- The actual compensation for this position will be determined by experience and other factors permitted by law.
