SQL Developer

Due to the nature of our clients' work, candidates applying to this role must be;

• US Citizen
  
• Located in Salt Lake City, Utah
  

This position will be eligible for some telecommute requiring some office work as well. Residence and work required in Utah.

Contribute to a long-term data migration project by developing and maintaining SQL conversion scripts contained in stored procedures as well as researching legacy source data points, data cleansing, and other analytical activities that support this large data migration project. A long-term part of this effort will be to eventually learn the new target application and become an expert on the database design to prepare for regular day-to-day database development on the new application.

ESSENTIAL JOB FUNCTIONS AND DUTIES

1. Manages the development and conversion of SQL environments and databases that support the data conversion and other work done by the data conversion team.
   

2. Manages the migration process for monthly data conversions. This will involve creating, maintaining, and automating any changes in the conversion scripts and process and its accompanying data quality reports.
   

3. Works with the data team to create and maintain conversion scripts.
   

4. Assists the data team with optimizing SQL code.
   

5. Assists with the monthly database conversion process, which will include discussions around data quality and conversion schedules.
   

6. Documents key work functions.
   

7. Continues to learn new SQL coding essential to conversion duties and responsibilities.
   

8. Acts as a liaison between information technology and the project management team.
   

9. Works closely with our business users to troubleshoot, understand, anticipate, and address evolving needs on data migration issues.
   

10. Maintains strict confidentiality.
    

11. Performs other related duties as required.
    

Requirements

Required Experience

Education and Experience

Bachelor’s degree in computer science, information systems, or other related discipline; and three (3) years of experience with enterprise level software development practices in a structured software development life cycle. Specific experience with MS SQL Server 2010 or higher; including T-SQL, stored procedures, query optimization, extract transfer load (ETL), and data cleansing; or an equivalent combination of education and experience.

Knowledge of retirement systems and retirement plans are preferred.

Microsoft SQL Server certification is preferred.

Knowledge, Skills, and Abilities

This list contains knowledge, skills, and abilities that are typically associated with the job. It is not all-inclusive and may vary from position to position:

Required technical skills include the expert knowledge and ability of:

• SQL Server Management Studio (SSMS).
  

• Visual Studio database projects.
  

• Team Foundation Server.
  

• Importing and exporting large datasets to and from various sources.
  

• Data Warehouse creation and maintenance.
  

• Diagnosing and resolving system, software, and data problems, quickly and accurately.
  

 Required mathematical skills include working knowledge and ability of:

• Work with mathematical concepts such as probability and statistical inference.
  

• Apply mathematical operations to such tasks as frequency distributions, determination of test reliability and validity.
  

• Mathematical transformations and calculations during data conversion and data cleansing.
  

 Must possess excellent communication skills:

• Read, analyze, and interpret general business periodicals, professional journals, technical procedures, or regulations.
  

• Write reports, business correspondence, and procedure manuals.
  

• Present at weekly department database meetings.
  

 Must have the ability to:

• Follow written and verbal instructions.
  

• Prioritize work.
  

• Perform within deadlines.
  

• Work well in a team environment, but primarily independent.
  

• Multi-task by handling a variety of duties in a timely and efficient manner.
  

• Follow through with assignments.
  

• Deal effectively with stress caused by workload and time deadlines.
  

The incumbent must always demonstrate judgment, high integrity, and personal values consistent with the values of our client.

Work Environment

Incumbent performs in a typical office setting with appropriate climate controls. Tasks require a variety of physical activities which do not generally involve muscular strain, but do require activities related to walking, standing, stooping, sitting, reaching, talking, hearing and seeing. Common eye, hand, finger dexterity required to perform essential functions. 

Position requires occasional travel for office business. Individuals must be physically capable of safely operating a vehicle, possess a valid driver’s license and have an acceptable driving record based upon data provided by a current Department of Motor Vehicle Record (MVR).

Benefits

• Retirement Contribution Match 
  
• 401K / 401K Match
• Medical Insurance
  
• Holiday Pay
  
• Sick Leave
  
• Annual Leave