Our Company
Dicalite is a company that uses naturally occurring minerals to improve products used for filtration of liquids such as wine, beer, and swimming pool water, for use in building products such as wallboard, ceiling tile, and joint compound, and for use in creating potting soils and hydroponic growing media for plant growth. Dicalite operates at the intersection of branded consumer products, industrial manufacturing, and research & product development to provide value to over 1,000 customers across the world. Dicalite is privately owned and has been in business for 93 years.
Dicalite’s operating footprint includes 16 facilities across North America and Europe. Operating through a fully integrated network of five mines and twelve refining, processing, and packaging facilities, the company has a unique multi-mineral platform that includes perlite, vermiculite, and diatomaceous earth. Dicalite’s core business is selling wholesale products to blue chip customers such as Home Depot, Scotts Miracle-Gro, Cargill, DuPont, Leslie’s Pool Supplies, numerous California wineries, 3M, and Nestle Purina, among others. In 2021, Dicalite launched a direct-to-consumer line of gardening products. These products are marketed under the Harvest Hero brand name (www.HarvestHero.com).
Broad Function:
The Database Analyst will be responsible for developing financial reporting dashboards and creating and maintaining integrated database systems. The ideal candidate will have a strong background in financial reporting and advanced knowledge of SQL and Microsoft SQL Server. This candidate will be at the forefront of developing new financial reporting tools and dashboards in One Stream and manages our company's SQL databases, ensuring their stability, security, resiliency, and performance.
Primary Responsibilities:
- Manage and maintain the company's databases, including database design, implementation, backup, recovery, resiliency, and performance tuning.
- Develop and maintain database-related queries, scripts, and stored procedures to support financial reporting and data analysis.
- Build and maintain dashboards in One Stream to visualize financial data and support decision-making processes.
- Collaborate with the organization to design, develop, and implement database solutions that meet business requirements.
- Proactively monitor database performance, resolve database issues, and identify areas for improvement.
- Develop and maintain database security and access controls to ensure data confidentiality and privacy.
- Develop integrations to internal and external systems with REST APIs
- Provide database support to the organization and resolve technical problems as needed.
- Participate in the development and testing of database backup and recovery procedures.
- Document new and existing processes including queries, development workflows, and procedures.
- Other duties as assigned.
Minimum Qualifications:
- Bachelor’s degree in computer science, information technology, MIS, or related field.
- 3+ years of experience as a DBA, with a focus on financial reporting
- Strong knowledge of SQL & SQL Server, including stored procedures, views, SSIS & SSAS integrations, SSRS customizations, and optimization best practices.
- Excellent problem-solving and analytical skills.
- Ability to work independently as well as part of a team.
- Excellent written and verbal communication skills.
Preferred Qualifications:
- Hands-on experience with OLAP, OneStream, Power BI, and dashboards development.
- Experience with REST API development and integration.
- Working knowledge of on-premises ERP systems.
Working Conditions:
- Office environment
- This position is mainly sedentary. Primary functions require sufficient physical ability and mobility to work in an office setting.
- Hybrid work schedule.
The above statements are intended to describe the general nature and level of work being performed by employees assigned to this classification. They are not intended to be construed as an exhaustive list of all responsibilities, duties and skills required of employees so classified. Dicalite Management Group, Inc is an Equal Opportunity Employer.
