SQL Analyst X8 (138143) Open job in new window
Location: Brentwood, TN
Metro Area: Nashville, TN
Category: Information Technology

SQL Analyst - Mulitple OpeningsResponsibilities
Provides recommendations for solutions.
Creates the workplan for execution. Identifies the gaps in the workplan. Executes the workplan.
Creates Stored procedures to execute the workplan.
Creates the database structures to execute the workplan
Responds to ad hoc requests. Quickly understands and assesses the business problem. Creates ad hoc queries and solutions.
Able to understand the operational workflow and data sets. Understands the internal or external client needs.
Creates standard reports.
Analyzes the workflow between internal departments and external vendors. Identifies gaps and areas for improvement.
Creates solutions to pass and transform data from Chart Ops to others within the organization.
Analyze large amounts of data sets to determine optimal way to aggregate and report on it.
Create and maintain load processes.
Ability to create tools such as databases, tables, reports to facilitate operations? ability to meet goals and objectives.
Responsibilities
Responsible for development of stored procedures and T-SQL/PL-SQL scripts. Writing complex queries, using data modeling tools, designing and optimizing databases. Create and edit T-SQL code in a well-structured, optimized and documented format. Working internally with many teams on a wide variety of projects. Make recommendations, troubleshooting & database functions for new systems and utilities. Adhere to firm and departmental procedures, policies and processes.Qualifications
Expert level knowledge of T-SQL language required. Must have a strong understanding of how the SQL Server database engine and architecture work, including but not limited to: Physical storage, indexing, physical database design best practices, and the Query Optimizer. Experience and detail level understanding for various SQL Server features such as SSIS, SSAS, SSRS, XML, Full-Text, etc. Excellent communication skills, both verbal and written, with excellent analytical and problem solving skills. Strong knowledge of and experience with SQL Server 2008/2012/2014. Development of data-driven .NET applications using the Microsoft Sharepoint framework. Bachelor's Degree in Computer Technology or equivalent experience. 5+ years SQL Server Development Experience.Technologies (Database)
T-SQL - Expert knowledge SSMS - Expert knowledge Access - Intermediate knowledge Excel - Intermediate knowledge PowerPoint - Intermediate knowledge Data models - Expert knowledge PL-SQL - Intermediate knowledge SSIS - Intermediate knowledge SSRS - Intermediate knowledge SSAS - Nice to have C# - Nice to have PowerShell - Nice to have Visio - Nice to have JSON - Nice to have ASP.NET - Nice to have HTML5 - Nice to have CSS4 - Nice to have JavaScript - Nice to have Python - Nice to have R - Nice to haveTechnologies (Application/Tool Development) Differences from above in red
T-SQL - Expert knowledge SSMS - Expert knowledge Access - Intermediate knowledge Excel - Intermediate knowledge PowerPoint - Intermediate knowledge Data models - Expert knowledge PL-SQL - Intermediate knowledge SSIS - Intermediate knowledge SSRS - Intermediate knowledge SSAS - Nice to have C# - Intermediate knowledge PowerShell - Nice to have Visio - Nice to have JSON - Intermediate knowledge ASP.NET - Intermediate knowledge HTML5 - Intermediate knowledge CSS4 - Intermediate knowledge JavaScript - Intermediate knowledge