The Data Engineer focuses on how to design, integrate, and manage complex data and analytic systems over their life cycles. Uses a combination of core software engineering principles and domain specific data and analytic knowledge to ensure the enterprise as seamless access to actionable, meaningful and well-governed data across all domains.
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 bench-marking 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.
Project Execution & Management
Execute own project tasks with urgency and to a high level of quality. Communicate status clearly and effectively using departmental project management tools. Follow time-tracking and other project management requirements. Participate actively in project meetings, stand-ups, etc. Serve as technical lead for moderately complex projects, collaborating with project managers to ensure project scope/risk/budget/etc. are adequately managed. Lead project meetings and workgroups.
Bachelor's degree in a computer science, statistics, applied mathematics, data management, information systems, information science or a related quantitative field.
2 years of work experience in a related job discipline.
Experience working in cross-functional teams and collaborating with business stakeholders in support of a departmental and/or multi-departmental data mgmt and analytics initiative.
At Cincinnati Children’s, we come to work with one goal: to make children’s health better. We believe in a team approach, both in caring for patients and their families, and in advancing science and discovery. We strive to do better, and find energy and inspiration in our shared purpose. If you want to be the best you can be, you can do it at Cincinnati Children’s.