BVA Bear's IT Solutions · 1 day ago
Database Analyst - SAP BRIM
Boiling Springs, PA 17007
Full-time
Hybrid
Mid Level
3+ years expBVA Bears IT Solutions is seeking an SAP BRIM -Database Analyst to work in the Middletown, PA area. This role involves analyzing, maintaining, and optimizing data structures supporting SAP Billing and Revenue Innovation Management (BRIM) and SAP S/4HANA systems, ensuring data integrity and compliance.
Information Technology & Services
No H1B
U.S. Citizen Only
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
Qualification
Required
Bachelor's degree in Computer Science, Information Systems, or related field
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
Strong SQL and query optimization skills
Knowledge of SAP HANA Studio and data modeling techniques
Understanding of compliance and security frameworks for sensitive data
U.S. citizenship requirement: This position is restricted to U.S. citizens only in accordance with federal contract requirements
Preferred
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
Benefits
Health insurance
Company
BVA Bear's IT Solutions
At BVA Bear’s IT Solutions, we embrace hard work, engage deeply with our customers, and meticulously attend to every detail.
2-10 employees
Funding
Current Stage
Early StageCompany data provided by crunchbase