Database Analyst - SAP BRIM

BVA Bear's IT Solutions

Boiling Springs, PA

Apply

JOB DETAILS

SKILLS

Agile Programming Methodologies, Analysis Skills, Application Programming Interface (API), Atlassian JIRA, Best Practices, Billing, Business Analysis, Computer Science, Computer Security, Cryptography, Data Analysis, Data Migration, Data Modeling, Data Quality, Data Structures, Database Analysis, Database Programming, Database Technology, Documentation, Equal Employment Opportunity (EEO), Health Insurance, Identify Issues, Information Technology & Information Systems, Information/Data Security (InfoSec), Metadata, Microsoft ADO (ActiveX Data Object), PCI-DSS, Performance Analysis, Performance Management, Process Analysis, Quality Monitoring, Query Optimization, Reporting Dashboards, Resource Utilization, Revenue Management, SAP, SQL (Structured Query Language), Security Compliance, Security Protocols, Stored Procedures, Test Data, Transportation Modeling, United States Citizen

LOCATION

Boiling Springs, PA

POSTED

30+ days ago

Benefits:

Health insurance

BVA Bears IT Solutions is seeking an SAP BRIM -Database Analyst to work in the Middletown, PA area. This is a full time position with at least 2 days on-site and
possibly 3 days remote.

As the Database Analyst you will analyze, maintain, and optimize data structures supporting SAP Billing and Revenue Innovation Management (BRIM) and SAP S/4HANA systems. This role ensures data integrity, performance, and compliance for high-volume subscription, billing, and invoicing processes. The analyst collaborates with DBAs, data engineers, and business teams to deliver accurate reporting, efficient queries, and secure data handling aligned with SAP best practices and Commonwealth standards.

Key Responsibilities:

Data Analysis & Optimization
Analyze SAP BRIM database schemas (SOM, CI, CC) and recommend improvements for performance and scalability.
Develop and optimize SQL queries, views, and stored procedures for reporting and analytics.
Monitor data quality and integrity across transactional and analytical systems.
Reporting & Documentation
Create and maintain data dictionaries, ER diagrams, and metadata repositories.
Document database changes, mappings, and query logic using Commission-approved templates.
Compliance & Security
Ensure database operations comply with PCI DSS, SOC1/SOC2, and Commonwealth IT security protocols.
Apply role-based access and encryption for sensitive data.
Collaboration & Support
Work with DBAs and data migration teams to validate source-to-target mappings during cutover activities.
Assist business analysts and SMEs with data extraction for testing and reporting.
Performance Monitoring
Implement monitoring tools and dashboards for query performance and resource utilization.
Troubleshoot and resolve data-related issues; provide recommendations for optimization.

Qualifications:

Education: Bachelor’s degree in Computer Science, Information Systems, or related field
Experience: 3+ years in database analysis or development within enterprise systems.
Hands-on experience with SAP HANA and S/4HANA databases; familiarity with BRIM data structures.

Skills:

Strong SQL and query optimization skills.
Knowledge of SAP HANA Studio and data modeling techniques.
Understanding of compliance and security frameworks for sensitive data.

Preferred Skills:

SAP HANA or BRIM certifications.
Experience with utilities or transportation industry data models.
Familiarity with Agile/Hybrid methodologies and tools like ADO/JIRA.
Knowledge of SAP BTP for event-driven architecture and API management.

U.S. Citizenship Requirement:
This position is restricted to U.S. citizens only in accordance with federal contract requirements. Applicants must provide proof of U.S. citizenship (such as a U.S. passport, birth certificate, or Certificate of Naturalization) prior to employment. Non-citizens, including lawful permanent residents (Green Card holders), are not eligible for this role.

Equal Employment Opportunity:
BVA Bears IT Solutions is committed to providing equal employment opportunities. All qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, gender, sexual orientation, gender identity, age, disability, genetic information, military/veteran status, or any other characteristic protected by law.

Database Analyst - SAP BRIM

BVA Bear's IT Solutions

Boiling Springs, PA

About the Company

BVA Bear's IT Solutions

Resume Resources