Data Engineer II

Cincinnati Children’s is hiring a Data Engineer II to build and manage data pipelines and models supporting clinical, business, research, and analytics needs. The role also supports data governance, end-user technical support, and delivery of data and analytics projects.

Responsibilities:

• 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
• 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
• 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
• 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

Requirements:

• 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
• 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
• 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