Cube Hub - Rancho Cordova, CA
posted 2 months ago
We are seeking a skilled Business Intelligence Developer/Database Administrator to join our team in Rancho Cordova, California. This position is primarily virtual, with the expectation of being onsite two days per week. The role is designed for a duration of 12 months and focuses on the technical design and development of business intelligence database solutions that support Tableau and Power BI analytics dashboards and reports. The successful candidate will gain a comprehensive understanding of business requirements and will be involved in various stages of the development process, including functional specification write-ups, prototyping, development, quality testing, user acceptance testing, roll-out, and post-launch enhancements implementation. As a Database Administrator, you will be responsible for managing and maintaining SQL server databases, which includes monitoring and troubleshooting batch jobs, managing access roles, and supporting overall server management and patches. This role requires a proactive approach to ensure that data sources are accurate, available, and timely, and involves close collaboration with upstream application teams and developers. You will also be tasked with developing complex SQL queries, collaborating with front-end business intelligence developers and analysts, and ensuring that data is cleaned and standardized to meet business requirements. Documentation is a critical aspect of this role, as you will be responsible for maintaining detailed records of database structures, configurations, and procedures. You will design new database structures, including tables and relationships, to ensure optimal performance and efficiency, while adhering to best practices such as normalization and denormalization. Additionally, you will monitor server and database performance, fine-tune queries, and ensure compliance with access provisioning through database roles. Regular database backup maintenance and monitoring of agent jobs will also be part of your responsibilities, along with troubleshooting issues that arise in SSIS/SQL packages. Your ability to communicate effectively and work cross-functionally with various organizations will be essential in meeting business requirements and adhering to Agile SCRUM methodologies.