Planet Home Lending

  • SQL Developer/Analyst

    Job Locations US-CT-Meriden
    Posted Date 1 month ago(3/16/2018 2:41 PM)
    # of Openings
    1
    Category
    Information Technology
  • Overview

    The SQL Developer Analyst is responsible for developing, testing, implementing, and administering MS SQL databases and administering business intelligence solutions and reports through the use of the Microsoft SQL Server BI (SSRS/SSMS/SSIS), Excel, and/or other tools. They will also collaborate with technical and non-technical stakeholders to solve complex business problems by gathering requirements, prototyping and testing, or enhancing existing solutions to meet new requirements.

     

    Primary Responsibilities

    • Design, code, test, debug, and document complex TSQL data base queries.
    • Troubleshoot and resolve complex production issues.
    • Work with internal users to understand their requirements, explain issues, and prioritize work.
    • Designs, develops, and maintains strategic business level reports to various business areas.
    • Develops SSIS packages to automate existing reporting and business processes.
    • Creates ad-hoc reports using moderate to complex T-SQL scripts.
    • Interfaces with third party vendors as needed to integrate existing data into the data warehouse.
    • Performs related duties and special requests as assigned.

    Position Requirements

    • Knowledge of best practices when dealing with relational databases.
    • Strong analytical, problem-solving and project management skills.
    • Collaborate with team members to identify and prioritize/reprioritize work to meet aggressive deadlines.
    • Proficient at writing ad-hoc SQL Queries and Stored procedures.
    • Experience with the Microsoft Visual Studio.
    • Working knowledge of Microsoft SQL Server, SSRS, SSMS, SSIS and T-SQL.
    • Strong proficiency with Microsoft Excel (logical analysis using built in functions, VLOOKUP, nested functions, If-Then-Else, etc.)
    • Prior experience working within a mortgage servicer or originator preferred.
    • Development experience in C# preferred.
    • Knowledge of MySQL is a plus.
    • Minimum 3 years’ experience with data warehouse development.

     

    Education and/or Experience:

    • Bachelor’s degree in Computer Science, Information Technology, Business, Finance, or other related field.
    • A minimum of three years of experience working with Microsoft SQL Server and T-SQL.
    • A minimum of two years of experience working with SSIS, and a minimum of one year experience in data integration and validation.
    • The equivalent combination of education and experience may be acceptable.

    Planet Home Lending, LLC is a full-service, multi-state lender.

    With its state of the art technology and seasoned management team, Planet Home Lending is capable of providing our customers with a wide variety of loan products, including a diverse selection of adjustable-rate mortgages.

    NMLS #17022

    Planet Privacy and Social Media disclaimers:

    Please use this link to view our Privacy Policy
    https://planethomelending.com/privacy-policy


    Please use this link for our Social Media Disclaimer
    https://planethomelending.com/social-media-disclaimer

    Options

    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed