BVA Bear's IT Solutions

Database Analyst – SAP BRIM

BVA Bear's IT Solutions

full-time

Posted on:

Location Type: Hybrid

Location: Middletown • Pennsylvania • United States

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

SQL

About the role

  • 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.
  • Create and maintain data dictionaries, ER diagrams, and metadata repositories.
  • Document database changes, mappings, and query logic using Commission-approved templates.
  • Ensure database operations comply with PCI DSS, SOC1/SOC2, and Commonwealth IT security protocols.
  • Work with DBAs and data migration teams to validate source-to-target mappings during cutover activities.
  • Implement monitoring tools and dashboards for query performance and resource utilization.
  • Troubleshoot and resolve data-related issues; provide recommendations for optimization.

Requirements

  • 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: Applicants must provide proof of U.S. citizenship prior to employment.
Benefits
  • Health insurance
  • Flexible work from home options
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
SQLdatabase analysisquery optimizationdata modelingSAP HANAS/4HANAstored proceduresdata dictionariesER diagramsmetadata repositories