As a data engineer at Carilion Clinic, you will design, deploy, and support data acquisition and integration for both cloud and on-premise solutions. Your role will involve structuring data in the data warehouse and data marts for business intelligence solutions, including dashboards, scorecards, reports, and self-service analytics. You will source data from operational systems, perform integration, and execute secondary transformations. Additionally, you will support end-user web-based presentation layers and the underlying technology layers, including data models, dimensional databases, cubes, and security infrastructure. You will gather and process raw structured data using batch data processing frameworks and develop SQL coding assets in collaboration with Data Analysts and BI Developers. Your responsibilities will also include utilizing data testing processes for unit and integration testing, managing tasks associated with larger projects, and assisting senior data engineers in creating training materials for end-user training programs. You will interface with clients, vendors, and multiple technology teams to resolve incidents and problems, while also understanding basic root cause analysis skills.