Principal Data Solutions Analyst

Job Summary :

The Senior Database Analyst plays a critical role in ensuring data integrity, optimizing database performance, and delivering analytical insights to support strategic business decisions. This role involves advanced data modelling, database development, performance tuning, and collaborating with cross-functional teams to turn raw data into actionable intelligence.

Key Responsibilities :

• Design, implement, and optimize complex SQL queries, stored procedures, and data models for reporting and analytics.
• Analyze large and complex datasets to identify trends, anomalies, and opportunities for process improvements.
• Maintain and improve database performance through indexing, partitioning, query optimization, and monitoring.
• Collaborate with business stakeholders to gather data requirements and translate them into technical solutions.
• Develop and maintain documentation related to database systems, data definitions, and reporting logic.
• Support ETL (Extract, Transform, Load) processes, ensuring data accuracy and consistency across systems.
• Troubleshoot database-related issues and recommend long-term solutions.
• Ensure compliance with data governance, security, and privacy standards.
• Mentor junior analysts or developers and contribute to team knowledge sharing.

Qualifications :