Information Technology Analyst IV -

Seeking a Software Engineer (Information Technology Analyst IV) for the Performance Management and Judicial Branch Statistics Unit. Qualified applicants will possess experience in the specific functional area of Software Development. The successful candidate must be able to design, create, deploy, and maintain data warehouse and business intelligence solutions. Respond to ad-hoc data requests for information by writing complex T-SQL. The selected candidate will collaborate with technical and non-technical stakeholders to solve complex business problems, by gathering requirements, prototyping and testing, or enhancing existing solutions to meet new requirements. Qualified candidates must be proficient with: MS SQL Server 2012/2016/2022 T-SQL/PL-SQL programming and scripting Data warehousing Creating reports and dashboards MS Excel Analyzing requirements and prioritizing tasks Web and App development experience Proficiency with SQL Server includes the ability to: Create, modify and debug stored procedures Create and modify table structures and relationships Normalize database tables Understand execution plans and query statistics In addition to the required qualifications, the candidate must have excellent interpersonal and communication skills, both oral and written. It is necessary for the selected candidate to have the ability to manage the workload for projects, support daily on-going activities, resolve problems during and after working hours and to coordinate with other teams and work with all levels of technical and non-technical staff and management. This position requires a person with excellent technical skills along with the ability to foster a team environment. Upon hire, hybrid remote work may be available.