Data Warehouse Operations Engineer/Sql Server Devops Job Description

Evicore Franklin , TN 37064

Posted 2 months ago

Summary

Data Warehouse Operations Engineer/SQL Server DevOps Job Description

This operations support position is responsible for managing SQL Server jobs and daily production loads to the data warehouse. This will entail the full scope of the ETL (Extract Transform Load) process, including client files, the ingestion engine, SSIS packages, process management, and SLA tracking. This will require knowledge of SQL Server operations, ETL/SSIS, TSQL coding, and medical file data. This position will be required to troubleshoot and resolve ETL process issues, including bad data, file mapping, performance issues for SSIS packages and ETL processes, and reviewing stored procedures and functions for issues. This position must also have experience with automation, process improvement, documentation, development, SDLC, source control, and versioning as data warehouse development work will be required from time to time. This position will be responsible for participating in the 24x7 shift schedule. Other duties will be determined as necessary

Minimum Experience Required

  • Minimum 2 years of experience with SQL Server in a data warehouse environment and Microsoft BI stack

  • Experienced with complex T-SQL queries and performance optimization

Required Skills

Technical

  • Independently handle ETL failures, create root cause analysis, and adhere to data availability SLA

  • Proactively work on reducing frequently occurring issues

  • Automate manual work and minimize manual intervention

  • Proactively monitor ETL finish time - handle surge in data volume, poor source data quality, server outages to maintain SLA

  • Maintain process metrics and identify new metrics based on the business requirements

  • Excellent written and verbal communication

  • SQL Server job and process automation, management, and improvements

  • SQL Server version 2012 - 2017

  • Knowledge and experience with best practices and standards for TSQL and SDLC

  • Development tools/applications (GitHub, TFS, Azure DevOps, RedGate tools, Visual Studio, etc.)

Non-Technical

  • Data analysis skills

  • Agile methodologies/SCRUM

  • Development documentation

  • Excellent interpersonal and communications skills

  • Capable of working independently and in a team

  • 24x7 support shift schedule

Additional Skills

  • Microsoft Azure experience

  • Healthcare/Medical/Insurance data experience

  • Tableau reporting

  • Microsoft SSAS

Our Company and What We Offer

evi

Core healthcare is committed to making a positive impact on healthcare, and also making a positive impact on our employees. evi

Core 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.


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Data Lake Operations Engineer/Hadoop Devops Job Description

Evicore

Posted 2 months ago

VIEW JOBS 2/15/2020 12:00:00 AM 2020-05-15T00:00 Summary Are you a Data Engineer with experience in Hadoop who is looking to effect change in healthcare at the individual and societal level? Are you driven by continuous personal improvement, motivated to action and excited by challenging projects? Then keep reading! Data Lake Operations Engineer/Hadoop DevOps Job Description This operations support position is responsible for managing data lake jobs and daily production loads. This will entail the full scope of the data load processes, including source systems, the ingestion engine, process management, and SLA tracking. This will require knowledge of data lake operations, HDFS, Kafka, NiFI, HAWQ, and medical data. This position will be required to troubleshoot and resolve data load process issues, including bad data, mapping, performance issues, and reviewing process functionality for issues. This position must also have experience with automation, process improvement, documentation, development, SDLC, source control, and versioning as data lake development work will be required from time to time. This position will be responsible for participating in the 24x7 shift schedule. Other duties will be determined as necessary. Minimum Experience Required Minimum 2 years of experience with Hadoop/HDP in an enterprise data lake environment Experienced with Java, NiFi, Kafka, HDFS, HAWQ, Shell scripting and performance optimization Required Skills * Excellent debugging skills * Independently handle data ingestion issues, create root cause analysis, and adhere to data availability SLA * Work on reducing frequently occurring issues * Automate manual work and minimize manual intervention * Monitor data ingestion finish time - handle surge in data volume * Maintain project metrics and identify new metrics based on the business requirements * Excellent written and verbal communication * Data lake job and process automation, management, and improvements * Knowledge and experience with best practices and standards around big data Technical * Data analysis skills * Agile methodologies/SCRUM * Development documentation * Excellent interpersonal and communications skills * Capable of working independently and in a team * 24x7 support shift schedule Additional Skills Hortonworks Data Platform and DataFlow Healthcare/Medical/Insurance data experience Our Company and What We Offer eviCore 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. Evicore Franklin TN

Data Warehouse Operations Engineer/Sql Server Devops Job Description

Evicore