SQL Developer

The SQL Developer will be responsible for ETL integration and application development in a Microsoft SQL Server platform. This will include reports, vendor exports, data warehousing tasks and other data related tasks. This position requires excellent communication, technical and project management skills.

Essential Functions

  • Create, modify and test various complex T-SQL procedures, SQL queries and SSIS Packages to source and manipulate the data necessary to meet business requirements.
  • Create new and modify existing SSRS reports for operational reporting.
  • Reconcile data inconsistencies and ensure data integrity. Perform data mining, data cleansing, data manipulation, and data indexing.
  • Develop SQL code to support database and Change Data Capture
  • Follow database development standards for Microsoft enterprise and application databases.
  • Support table indexing and query strategies, database objects maintenance and performance issues.
  • Document the logical and physical components of operational databases and their functionality during the course of their work.
  • Assist in the roll-out of new SQL based applications, problem fixes, and enhancements of software.
  • Create new and modify existing SSRS reports for operational reporting.

Education

  • Bachelor’s or Master’s Degree in Computer Science or other related field or equivalent work experience

Experience

Minimum of 5+ years ETL experience using MS SQL Server Development Suite (SSRS/SSIS/SSAS)

  • Proficiency in developing dynamic SQL
  • Proficiency in indexing and optimization
  • Experience with data architecture and modeling concepts
  • Develop high quality, well-documented TSQL code (Stored Procedures, Views, Functions)
  • Proficiency in Data Lifecycle Management
  • BI Tool experience a plus (Tableau, Qlikview, Cognos, Business Objects, etc.)
  • Understand table indexing and query strategies, database objects maintenance and performance issues
  • Strong understanding of agile development methodologies
  • Healthcare industry background a plus

Essential Technical/Motor Skills

  • Excellent written and verbal communication skills.
  • Interact with internal/external clients to provide a high level of customer satisfaction with the application(s) being implemented and utilized
  • Ability to work independently.
  • Strong analytical and problem-solving skills.
  • Ability to work on various simultaneous initiatives and produce high-quality work products on time

Interpersonal Skills

  • Must be able to lead teams.
  • Must be able to make effective and timely decisions.
  • Must be able to effectively influence peers and other stakeholders without direct reporting relationships
  • Must possess leadership qualities such as:
  • ability to teach and mentor
  • ability to hold others accountable
  • ability to listen
  • ability to accept input from others
  • ability to accept coaching from others
  • ability to give clear direction and provide feedback to others

Physical Requirements in Accordance with ADA

  • Carrying/Lifting:              Occasional/0-10 lbs
  • Standing:                         Occasional/Up to 3 hours per day
  • Sitting:                             Constant/Up to 8 hours per day
  • Walking:                           Occasional/Up to 1 hour per day
  • Repetitive Motion:           Keyboard activity, telephone use, writing
  • Visual Acuity:                   Ability to view computer monitor and read newsprint with or                                         without corrective lenses
  • Environmental Exposure:  None
Apply Now