Berkley

  • SQL Developer

    Location Name KS, Overland Park
    ID
    2019-2314
    Date Posted
    1 week ago(3/11/2019 4:07 PM)
    Company
    Berkley Med Mgt Solutions
    Primary Location
    US-KS-Overland Park
    Loc2
    Kansas
    Category
    Information Technology
  • Company Details

     

    Berkley Med Mgmt Solutions_Logo

     

     

     

    Berkley Medical Management Solutions provides a different kind of managed-care service for W. R. Berkley Insurance Group. Too often, vended managed-care services focus on billable services instead of getting injured or ill employees back to work quickly with the best possible outcomes. We started by reimagining the relationship between medical need and technology as a way to deliver the best outcomes. The goal was clear: combine solid clinical practices, proven return-to-work strategies and robust software into one system for seamless management of workers’ compensation cases.

     

    The power of our technology takes medical bill-review services, clinical advisory solutions, and data analytics to a new level. We deploy integrated systems and, where appropriate, outsourced services to give W. R. Berkley Insurance Group recommendations and professional services for managing cases in an efficient and appropriate manner for each jurisdiction.  Our services help the clients of W. R. Berkley Insurance Group better manage their workers' compensation cases and return their employees to work faster with better outcomes.

     

    Associates of Berkley Medical Management Solutions demonstrate our commitment to harnessing the power of data to improve injury outcomes. Through an ongoing commitment to innovation, continuous improvement and education, we attract and retain associates with a unique blend of expertise and a passion for excellence.

     

     

    Responsibilities

     

    PRIMARY PURPOSE

    Participate in the entire database and software development life cycle. Writing SQL Server stored procedures, functions and creating other SQL Server objects as necessary.  Helping Developers debug existing applications database performance issues, maintaining and promoting database code in TFS/VSS across multiple environments. Creating SSRS Reports, SSIS Packages.  Experience in data visualization tools such as Power Bi is a plus but not a requirement. A strong desire to learn new methodologies and technologies. Self-motivated and willing to help others in areas which may not be your primary responsibility.  Work within a small data focused team to complement software development results and corporate initiatives

     

    ESSENTIAL FUNCTIONS

    • Participate in requirements analysis
    • Collaborate with internal/external teams to produce data solutions
    • Write clean, standards based scalable code using stored procedures, views, functions and other database objects
    • Revise, update, refactor and debug database code and indexes
    • Improve existing database code where necessary
    • Develop documentation throughout the database software development life cycle (SDLC)
    • Serve as back-up for other team members and provide technical support as necessary
    •  

    PROFESSIONALISM

    • Must exhibit professional behavior at all times while representing or being identified as an employee of BMMS
    • Demonstrate the use of tact and discretion in all communications and provide a positive contribution to the morale of the department
    • Establish and maintain effective working relationships with unit staff, clients, providers, and other departments of BMMS

    Qualifications

    • Three (3) years of proven experience as a SQL Developer with SQL 2014 thru SQL 2017. Must be able to demonstrate understanding
    • Proficiency in SSRS (Reporting Services). Prefer experience in SSRS 2014 the SSRS 2017. Must be able to demonstrate understanding
    • Proficiency in SSIS (Integration Services). Prefer experience in SSRS 2014 the SSRS 2017
    • Visual Studio 2015, SSDT for Visual Studio Database Code/Data Compare. Must be able to demonstrate understanding
    • Strong knowledge of T-SQL. Must be able to demonstrate understanding
    • Prior experience using data visual tools such as Power Bi desired
    • Familiarity with agile environments
    • Troubleshooting and database performance resolution abilities
    • Good communication skills
    • BSc in Computer Science, Engineering or relevant field

     

    PHYSICAL REQUIREMENTS

    • Ability to operate computers including high-level working knowledge of major Microsoft Office applications
    • Automobile and air travel as indicated by the business needs of the department and the company
    • Ability to sit, stand, walk intermittently throughout the workday and to continuously communicate both in-person, by telephone and by electronic means

    Options

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

    Connect With Us!

    Not ready to apply? Connect with us for general consideration.