Senior Data Platform & BI Architect

Primma,-LL

Village of Roslyn (NY)

On-site

USD 145,000 - 155,000

Full time

14 days+

Application generator

A complete application in a minute — tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Primma is seeking a Senior Software Developer for an on-site role in Roslyn, NY. The role requires deep experience with data warehouses, ETL, reporting, and secure integrations, providing technical leadership and mentoring to the team.

Responsibilities include designing and implementing database solutions, developing executive dashboards with SAP BusinessObjects, Power BI, and Tableau, and collaborating with cross-functional teams to deliver projects.

Qualifications

Bachelor’s degree in Computer Science, Software Engineering, Information Technology, or a related field.
5+ years' experience 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 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.

Responsibilities

Provide production support, development and implementation with respect to 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.
Understand Origami Risk backend data structure and relationship between tables.
Create and maintain Origami Risk batch jobs.
Create and maintain data transfer shell scripts in Linux OS.
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, data models 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 operation.
Analyze database environments and suggest methods 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.