T-SQL Developer - Irving, United States - Saxon Global

    Default job background
    Description


    This is a fully remote position, but candidates must reside in one of the following states: NH, MA, CT, RI, VT, NJ, FL or TX.

    Please do not apply if you are located elsewhere.

    Job Description

    This position will require qualified T-SQL Developers to take the lead in the following tasks:


    • Rationalizing and mapping data between transactional and dimensional database models/systems
    • Working closely with the database and system administrators to develop stored procedures and ETL processes related to the data warehouse system
    • Working in collaboration with vendors and other agency staff to design, develop and manage the creation of federally required reports using the Generate application
    • Translate application storyboards and use cases into functional applications
    • Ability to work independently and cooperatively as part of a team.
    • Ability to work under severe time constraints.
    • Must possess analytical and complex problem-solving skills.

    Required:
    Bachelor's Degree

    REQUIRED SKILLS/EXPERIENCE


    • Extensive experience with development of stored procedures and ETL processes using T-SQL
    • Thorough understanding of data warehouse design hierarchies such as star and snowflake schemas
    • Use of ALM tools for work item management, version control, code analysis, and testing
    • Broad and extensive knowledge of the software development process and its technologies
    • Familiarity with continuous integration
    • Experience creating and scheduling elastic jobs