Senior Business Applications Analyst

Job Description

This role is responsible for the analysis implementation and ongoing support of the Enterprise Data Archive program. The position ensures long-term data retention accessibility compliance and performance optimization across enterprise applications by supporting archival strategies data extraction processes and analytical reporting needs.

This position may be remote hybrid or on-site based on candidate preference and business needs.

Essential Duties and Job Functions

• Serve as a Senior Analyst for the Enterprise Data Archive team supporting archived data access integrity performance and compliance.
• Configure maintain and support the Galen system including archived data sources metadata and user access.
• Partner with application and database teams to define data archival strategies retention schedules purge policies and access patterns aligned with legal compliance privacy and business requirements.
• Ensure archived dataespecially data containing Protected Health Information (PHI)is managed in accordance with healthcare privacy security and organizational governance standards.
• Support data extraction transformation and loading (ETL) processes related to archival and retrieval of historical data.
• Analyze source system data models to ensure accurate mapping data lineage and reliable retrieval within the archival environment.
• Assist with litigation holds regulatory inquiries and compliance investigations involving archived data.
• Develop and maintain documentation for archival processes data mappings query logic retention rules and operational procedures.
• Work with business users and analysts to support historical reporting and inquiry needs while minimizing performance impact to source systems.
• Participate in onboarding new applications or data domains into the enterprise archive including requirements gathering data profiling testing reconciliation and production support.
• Stay current on data archival best practices database technologies and Galen enhancements.

Qualifications

• 5 years of experience in business application analysis data management database or reporting roles with a strong data focus.
• Experience with enterprise data archival solutions or long-term data retention platforms (Galen preferred).
• Experience working with large relational databases (Oracle SQL Server or similar platforms).
• Bachelors degree in Information Technology Computer Science Data Analytics or related field or equivalent work experience.
• Understanding of data lifecycle management data retention policies and regulatory/compliance requirements.
• Experience supporting audit compliance or privacy-driven data requests.
• Healthcare industry experience strongly preferred.
• Working knowledge of HIPAA PHI handling requirements and healthcare data privacy principles preferred.
• Familiarity with ETL processes data integration and data governance concepts preferred.

Skills and Attributes

• Strong analytical and problem-solving skills with a high level of attention to detail.
• Advanced SQL and data validation capabilities.
• Ability to translate business legal and compliance needs into technical data solutions.
• Effective communicator with both technical and non-technical stakeholders.
• Proven ability to balance data accessibility with strict privacy and regulatory requirements.
• High level of discretion and professionalism when handling sensitive healthcare data.
• Self-directed accountable and able to manage multiple priorities.
• Strong documentation and organizational skills.
• High personal integrity aligned with organizational values.