SQL Data Analyst - Finance

Abarca Health•San Juan, PR

2d•Hybrid

About The Position

Abarca is igniting a revolution in healthcare. We built our company on the belief that with smarter technology we are redefining pharmacy benefits, but this is just the beginning… As Rebates Data & Reporting Analyst you will analyze rebates invoices for manufacturing companies, contractual terms for billing, generate reconciliations and help designing tools to ensure the accuracy and completeness of data related to rebates billing cycle. The process will include reporting for external or internal users. You will also be supporting and collaborating in the new data management in a new repository. This role will also be providing full support of data element maintenance in the new reporting and analytics repository and help define new policies and procedures related to the collection and data accuracy, transformation of data to keep track of all rebates data flow in Abarca. The fundamentals for the job… Continually collaborates with business and technology stakeholders to identify needs and opportunities for improved data and analytics solutions and delivery, business processes and tasks that can be automated, and to understand the underlying data resources and their relationship to deliver actionable data driven insights and decision support. Generate, review, analyze, and send out rebates reporting to external stakeholders, internal clients, manufacturer companies related to pharmacy and medical rebates for Commercial, Medicare and Medicaid line of business. Provide analytical support for rebates process management for all lines of business (3 rd party aggregator, In-House, MDRP and ASES). Ability to do research, investigate discrepancies, and propose as well as develop solutions. Perform complex root-cause analysis of issues identified in rebates reports. Gather necessary data to pinpoint problem areas on which to focus, validating that the analysis is data driven, recommending, and implementing solutions and evaluating those results, and implementing controls to monitor consistent use of the solution. Perform assessment and communicate critical information gathered by the reporting tools. Identify, analyze, and interpret trends or patterns in complex data sets. Assist in preparation of monthly management reports, accompanying schedules, worksheets and narratives, and quarterly and annual regulatory filings. Assist in the development, testing and maintenance of data architecture, ETL/ELT processes, logical and physical data models in alignment with business requirements. Support data modeling for new rebate data design in Snowflake. Identify manual processes that can be automated and participate in developing processes to eliminate manual dependencies and incorporate necessary QA steps to minimize and identify errors. Participates in initiatives or projects that support process improvements, or the integration of data/other applications into existing systems. Support rebate information requests from clients; ad-hoc financial reports for clients and partners, as needed. Provide reporting as well as perform querying, testing, development, and validation of data. Provide support to business and technical users regarding rebates process and develop complex QA processes to ensure data compliance with established procedures. Collaborates with rebates team and technical resources to identify and address data quality issues when they arise. Provide necessary supporting documentation of findings. Support data integrity process, including data extraction, storage, manipulation, processing, and analysis; verify the completeness, timeliness, and accuracy of data; work with a variety of data files to ensure all rebate data is accurately loaded to the systems with proper support documentation. Track and document all requests, issues, deliverables to provide reporting and updates on a weekly basis to your manager and team. Interacts with internal and external members to accomplish goals. Communicate complex findings and conclusions in an easy-to-understand way, as well as ability to manage tight deadlines and competing priorities to ensure timely deliveries. Perform other duties and special projects as assigned.

Requirements

Bachelor’s or Master’s degree in computer science, engineering, or a related field. (In lieu of a degree, equivalent relevant work experience may be considered).
3+ years of relevant work experience in PBM or pharmaceutical rebate management.
3+ years of professional experience with SQL and reporting tools (i.e., Snowflake, Microsoft BI, Tableau, QlikView).
Experience in designing, reporting, and delivering analytical solutions.
Experience managing complex reconciliation processes.
Experience leveraging tools for reporting and analytics (e.g. Excel, SSRS, PowerBI).
Excellent oral and written communication skills.
Spanish is a plus.
We are proud to offer a flexible hybrid work model which will require certain on-site work days (Puerto Rico Location Only)
This position requires availability to work in a specified time zone or working schedule, accommodating the business needs of our clients and team members.
This position may require availability for on-call hours, including evenings, weekends, and holidays, to promptly address emergent issues or provide necessary support as dictated by operational demands (if applicable).

Nice To Haves

Experience in a role within a financial field, Business Intelligence or Analytical team.
Experience in healthcare industry, claims processing, Commercial, Medicare and Medicaid line of business and Pharmacy rebates, claims processing and data interchange.

Responsibilities

Continually collaborates with business and technology stakeholders to identify needs and opportunities for improved data and analytics solutions and delivery, business processes and tasks that can be automated, and to understand the underlying data resources and their relationship to deliver actionable data driven insights and decision support.
Generate, review, analyze, and send out rebates reporting to external stakeholders, internal clients, manufacturer companies related to pharmacy and medical rebates for Commercial, Medicare and Medicaid line of business.
Provide analytical support for rebates process management for all lines of business (3 rd party aggregator, In-House, MDRP and ASES).
Ability to do research, investigate discrepancies, and propose as well as develop solutions.
Perform complex root-cause analysis of issues identified in rebates reports.
Gather necessary data to pinpoint problem areas on which to focus, validating that the analysis is data driven, recommending, and implementing solutions and evaluating those results, and implementing controls to monitor consistent use of the solution.
Perform assessment and communicate critical information gathered by the reporting tools.
Identify, analyze, and interpret trends or patterns in complex data sets.
Assist in preparation of monthly management reports, accompanying schedules, worksheets and narratives, and quarterly and annual regulatory filings.
Assist in the development, testing and maintenance of data architecture, ETL/ELT processes, logical and physical data models in alignment with business requirements.
Support data modeling for new rebate data design in Snowflake.
Identify manual processes that can be automated and participate in developing processes to eliminate manual dependencies and incorporate necessary QA steps to minimize and identify errors.
Participates in initiatives or projects that support process improvements, or the integration of data/other applications into existing systems.
Support rebate information requests from clients; ad-hoc financial reports for clients and partners, as needed.
Provide reporting as well as perform querying, testing, development, and validation of data.
Provide support to business and technical users regarding rebates process and develop complex QA processes to ensure data compliance with established procedures.
Collaborates with rebates team and technical resources to identify and address data quality issues when they arise.
Provide necessary supporting documentation of findings.
Support data integrity process, including data extraction, storage, manipulation, processing, and analysis; verify the completeness, timeliness, and accuracy of data; work with a variety of data files to ensure all rebate data is accurately loaded to the systems with proper support documentation.
Track and document all requests, issues, deliverables to provide reporting and updates on a weekly basis to your manager and team.
Interacts with internal and external members to accomplish goals.
Communicate complex findings and conclusions in an easy-to-understand way, as well as ability to manage tight deadlines and competing priorities to ensure timely deliveries.
Perform other duties and special projects as assigned.