SQL Database AnalystThe SQL Database Analyst role helps design, develop and maintain useful, reliable and secure business process workflows.
The role works in tandem with other developers and the Operations group focusing on enhancing and creating new and better workflows. The position also works in direct relationship with the System Administrator as well as Project Managers, IT and Outside vendors to maintain, troubleshoot and support existing infrastructure in order to guarantee continuous access to Department information. Specific duties include development of new automated solutions, maintaining and creating documentation, working as part of a team to solve issues with both proprietary and licensed systems and interacting with outside support and other internal IT resources.ResponsibilitiesCreate and maintain automated processes using technical and programming toolsDesign, document, and implement new process workflowsInteract with SQL Databases to be able to feed other systems, generate reports as well as to provide application support to SQL-based systemsAutomated processes with PowershellProvide escalated application support as necessary for various department softwareMaintain proper documentation regarding new and existing Department processesPeriodically help with the installation and upgrade of department systems after hoursAvailability to respond to afterhours requests, alerts and emergencies as neededAbility to quickly learn backend and user facing systemsInteract with several members of the IT department and vendors in dealing with Litigation and Practice Support operational issues and troubleshootingRequirementsBachelor's degree in Computer Science, Information Technology or equivalent experience2+ years of experience with SQL database analysisExperience with SQL programming, or programming with .NET, Python or JavaExperience writing SQL queriesStrong experience with ExcelPreferred ExperienceExperience with PowerShellReporting experienceExperience with Microsoft AccessExperience with Workflow-design tools such as BP Logix or Visio