Data Load Engineer/SQL Developer

Company: EviCore Healthcare
Location: Franklin
Posted on: March 28, 2020

Job Description:

SummaryThe Data Load Engineer/SQL Developer is responsible for managing member and provider data loads. This will entail managing the full scope of the data load process, including, client files, the ingestion engine, ETL/transform, database management, data export and SLA tracking. This will require knowledge of SQL Database technology, ETL/SSIS, TSQL coding, EDI and Medical File data. The Data Load Engineer/SQL Developer will be required to troubleshoot and resolve data load issues, including bad data, file mapping, performance issues for SSIS packages and ETL Processes and reviewing stored procedures and functions for issues. The Data Load Engineer/SQL Developer must also have experience with automation, process improvement, documentation development, SDLC, source control and versioning as database development work will be required from time to time. The Data Load Engineer/SQL Developer will be responsible for participating in the 24x7 shift schedule. Other duties will be determined as necessary.Minimum Experience Required6+ Years of experience with BI/Data Warehouse and TSQL development(scripting, stored procedures, triggers, query development)Required SkillsTechnical

• 
  
  
• 6+ years of experience with BI/Data Warehouse and TSQL development(scripting, stored procedures, triggers, query development)
  
• Strong understanding of Database technology (SQL Server)
  
  
  
  • 
    
    
  • Experience with ETL, SSIS, SSRS, SSAS, OLAP, EDI, BCP
    
  • SQL Job and Process Automation
    
  • SQL Server 2008 - 2017
    
  • Knowledge and Experience with Best Practices and Standards for TSQL and SDLC
    
  • Development Tools/Applications (GitHub, TFS, AzureDevOps, RedGate Tools, Visual Studio, etc)
    
  • FTP File Management (Zip/Unzip, Encrypt/Decrypt) - MoveIT, Data Tran, SI
    
  • Data Load Processing and Workflow Management
    
    Non-Technical
    
    
    • 
      
      
    • Reporting (On Demand, Error, Trending, Summary, etc)
      
    • Data Analysis Skills
      
    • Agile Methodologies/SCRUM
      
    • Documentation Development
      
    • Excellent Interpersonal and Communications Skills
      
    • Capable of working independently and in a team
      
    • 24x7 Support shift schedule
      
      Additional Skills
      
      
      • 
        
        
      • Microsoft Azure skills a plus
        
      • Healthcare/Medical/insurance data experience a plus
        
      • AS400 Knowledge a plus
        
        
        Our Company and What We OffereviCore healthcare is committed to making a positive impact on healthcare, and also making a positive impact on our employees. eviCore offers a variety of perks and benefits including, but not limited to:
        
        
        • 
          
          
        • Full medical, dental, vision, and vision benefits with employer funded HSA starting day 1
          
          
        • Strong work/life balance with 15 days of PTO (starting) per year plus 8 paid holidays
          
          
        • Competitive compensation package including base salary, and short and long term incentives depending on role.
          
          
        • Education assistance and tuition reimbursement along with ample opportunities for growth
          
        • Time away from work programs including employer paid short-term and long-term disability, caregiver leave, BTO (bought-time off) options, company paid volunteer community service hours, and more
          
        • Onsite fitness facilities, casual dress code- wear your jeans to work, and two comprehensive employee discount programs
          
          
        • Health coaching, Employee Assistance Program, resiliency and stress management solutions, Adoption Assistance Program and additional resources to support your well-being
          
          
        • Life & Accidental Death Dismemberment and additional Accidental Injury, Critical Illness, and Hospital Care Insurance
          
        • 401k retirement plan with company match of 50% employee contributions up to 6%
          
          And so much more. Check out evicore.com/careers to see all of the perks and benefits we offer.

Keywords: EviCore Healthcare, Franklin , Data Load Engineer/SQL Developer, IT / Software / Systems , Franklin, Tennessee