Data Engineer II

How You’ll Help Transform Healthcare:

Onsite is preferred, hybrid or remote work option is available. Candidates residing in the following states can be considered for remote work: Alabama, Florida, Georgia, Arkansas, Kentucky, Louisiana, Mississippi, North Carolina, South Carolina, Tennessee, West Virginia, and Virginia.

Designs, deploys and supports data acquisition and data integration solutions from source systems to the data warehouse and data marts for business intelligence solutions such as dashboards, scorecards, reports and self-service analytics. Sources data from operational systems with integration and subsequent and secondary transformation. Supports end-user web-based presentation layers and the underlying technology layers including data models, dimensional databases, cubes and security infrastructure.
 

• Gathers and processes raw, structured, semi-structured, and unstructured data using batch processing frameworks.
• Develops moderate to advanced SQL coding assets including tables, views, stored procedures, user defined functions in collaboration with the Data Analyst and BI Developer while adhering to technical solution standards and demonstrating flexibility when required.
• Develops and utilizes data testing processes to complete both unit testing and integration testing, collaborating with team members, to validate data solutions
• Independently develops reference materials (database diagrams, flow charts, script documentation, etc.) for supported data processing technologies to be used for both online and in-person training of other technical staff.
• Manages assigned projects and meets deadlines with minimal supervision from supervisor and/or manager.
• Assists senior data engineers by creating training material for use in end-user training programs as well as development of team members
• Serves as a technical mentor to other Data Engineers.
• Interfaces with clients, vendors, and multiple technology teams while providing resolution to incidents and problems as escalated from the Technology Service Center.
• Understands basic root cause analysis skills and techniques and performs such tasks with little to no assistance from senior data engineers.
• Understands commonly used software development concepts (CI/CD, unit testing, publish-subscribe architecture, REST interfaces, etc.) and able to assist senior data engineers.

What We Require:

Education: Bachelor’s Degree in a science discipline preferably computer science or information systems; or equivalent work experience.

Experience: Minimum 2 years experience in working with enterprise data and cloud technologies.

Licensure, certification, and/or registration: Valid Virginia drivers' license and dependable transportation. A minimum of two of the following certifications are required: W3Schools SQL Certification, SnowPro Core Certification, Epic Caboodle ETL Certified Administrator, DAMA CDMP Associate, Talend Data Integration Certified Developer, Talend Big Data Certified Developer, Talend Cloud Certified Administrator, Python PCEP, Python PCAP, Python PCAD, AWS Cloud Practitioner, Azure Data – Fundamentals

Other Minimum Qualifications: Good organizational skills, analytical, dependable, detail oriented, interpersonal skills, and understanding of the English language (both written and oral). Data profiling and data quality analysis experience preferred. Cloud data services, dimensional databases, cubes and columnar data structures experience preferred. Must have excellent problem-solving skills and be customer service oriented.

About Carilion

This is Carilion Clinic ...

An organization where innovation happens, collaboration is expected and ideas are valued. A not-for-profit, mission-driven health system built on progress and partnerships. A courageous team that is always learning, never discouraged and forever curious.

Headquartered in Roanoke, Va., you will find a robust system of award winning hospitals, Level 1 and 3 trauma centers, Level 3 NICU, Institute of Orthopedics and Neurosciences, multi-specialty physician practices, and The Virginia Tech Carilion School of Medicine and Research Institute.

Carilion is where you can make your own path, make new discoveries and, most importantly, make a difference. Here, in a place where the air is clean, people are kind and life is good. Make your tomorrow with us.