Data Engineer II

Cincinnati Children's

18h•$94,037 - $120,078•Remote

About The Position

This role is responsible for designing, building, testing, and managing data pipelines, from data sources to consumption, for key data and analytics consumers. The Data Engineer II will ensure compliance with data governance and security requirements, operationalize data pipelines, and support upgrade and testing initiatives. The position involves making changes to ETL processes, extracting and analyzing data from the Epic source system, and developing solutions for benchmarking, process improvement, and to avoid interference with transactional systems. Additionally, the role involves developing and implementing data models, documenting data models and extract processes, automating data preparation and integration tasks, and refining existing solutions. The position requires proficiency in Data Management practices (Data Modeling, Data Warehousing, Data Lake, Data Hub), SQL, object-oriented/object function scripting, and DevOps principles. A foundational understanding of core CCHMC clinical, business, and research processes is necessary. The role also includes providing end-user support, monitoring Service Level Agreements, adhering to change management policies, modeling outstanding customer service, escalating support issues, collaborating with stakeholders (data science teams, data analysts), providing second-level incident resolution, and maintaining support documentation. The Data Engineer II will also take 24-hour call on a staff rotation and execute project tasks with urgency and quality, communicate status effectively, follow time-tracking requirements, participate in project meetings, and serve as a technical lead for moderately complex projects.

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.

Nice To Haves

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.
Obtain Epic certifications as appropriate/needed.
Build additional skills through continuing education.

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