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 data—especially 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). Bachelor’s 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.