Data Engineer II

Job Title

Data Pipelines - Design, build, test and manage simple to moderately complex data pipelines from data sources or endpoints of acquisition to integration to consumption for production for key data and analytics consumers like business/data analysts, data scientists, etc. Guarantee compliance with data governance and data security requirements while creating, improving and operationalizing data pipelines, partnering effectively with platform engineers and database administrators. Follow best practice development practices to ensure agile updates to data pipelines from development to production and back. Make simple to moderately complex changes to ETL processes and support upgrade and testing initiatives as necessary. Pursue additional options for data extraction and analysis from the Epic source system to deliver data to meet customer needs for research, regulatory, and collaborative initiatives. Understand benchmarking and process improvement data requirements and develop solutions to address these requests. Develop moderately complex solutions to ensure data analytic solutions don't interfere with transactional systems.

Metadata Management & Data Modeling - Develop and implement simple to moderately complex data models to support CCHMC strategies. Work with key customer and report/analytic development groups to help ensure solutions are being developed with scalability and efficiencies in mind. Develop documentation of data models and extract processes, so information can be referenced by team members and customers to understand design objectives. Use innovative and modern tools, techniques and architectures to partially or completely automate the most-common, repeatable and tedious data preparation and integration tasks in order to minimize manual and error-prone processes and improve productivity. Continually refine existing solutions, so that best practices are deployed in individual reports, database structure, and extraction techniques. Work with vendors when necessary to ensure CCHMC investments and requests are being adequately supported and enhanced. Address reporting requests that require more complex solutions or require a deeper knowledge of the source system data models.

Technical & Business Skill - Proficiency in one or more Data Management practices and architectures, such as Data Modelling, Data Warehousing, Data Lake, Data Hub, etc. and foundational understanding of the others. Proficiency with SQL, object-oriented/object function scripting and DevOps principles. Demonstrate understanding of core CCHMC clinical, business and research processes to help build appropriate data solutions. Obtain Epic certifications as appropriate/needed. Build additional skills through continuing education.

Technical Support & Customer Services - Ensure outstanding end-user support is provided, including ongoing monitoring of Service Level Agreements for incident management and collaboration with other areas to ensure customer-centered incident management and support. Adhere to and promote continual adoption of change management policies and procedures. Model outstanding customer service behavior, including timely and effective follow-up with customers. Escalate support issues with urgency. Collaborate with various stakeholders within the organization. In particular, work in close relationship with data science teams and with business (data) analysts in refining their data requirements for various data and analytics initiatives and their data consumption requirements. Provide second-level incident and problem resolution and support departmental efforts to improve customer satisfaction. Maintain and refine support documentation. Escalate support issues with urgency. Take 24 hour call on a staff rotation.

Project Execution & Management - Execute own project tasks with urgency and to a high level of quality