Search Jobs

SQL Developer

Description

Job Description

 

Job Information

JOB TITLE:

SQL Developer

 

 

Position Summary

Collaborate with business, reporting and other teams to understand business requirements and perform data analysis. Work with back-end data architects/systems engineers to construct data objects necessary for supporting these business requirements. Participate in data warehouse design, creation and monitoring to ensure that data is clean, accurate, available and complete. Analyze and create complex SQL and SSIS as needed to support new and evolving data integration projects and data extracts. Serve as subject matter expert within the team. Work under general supervision and report to Manager, Director or VP of department.

Essential

Functions

  1. Adhere to general work requirements.
  2. Serve as subject matter expert within the team and apply specialized knowledge to support the organization’s vision and direction
  3. Design and support database and table structures for new and evolving sources of data being brought into the organization
  4. Coordinate development of ETL/data warehouse best practices needed to support new and evolving sources of data used in reporting, transaction processing and analytics
  5. Perform extensive and detailed data analysis necessary to ensure strict adherence to data quality guidelines
  6. Take on end-to-end ownership and perform different roles as per the phase/requirement of tickets/projects assigned:
    • Analysis phase - Requirements gathering, data analysis, documentation, source-to-target mapping, data/process flow diagrams
    • Development phase - Coding/development, unit testing. peer code reviews, code performance aspects, impact analysis
  7. Set/manage expectations with clients, provide proactive communication and status updates, prioritize deliverables with client/request or, and follow and implement Change Control and release management processes
  8. Perform other duties as assigned

General Skills

  • Good verbal and written communication skills
  • Proficient working knowledge of computerized applications such as word processing, spreadsheet, database,presentation software,email and specialized business applications software
  • Presentation skills necessary to effectively communicate, update, persuade and/or facilitate discussions with all levels of management
  • Interpersonal skills necessary to establish and maintain effective working relationships with coworkers, other business areas and government agencies as required
    • read and interpret complex reports and documents
    • assimilate and interpret various sources of data and provide and make decisions on recommendations to executive management to solve highly complex problems from start to finish

Planning and organizational skills necessary to coordinate workload around multiple assignments

Minimum Qualifications

  • Bachelor’s degree in a related field
  • 5+ years of experience with SQL Server 2005/2008/2012 T-SQL coding
  • 2+ years of experience with SSIS
  • 5+ years of experience as a data analyst and/or SQL/SSIS developer
  • 3-4 years of experience working in the mortgage industry
  • Good understanding of database modeling concepts, preferably in the context of mortgage industry (originations and/or servicing). Example – MISMO specifications
  • Experience using data warehouse with underlying SQL databases and/or analytical tools for business purposes
  • Knowledge of key data warehousing and database processes

  • Ability to reverse engineer existing SQL code to determine business logic, and create source-to-target mapping documents.

Additional Desired Qualifications

  • Understanding of and experience in database administration

 

 

 

 

 

Related Jobs

April 21, 2017
SQL Database Developer   Richardson, TX
March 30, 2017
Java Developer   Richardson, Texas
March 8, 2017
Application Developer   California
March 6, 2017
Senior Application Developer   Farmers Branch, Texas
February 22, 2017