Location:

Department:

Shift:

Standard Weekly Hours:

Summary:

The Data Engineer Senior is an experienced data professional who analyzes, architects and engineers data pipelines and data integration activities to power data products and support the overall Knowledge Management and Data Operations mission at Cook Children's.
This role is responsible for data engineering activities including data pipeline design, data ingestion, data integration, data cleansing, data mapping, data store architecture, data transformation, tuning, testing, and data quality. This role actively drives the expansion of the Cook data platform through data flow development, workload management, data architecture/structures/schemas, orchestration and metadata/lineage. The Data Engineer Senior partners with Business Intelligence developers and analysts to design robust, scalable data pipelines and data architectures that power reports, dashboards, integrations and advanced analytics products/capabilities while enabling rapid experimentation. This positon interfaces with business customers and bridges the gap between business and technology solutions throughout the data product lifecycle to ensure that technical solutions meet the needs of the business.
The Data Engineer Senior has strong expertise with SQL, data modeling (relational and/or data warehouse context), and ETL/ELT development. They have familiarity with modern cloud-based data platforms (data lake, data warehouse), cloud data integration technologies, business intelligence tools (Power BI, Tableau, etc.), and at least one modern programming language (Python, Scala, Java, etc). They have demonstrated experience aligning data architectures with business requirements and building data pipelines that interface well with on premise systems/applications as well as modern data sources (APIs, web data sources, real-time/streaming, unstructured data, etc.). They have excellent analytical skills and have demonstrated success in succinctly conveying complex data concepts for storytelling and to influence decision making.
The Data Engineer Senior is seen as an experienced leader and mentors less experienced data engineers, effectively sharing knowledge and best practices.

Qualifications:

• High school diploma or GED required.

• Bachelor's degree in Computer Science, Engineering, Management Information Systems (MIS), Business or related/relevant degree AND minimum of 5 years of experience as a Data Engineer, Database Developer, BI Developer, Software Engineer, Programmer, Technical or Systems Analysts, and/or Database Administrator preferred.

• OR Minimum of 7 years of experience as a Data Engineer, Database Developer, BI Developer, Software Engineer, Programmer, Technical or Systems Analysts, and/or Database Administrator required.

• Minimum of 5 years of experience in Information Technology required.

• Minimum of 2 years of experience in a Health Care environment preferred. Knowledge and Experience

• Demonstrated strength in SQL coding, data integration, data modeling, data pipeline and ETL/ELT design and development.

• Data lake and data warehouse experience including: end to end data warehousing methodology, relational and dimensional design/modeling, architecture, implementation, security, and support/maintenance

• Coding proficiency in at least one modern programing language (Python, Scala, Java, Spark, etc.) preferred.

• Strong experience with modern data ingestion and transformation technologies such as Fivetran, Stitch, dbt, etc as well as traditional data integration/management tools such as SSIS, Informatica, etc.

• Experience with cloud data lake/data warehouse technologies such as Snowflake, Azure Synapse, AWS Redshift, etc. preferred.

• Demonstrated experience identifying opportunities to simplify and automate tasks while building reusable components across multiple use cases.

• Experience with Agile, DataOps delivery methodologies

• Comfortable with ambiguity, experimentation and rapid iteration.

• Proven experience with business and technical requirements elicitation, analysis and verification.

• Able to exercise independent judgment and take action.

• Excellent analytical, mathematical, and creative problem-solving skills.

• Excellent listening, interpersonal, written and oral communication skills. Logical and efficient, with keen attention to detail.

• Highly self-motivated and directed. Ability to effectively prioritize and execute tasks while under pressure.

• Strong customer service orientation. Experience working in a team-oriented, collaborative environment.

• Experience working with structured, semi-structured and unstructured data preferred.

• Experience working with healthcare specific applications and data systems (Electronic Health Record, imaging systems, pharmacy systems, etc.), business systems (ERP, CRM, etc.) and digital platforms preferred.

• Experience with Epic Clarity and/or Caboodle preferred.

Licensure/Certification:

• Epic certification(s) a plus, and may be required upon hire or within six months of hire date based on the primary responsibilities/focus of the role.

• Preferred Epic certification(s) include Cogito Systems Administration, Caboodle-Clarity Development, Caboodle Development, Clarity Data Model, Clinical Data Model, Revenue Cycle Data Model, Access Data model, and/or Caboodle Data Model.

• Snowflake and/or Microsoft certification(s) a plus

• Other relevant data engineering certification(s) a plus

About Us:

Cook Children's Health Care System

Cook Children's Health Care System offers a unique approach to caring for children because we are one of the country's leading integrated pediatric health care delivery organizations. Patients benefit from the integrated system because it allows Cook Children's to use all of its resources to treat a patient and allows for easy communication between the various companies by physicians with a focus on caring for children and adolescents.

Cook Children's is an equal opportunity employer. As such, Cook Children's offers equal employment opportunities without regard to race, color, religion, sex, age, national origin, physical or mental disability, pregnancy, protected veteran status, genetic information, or any other protected class in accordance with applicable federal laws. These opportunities include terms, conditions and privileges of employment, including but not limited to hiring, job placement, training, compensation, discipline, advancement and termination.