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
Commercial Cleaner
Benefits: ~401(k) matching ~ Bonus based on performance ~ Free uniforms ~ Opportunity for advancement ~ Training & development ServiceMaster is seeking a Part-time Cleaning Technician i…
Tax Manager
Job Description Job Description Tax Manager – Public Accounting | Hybrid or Remote Overview: A top-tier public accounting firm is hiring an experienced Tax Manager to help lead its growing …
Kitchen Line Cook / Kitchen Prep/ Back of House $14 - $22
Description Thank you for your interest in a great career opportunity with Chick-fil-A. Here, you are taking the first step towards a very rewarding career. Every job at Chick-fil-A will prepare y…
Courier/Swing Drvr/CDL-1
Operates company vehicles and provide courteous and efficient delivery and pick up of packages; to check shipments for conformance to FedEx features of service; Provides coverage for all assigned rou…
Join the Team at D1 Training Pittsburgh West 🏆
Benefits: bonus commissions Flexible schedule Training & development Employee discounts Free uniforms Free food & snacks Are You Ready to Lead the Pack? At D1 Training ,…
Water and Fire Restoration Technician
We are looking for Fire & Water Restoration Technicians to work as part of our growing ServiceMaster team. Do you like helping people? ServiceMaster helps restore and rebuild peoples homes and busines…
Healthcare Front Office Coordinator (Floater) -...
Hearing Unlimited, an established private practice in the Eastern Pittsburgh area is seeking an energetic, motivated, and detail-oriented individual to work with our front office operations. This rol…
AFMW - Project Engineer (Hiring Immediately)
Description: DEFINITION The Project Engineer is responsible for planning, coordinating, and executing engineering projects that support the production of high-quality castings using both sand moldin…
Hotel Front Desk Night Auditor
Job Description Job Description Our property is seeking a night auditor to join our growing group of hospitality professionals. The ideal candidate will have strong attention to financial details…