Business Intelligence Developer/Database Administrator - JC

Cube Hub - Rancho Cordova, CA

Full-time - Mid Level

Rancho Cordova, CA

Professional, Scientific, and Technical Services

About the position

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.

Responsibilities

• Partner closely with upstream application teams and developers to ensure data sources are accurate, available, and timely.
• Efficiently and accurately develop complex SQL queries (stored procedures, views, and functions).
• Collaborate with front-end business intelligence developers and analysts to test, clean, and standardize data to meet business requirements.
• Document database structures, configurations, and procedures to maintain a well-managed database environment.
• Design the structure of new databases, including tables, relationships, and data integrity constraints for optimal performance.
• Proactively monitor server, database, and query performance.
• Fine-tune query, database, and server performance as needed.
• Ensure all access is provisioned through database roles and address compliance issues.
• Perform regular database backup maintenance and retention according to policy.
• Monitor agent jobs and troubleshoot issues as they arise.
• Monitor SSIS package runs and troubleshoot issues in SSIS/SQL.
• Manage access through periodic audits and ensure correct user access on the server.
• Work cross-functionally with various organizations to meet business requirements.
• Maintain excellent verbal communication and documentation skills to support workflows and query functionality.
• Adhere to Agile SCRUM methodology and processes.

Requirements

• Proficient in SQL and SSIS for interacting with SQL server data models, including data connectors and dimensional modeling.
• Experience working with large and complex data sets and writing complex queries to create stored procedures, views, and functions.
• Understanding of data systems (BI analytics, data blending, data warehousing, data ELT) for process automation and standardization.
• Experience in a support team environment, documenting, researching, and solving problems through a service help desk ticketing system.
• Ability to gather and validate functional requirements and provide design specifications in collaboration with business analysts or sponsors.
• SQL server administration skills, including management, monitoring, and performance tuning.
• Experience managing OLAP and OLTP databases.
• Ability to create, manage, and troubleshoot agent jobs.
• Experience with SSIS, including creating, maintaining, and troubleshooting packages.
• Strong SQL skills for querying system and user databases, analyzing query plans, and optimizing performance through schema and query optimization.

Nice-to-haves

• Ability to work on multiple projects and flexibility to change priorities when needed.