Database Analyst - SAP BRIM
Job Description
Job Description
Benefits:
- Health insurance
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.
- Education: Bachelors 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.
- Strong SQL and query optimization skills.
- Knowledge of SAP HANA Studio and data modeling techniques.
- Understanding of compliance and security frameworks for sensitive data.
- 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.
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.
Recommended Jobs
School Psychologist K-8
BlueCloud Staffing is seeking a dedicated and compassionate School Psychologist to support a collaborative district in the York area. This is a great opportunity for a professional who enjoys working…
First Shift Part Time Camp Security Guard
Job Description Job Description Benefits: Free uniforms Opportunity for advancement Training & development Unarmed Security Guard Summer Camp (Seasonal) KRE Security, LLC Kunklet…
OTR Flatbed Lease-purchase Job in Lancaster, PA by Eclectic Logistics
Requirements ~Minimum 1 year of CDL-A experience ~Minimum 3 months of flatbed experience ~No more than two moving violati…
Cardiac Catheterization Technologist
Job Summary Are you looking for a fulfilling career, Come join our Heart Institute Team at Geisinger Medical Center (GMC), the nation's first hospital to receive The Joint Commission/American Heart A…
Front Desk/Swim Instructor
*YEAR ROUND ONLY* Saving and changing lives, every single day. We have a mission to teach kids how to swim and be safer, in and around the water, while making their experience GOLDEN! Working for …
Maintenance Mechanic Technician
Job Description Job Description Maintenance Mechanic Technician – 2nd & 3rd Shift A growing food manufacturing facility in the Bucks Country PA area is seeking skilled Maintenance Mechanic Te…
Certified Math Teacher- 5th grade
Location: Philadelphia, PA 19124 Date Posted: 06/09/2026 Category: Education K12 Education: Bachelors Degree Our school client is seeking PA Certified Math Teacher- 5th grade - Philadelphia,…
General Handyman/ Maintenance
Job Title: General Handyman / Maintenance Location: Allentown, PA 18104 (Serving a 50-mile radius) Compensation: Competitive, Based on Experience and Scope of Work Earning Potential: $2,0…
Now Hiring DSPs -Residential Living || Multiple Shifts Available 19090
Job Description Job Description Direct Support Professional (DSP) Residential Living Willow Grove, PA 19090 Competitive Pay Drivers License Required We are currently hiring compassio…
Territory Sales Manager
Territory Sales Manager Job Location: Tullytown, PA. (Mid-Atlantic Region) Category: Full Time Job Start Date: Immediately Responsibilities / Duties: The responsibilities and duties of the Ter…