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
Quality Assurance Lead
Job Title: Quality Assurance Lead Location: PA - Pittsburgh, TX - Dallas, OH - Strongsville, AL - Birmingham, AZ - Phoenix Type: Contract Compensation: Contractor Work Model: Onsite – ons…
Board-Certified Neurological Surgery
Dane Street is expanding our physician panel! We are seeking a skilled and board-certified Neurological Surgeon to join our team for Independent Medical Record Reviews. This is a fully remote opportu…
Laborers
Pipeline Excavation is growing fast, and we’re looking for dependable, hardworking individuals to join our team. If you’re ready to build a career, learn valuable skills, and be part of a company th…
Toddler Teacher
Now Hiring: Two-Year-Old Teachers (Lead & Assistant). The Goddard School – Spring House, PA. The Goddard School in Spring House is growing, and we are looking for passionate, energetic Early C…
Environmental Project Manager
Join the Canacre team in an exciting role working on leading edge infrastructure projects. We are technical experts in land, energy, and transportation development delivering accurate, innovative…
ServiceNow Business Process Consultant
We Are: A global professional services organization, which includes being a vital services partner to the world’s major cloud providers — ServiceNow, AWS, Azure, Google, and others. Choose Accenture…
ABA/RBT/PCA therapist - Part-Time Flexibility
Discovery Therapy, company that truly cares for our family of therapists, is seeking ABA-PCA, RBT, Personal Care Assistant (PCA) to join our Early Intervention team! Discovery Therapy is seeking a…
Maintenance Technician - Student Housing
JOB PURPOSE: Depending on the size of a community, the community may have an Assistant Maintenance Supervisor who oversees the Maintenance Technicians, assists the Maintenance Supervisor with admi…
Travel Radiology Cath Lab Tech Job
Job Overview TLC Nursing Associates, Inc. is seeking an experienced Cardiac Catheterization Laboratory (Cath Lab) Technologist to assist in cardiac catheterizations, angioplasties, electrophysi…
Senior Manager, eCommerce Fan Services - Philadelphia, 19109
Senior Manager, eCommerce Fan Services - Philadelphia, 19109, United States of America Famehouse, a division of UMG, is the preeminent leader in D2C solutions in music, defining & delivering the ind…