Business Systems Manager

Position DescriptionABOUT THE COURT Los Angeles Superior Court is the largest unified trial court in the United States. Its 580 judges and commissioners work in one of the 36 facilities within the Court's 12 judicial districts and are supported by more than 4,800 full-time Court employees. The Court has an annual budget of more than $1 billion. Located in Southern California, Los Angeles County is geographically one of the nation's largest counties, covering 4,752 square miles and, with over 10,400,000 residents, is also one of its most populous counties.ABOUT THE POSITION Are you ready to take your career to the next level? Join us as a Business Systems Manager and become a key player in designing and engineering state-of-the-art data analytics solutions. We're looking for a dynamic leader with proven expertise in advanced analytics technologies and solutions, as well as the ability to implement comprehensive systems using WhereScape RED or similar tools on Snowflake Data Warehouse. You'll excel in designing data models, creating interactive Power BI reports and dashboards, and utilizing your strong SQL skills across Microsoft SQL Server, SQL Server Reporting Server, and Oracle databases. With excellent organizational and project management capabilities, you’ll also have the chance to expand your expertise in advanced data and analytical platforms. Bring your passion for innovation and your proficiency in data architectures to our team and help us drive our mission forward.Key responsibilities : Advanced Analytics : Utilize advanced analytics technologies and solutions to develop comprehensive data analysis projects.Data Architecture : Apply in-depth knowledge of data architectures and data warehousing concepts to design and maintain robust data storage solutions.Dimensional Modeling : Design and implement data models for analytics and reporting, ensuring a strong understanding of dimensional modeling concepts.Interactive Reporting : Build and maintain interactive reports, dashboards, and visualizations using Power BI to present data insights effectively.SQL Optimization : Write and optimize SQL queries for Microsoft SQL Server, SQL Server Reporting Server, and Oracle databases to ensure efficient data retrieval.Project Management : Organize and manage projects efficiently, demonstrating excellent organizational and project management skills.Programming and Platforms : Leverage knowledge of WhereScape RED automations, implement fully operational solutions on Snowflake, and utilize Azure and other technologies for data processing and analytics tasks.TELEWORK OPPORTUNITIES This position is eligible for telework following an initial training period.SELECTION REQUIREMENTS To qualify, you must meet one of the following options at the time of application : OPTION I : 9 years' experience in business analysis, requirements definition and information technology support as it relates to data and analytics.OPTION II : Bachelor’s degree in information technology, computer science, management information systems, or related field; -AND- 5 years' experience in business analysis, requirements definition and information technology support as it relates to data and analytics.OPTION III : Any combination of knowledge and experience that provides the required skills to perform the job.Note : Credit for experience is given based on a 40-hour workweek. Part-time experience is credited on a part-time ratio, i.e., working 20 hours per week for two months equals one month of experience. No additional credit is given for overtime.DESIRABLE QUALIFICATIONS Skilled with advanced analytics technologies and solutionsKnowledge of data architectures and data warehousing conceptsStrong understanding of dimensional modeling concepts and experience in designing and implementing data models for analytics and reporting purposes.Proficiency in building interactive reports, dashboards, and visualizations using Power BIStrong knowledge of SQL against Microsoft SQL Server, SQL Server Reporting Server, and Oracle databasesExcellent organizational and project management skills.Exposure to Python, R or similar language and Azure platform.EXAMINATION INFORMATION Qualifying evaluation of experience based upon submitted application materials and supplemental questionnaire.WHAT TO EXPECT NEXT Applicants who meet the selection requirements will be placed on an eligible list which will remain valid for up to six months and may be invited to participate in an oral interview.IMPORTANT INFORMATION FOR APPLICANTS For general application information, please access the Online Employment Application Guide. Los Angeles Superior Court reserves the right to verify all submitted documentation prior to appointment.Applicants with disabilities who require reasonable accommodations to participate in the recruitment process can contact the email address provided below.Los Angeles Superior Court is an equal opportunity employer.Questions regarding this posting may be e-mailed to MPenate@lacourt.org .Follow us on social media! X | Instagram | Threads | YouTube | Facebook | LinkedIn#J-18808-Ljbffr