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.

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.

Database Analyst – SAP BRIM

Key skills