Technical Products Analyst

Orlando Health•Orlando, FL

12d•Hybrid

About The Position

The Technical Products Analyst plays a key role in supporting data-driven decision-making by designing, maintaining, and optimizing analytical tools, databases, and applications. This role combines strong technical expertise in SQL, Excel, and database management with analytical problem-solving and cross-functional collaboration to support product operations and enhance system performance. The primary responsibility of this role is to investigate reported issues, work with users to understand the problem, and document requirements for a potential solution. The individual must be able to understand how the application processes and utilizes data, identify the root cause of the issue, and determine whether the resolution requires a data correction, a code fix, or a system enhancement. Based on the findings, the role is responsible for documenting requirements and creating the appropriate work requests to ensure the issue is addressed by the appropriate team.

Requirements

Strong proficiency in SQL (queries, stored procedures, performance tuning)
Advanced Excel skills, including complex formulas and VBA
Experience with Microsoft Access and relational databases
Bachelor's degree in computer science, system analysis or a related study.
Associate’s degree and two (2) years of directly related work experience may substitute for the Bachelor’s degree (in addition to the requirements listed in the Experience section).
High School Diploma or equivalent and four (4) years of directly related work experience may also substitute for the Bachelor’s degree (in addition to the requirements listed in the Experience section).
Minimum of two (2) years of experience in at least two IT solution development disciplines, including technical architecture, network management, application management, middleware, database management or operations.
Some experience/exposure with solutions and products (Laboratory, Imaging, Supply Chain, Revenue Cycle, Allied Health, and other healthcare related disciplines).

Nice To Haves

Familiarity with performance optimization techniques in SQL and data modeling
Working knowledge of data integration and reporting tools
Experience and understanding of one of these spaces: Compensation, Payroll, Finance.
Strong problem-solving and troubleshooting skills
Ability to analyze and translate business requirements into technical solutions

Responsibilities

Design, develop, and maintain complex Excel models used for payment calculations, ensure accuracy, scalability, and efficiency of all analytical models and reporting tools.
Manage SQL database objects, and maintain Microsoft Access databases.
Understand product capabilities (future and current state); determine product or system design and change requirements to help drive the business or clinical unit’s targeted outcomes.
Assist with implementation of a product solution or solutions within a group of specific clinical or business applications or technologies based on enterprise business strategy, business capabilities and business requirements.
Manage the architecture for a scope of products, working closely with business and clinical architects that manage and design architecture for a single project or initiative.
Provide consulting support to business or clinical architects within projects to ensure the project is aligned with the overall enterprise architecture.
Monitor the current-state solution portfolio to identify deficiencies through aging of the technologies used by the application, or misalignment with business requirements.
Understand technology trends and the practical application of existing, new, and emerging technologies to enable new and evolving business and operating models.
Understand, advocate and augment the principles of information technology strategies.
Analyze the business-IT environment (run, grow and transform the business) to detect critical deficiencies, and recommend solutions for improvement (systems of record, differentiation and innovation).
Understand the product industry, competitors and market trends, and determine their potential impact on the solution.
Understand the principles, guidelines, standards and solution patterns to ensure solution decisions are aligned with the enterprise's future-state architecture vision.
Assist with understanding of product roadmap for the evolution of the enterprise application portfolio from current to future state (as defined by the solutions architecture).
Participate in the evaluation and selection of software product standards and services, as well as the design of standard and custom software configurations.
Consult with application and infrastructure development projects to fit systems or infrastructure to architecture and identify when it is necessary to modify projects to accommodate the solutions architecture.
Identify the business or clinical unit impact (for example, on skills, processes, structures or culture) and financial impact of the solutions architecture.
Document all solution design and analysis work.
Work closely with the program/project managers to ensure the execution of work corresponds with what is being promised.
Maintains reasonably regular, punctual attendance consistent with Orlando Health policies, the ADA, FMLA and other federal, state and local standards.
Maintains compliance with all Orlando Health policies and procedures.
Provide Level 2 support on assigned products or product suite.
Participates in On-Call support rotation.