Dicalite Management Group - Conshohocken, PA
posted 3 months ago
Dicalite is seeking a Database Analyst who will play a crucial role in developing financial reporting dashboards and maintaining integrated database systems. The ideal candidate will possess a strong background in financial reporting, advanced knowledge of SQL, and experience with Microsoft SQL Server. This position is pivotal in creating new financial reporting tools and dashboards in One Stream while managing the company's SQL databases to ensure their stability, security, resiliency, and performance. The Database Analyst will be responsible for a variety of tasks including database design, implementation, backup, recovery, and performance tuning. In this role, the Database Analyst will manage and maintain the company's databases, develop and maintain database-related queries, scripts, and stored procedures to support financial reporting and data analysis. The candidate will also build and maintain dashboards in One Stream to visualize financial data, collaborating with various departments to design and implement database solutions that meet business requirements. Proactive monitoring of database performance, resolving issues, and identifying areas for improvement will be key responsibilities. Additionally, the Database Analyst will develop and maintain database security and access controls to ensure data confidentiality and privacy, and provide database support to the organization as needed. The position requires participation in the development and testing of database backup and recovery procedures, as well as documentation of new and existing processes including queries, development workflows, and procedures. The successful candidate will be expected to work independently and as part of a team, demonstrating excellent problem-solving and analytical skills, along with strong written and verbal communication abilities.