SQL Developer

$70,000 - $90,000/Yr

Confidential Company - Tampa, FL

Full-time - Mid Level

Tampa, FL

About the position

The SQL Developer at OneTouch Direct is responsible for developing reporting structures, enhancing business processes, and ensuring data consistency and availability. This role involves supporting the development of data warehousing and business intelligence applications on the Microsoft SQL Server platform, while also providing technical guidance to various stakeholders within the company and external clients.

Responsibilities

• Manage, investigate, and resolve data quality issues in enterprise applications while safeguarding against data loss
• Responsible for data mapping, including facilitating business decisions that may be required to map data
• Guide decision makers in determining where to place specific data while considering business purposes, and how the location of certain data will incur particular risks
• Take a lead in preventing data quality issues by identifying frequent user errors, and working with business units to strengthen user competence
• Provide recommendations for appropriate methodologies for migration, cleansing, execution management, etc
• Support in systems design and architecture in business systems applications, Business Intelligence, Reporting, web programming, data extracts, and systems interfaces
• Support change management and production support to specific designated business systems applications and the corresponding data bases
• Support the design and development of integration projects required to incorporate new data sources in to the data warehouse while providing data stewardship and ensuring the integrity of the data model is maintained
• Diligently make changes to the Extract, Transform and Load (ETL) programs as well as maintain the dimensional data models in the enterprise data warehouse system
• Actively be involved with the maintenance and configuration of Data Warehouse infrastructure

Requirements

• 3+ years of strong MS SQLServer Developer experience with expertise in MS SQL Server 2016/2014/2012/2008 suite of products like SSRS, SSAS, and SSIS
• Proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions, Relational Database models and Data integrity, and SQL
• Experience in creating Indexes, Indexed Views in observing Business Rules and creating Effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS with MS SQL 2016/2014/2012/2008
• Experienced in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger
• Experienced in Logical and Physical Database design & development, Data Conversion, Normalization and Data modeling using Erwin, Microsoft Visio and SQL Server Enterprise manager
• Strong leadership, communication, problem-solving and multi-tasking abilities

Benefits

• Flexible schedule
• Health insurance
• Life insurance
• Paid time off
• Vision insurance