Lavoro Microsoft-sql-server a distanza a los-angeles ∙ Pagina 1

About the Department

The Superior Court of Los Angeles County is the largest unified trial court in the United States. The Court’s 582 judicial officers and its dedicated workforce of over 4,600 full-time employees serving across 36 facilities work purposefully and seamlessly to achieve the mission to provide equal access to justice to all of Los Angeles County. With an annual budget exceeding $1 billion, the Los Angeles Superior Court operation scales one of the nation’s largest counties, covering over 4,084 square miles and serving over 10 million residents. 

The Court’s justice-oriented mission, dynamic workforce and the ever-evolving needs of the community at large offer bold and rewarding opportunities for talented, public-sector professionals and leaders who seek to foster and realize positive impact. Find out more about your future with the Superior Court of Los Angeles County – connect with us today.

ABOUT THE POSITION

Are you ready to take your career to the next level? Join us as a Data Analytics 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.  

The official classification for this role is Business Systems Manager. For a detailed job description, click here. Please note the requirements in the job description may vary from the requirements in this bulletin. Applicants must meet the requirements stated in this bulletin. 
 
Key responsibilities: 

• Advanced Analytics: Develop comprehensive data analysis projects using advanced analytics technologies and solutions to support data-driven decision-making.
• Data Architecture: Design and maintain data storage solutions by applying in-depth knowledge of data architecture and data warehousing concepts to ensure system reliability and scalability.
• Dimensional Modeling: Implement dimensional data models for analytics and reporting by applying principles of dimensional modeling to support accurate and efficient data querying.
• Interactive Reporting: Create and maintain interactive dashboards, reports, and visualizations using Power BI to effectively communicate data insights to stakeholders.
• SQL Optimization: Write and optimize SQL queries for Microsoft SQL Server, SQL Server Reporting Services, and Oracle databases to enhance data retrieval efficiency.
• Project Management: Manage and organize data-related projects using established project management methodologies to meet timelines and objectives.
• Programming and Platforms: Implement fully operational data solutions on Snowflake and Azure using WhereScape RED automations and other platform technologies to support enterprise analytics functions.

• Team Leadership and Development: Lead analytics teams in the execution of data initiatives by coordinating priorities, mentoring staff, and fostering cross-functional collaboration to ensure high-quality deliverables and continuous skill development.

This is an at-will managerial position. The Trial Court Employment Protection and Governance Act (SB 2140) authorizes the Court to exclude managerial employees from the employment protection provisions of the Act subject to meet and confer.
 
THIS IS A TELEWORK ELIGIBLE OPPORTUNITY

This position may be eligible for full or partial telework following an initial training period and contingent upon the needs of the Court. 

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:  Associate’s degree* in information technology, computer science, management information systems, or related field; -AND- 7+ 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 IV:  Master’s degree* in information technology, computer science, management information systems, or related field; -AND- 3+ years' experience in business analysis, requirements definition and information technology support as it relates to data and analytics.

*To qualify for Options that require educational credentials, you must attach the required documentation to your application. For more information, please visit the Applicant Support page.

Note: Credit for experience is given based on a 40-hour workweek. Part-time experience is credited on a part-time ratio (e.g., working 20 hours per week for two months equals one month of experience). Overtime does not count toward additional credit.

DESIRABLE QUALIFICATIONS

• Skilled with advanced analytics technologies and solutions
• Knowledge of data architectures and data warehousing concepts
• Strong 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 BI 
• Strong knowledge of SQL against Microsoft SQL Server, SQL Server Reporting Server, PBI Report Server, and Oracle databases
• Excellent organizational and project management skills.
• Exposure to Python, R or similar language and Azure platform.
• Exposure to AI and ML technologies.

APPLICANT SUPPORT & INFORMATION

Applications must be submitted online. Before submitting your application, carefully review ALL the information detailed on our APPLICANT SUPPORT page linked HERE.

Applicants with disabilities who require reasonable accommodation to participate in the recruitment process may submit a request for accommodation to the email provided below. For additional employment information, please click HERE.

WHAT TO EXPECT AFTER APPLYING

This recruitment process may take up to 4-6 weeks to complete. We will notify you of the outcome after each step of the recruitment process, detailed below:

EVALUATION: Qualifying evaluation of education, training and experience based upon submitted application and supplemental questionnaire. 

ELIGIBILITY: Applicants who best meet job-related qualifications will be placed on an eligible list which will remain active for approximately six (6) months and may be invited to participate in a selection interview. Other vacancies may be filled using this list.

Questions regarding this posting may be e-mailed to [email protected].

Follow us on social media!

X | Instagram | Threads | YouTube | Facebook | LinkedIn