Senior Solution Engineer

Roman Health Pharmacy LLC

Town of Florida (NY)

On-site

USD 90,000 - 120,000

Full time

14 days+

Get more replies from employers

Send a job-specific resume in minutes.

Benefits offered by this job

Comprehensive medical, dental, and vision coverage

Retirement savings program with employer support

Paid time off and holidays

Job summary

Roman Health Pharmacy LLC is seeking a Senior Solution Engineer to support reporting systems administration and technical engineering initiatives. This multifaceted role includes designing, developing, and maintaining reports and dashboards, collaborating with cross-functional teams to develop reporting solutions, and managing technical coordination with vendors.

The ideal candidate will possess strong expertise in Microsoft T-SQL and Power BI, along with solid database knowledge and exceptional communication skills. This position provides a competitive compensation aligned with experience and robust benefits.

Qualifications

BS/MS degree in Computer Science, Engineering or related subject.
Solid knowledge of database and SQL.
Excellent communication skills.

Responsibilities

Collaborate with teams to understand data needs and develop reporting solutions.
Design, develop, and maintain reports using Power BI.
Manage technical coordination with third-party software vendors.

Skills

Microsoft T-SQL

Power BI

Database management

API integration

ETL processes

Analytical problem-solving

Education

BS/MS in Computer Science or related field

Tools

SQL databases

Reporting tools

Job description

Position Summary

We are seeking a Senior Solution Engineer to support reporting, systems administration, and technical engineering initiatives within a growing organization. This role is responsible for designing, developing, and maintaining reports and dashboards, supporting system configuration and integrations, and partnering with internal stakeholders to deliver scalable technical solutions. The ideal candidate brings strong expertise in Microsoft T‑SQL, reporting tools such as Power BI, and systems/process improvement in a fast‑paced environment.

Responsibilities

50% Reporting:
- Collaborating with cross‑functional teams to understand data needs and develop reporting solutions.
- Write reports in report writing tools, with various backend databases (primarily SQL), including queries and reports to meet data feed and report requests.
- Design, develop, and maintain reports using reporting tools such as Power BI.
- Develop custom code to automate report generation and data extraction tasks.
- Identify and troubleshoot data quality issues and ensure data accuracy and consistency.
- Develop and maintain ETL processes to support data reporting.
- Identify opportunities to improve data reporting processes and workflows.
50% Sys Admin / Engineering:
- Design, write, maintain, support, test, debug, implement, and improve interfaces and custom processes.
- Configure and support new workflows, processes, and system enhancements within the organization's HRIS environment.
- Manage technical coordination with third‑party software vendors and implementation partners.
- Maintain internal and external applications with a focus on employee and client‑facing self‑service tools.
- Identify user needs and create new, innovative processes or feature solutions.
- Set up file feeds and scheduled tasks using internal tools and platform capabilities.
- Assist API internal integrations and external integrations with vendors and clients.
- Collaborate with cross‑functional teams to identify and design APIs that meet business needs.
- Ensure the quality and scalability of our APIs through testing and performance tuning.
- Document API usage and provide support to internal and external stakeholders.
- Speak with and collaborate with a variety of people, such as clients, vendors, management, and information technology (IT) staff during system creation and maintenance.
- Engage in quality control procedures to ensure that systems are efficient and operational.

Qualifications

Education & Experience:
- BS/MS degree in Computer Science, Engineering or a related subject or equivalent experience.
- Solid database/SQL knowledge.
- Excellent communication skills.
- Ability to design solutions to solve business problems.
Skills & Competencies:
- Advanced SQL and Database Expertise: Demonstrates strong proficiency in T‑SQL, stored procedures, query writing, troubleshooting, and relational database concepts.
- Business Intelligence and Reporting: Designs, develops, and maintains accurate, scalable reports and dashboards using Power BI and related reporting tools.
- Data Integration and ETL: Supports data extraction, transformation, loading, and automation processes to deliver reliable reporting and system outputs.
- API and Systems Integration: Understands system connectivity, API design support, vendor integrations, and data exchange requirements across platforms.
- Analytical Problem‑Solving: Evaluates technical and business issues, identifies root causes, and develops practical, efficient solutions.
- Data Quality and Accuracy: Maintains a high standard of accuracy, consistency, and validation across reports, interfaces, and system processes.
- Technical Communication: Communicates complex technical concepts clearly to business users, internal teams, clients, and external vendors.
- Project and Priority Management: Manages multiple requests, deadlines, and technical initiatives effectively in a fast‑paced environment.
- Documentation and Process Improvement: Creates clear technical documentation and identifies opportunities to improve reporting, integrations, and workflows.
- Collaboration and Stakeholder Partnership: Works effectively with cross‑functional teams including IT, operations, vendors, and business stakeholders to deliver solutions that meet business needs.

Work Environment

This position is primarily office‑based, with work performed on a computer in either a corporate office or remote home office setting. The role may require participation in virtual or in‑person meetings, training sessions, and occasional business‑related events. The organization is committed to providing an accessible and inclusive work environment, and reasonable accommodations will be made in accordance with applicable law.

What We Offer

Competitive Compensation