What are the responsibilities and job description for the Database Analyst - SAP BRIM position at BVA Bear's IT Solutions?
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.
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.
Flexible work from home options available.