Matrix Medical Network

  • Sr. SQL ETL Developer

    Posted Date 3 weeks ago(9/3/2019 1:15 PM)
    Job ID
    2019-8101
    # of Openings
    1
    Category
    IT
    Type
    Full Time Regular
  • Overview

    Matrix Medical Network Informatics team delivers reporting and analytic capabilities using cutting edge Database Solutions using SQL and noSQL, ETL tools, and Business Intelligence solutions. Looking for enthusiastic, action oriented team members who will thrive in our fast paced and dynamic environment.

     

    Social Media_IT 4 for iCIMS

    Applicants, please note:

     

    We are seeking local candidates who are available to start quickly

    At this time, we are unable to sponsor or transfer any visas.

     

     

    Summary:  

     

    The Senior Developer is a technical leader providing oversight and delivery of technical projects. This role implements architecture-centric solutions in addition to providing guidance to the developers in delivering solutions that adhere to and meets the strategic objectives set by the Enterprise Data Architect and Informatics Leadership.

     

    Responsibilities


     Responsibilities:

    • Participates in all phases of SDLC: from system analysis and design thru development and test to deployment and support.
    • Provides development estimates and participates in project planning.
    • Participates in designing and developing complex reports, analysis, and ETL by writing Design Specifications description of framework, interfaces, services, reports, business components, and interaction between the components.
    • Responsible for ensuring quality delivery of code through static and dynamic testing techniques
    • Is able to troubleshoot any complex data related issues as well as provide support to production.
    • Keep abreast of the current technologies and technological trends. Ability to learn and prototype new technologies, and recommend their use in the company products.
    • Peer mentoring experience of more junior team members.
    • Ensures adherence to standards for self as well as team.
    • Other duties as assigned

     

    Qualifications

     

    Requirements: 

    • Bachelor's degree in Computer Science or related field
    • Minimum 7 years of experience as a Developer
    • Minimum 2 years of experience as a Lead or Senior Developer
    • Knowledge of advanced SQL programming concepts like CTE (Common Table Expressions)
    • Minimum 5 years of experience with Transact-SQL, Microsoft Power BI, Microsoft SQL Reporting Services, and Microsoft SQL Server(2014 or later preferred)
    • Minimum 5 years of experience with Microsoft SQL Server Integration Services (SSIS) or equivalent ETL platform
    • Minimum 2 years of experience with Tableau
    • Knowledge of advanced SSIS concepts to handle complex tasks like importing large files, loading data in a transactional database etc.
    • Experience in NoSQL databases is a big plus.
    • Proven ability to analyze, document, and reverse engineer any type of SQL\SSIS based code and ETL processes.
    • Make recommendation on how to rewrite, modify, redesign SQL and ETL based processes based on analysis.
    • Excellent written and verbal communication skills
    • Demonstrated experience of estimation and planning
    • Demonstrated abilities to successfully document and communicate software designs of complex systems.
    • Has proven record of successfully motivating and leading a software development team.
    • Proven history of developing and unit testing complex software components.
    • Ability to be flexible, set priorities and meet deadlines in a changing environment for self as well as team.
    • Must have decision-making skills for problem identification and solution recommendation.
    • Ability to work independently and as part of a team while demonstrating initiative and using good business judgment
    • Demonstrated ability to drive process improvement and improve the process efficiency
    • Demonstrated ability to reduce and/or prevent production defects based on the continuous root cause analysis and process improvement
    • Ability to maintain effective working relationships across teams and with a diverse workforce
    • Able to represent the Company in a positive and professional manner.
    • Supervisory Responsibilities: none
    •  Travel requirements: Ability to travel up to 15%. 

     

    Options

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

    Get job recommendations

    Tell us a little about yourself, and we’ll recommend jobs that match your interests and experience. Click here to get started.