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.

Click here to apply.

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