Data Engineer

Location:

Rosedale Office Building

Department:

IS Epic

Shift:

Standard Weekly Hours:

40

Summary:

The Data Engineer is an independent data professional who analyzes, architects and engineers data pipelines and data integration activities to power analytical data products and support the overall Knowledge Management mission at Cook Children's.

As part of the Data Engineering & Analytics Platform team, this role participates in 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 contributes to the expansion of the analytics platform through data flow development, workload management, data architecture/structures/schemas, orchestration and metadata/lineage. The Data Engineer partners with senior Data Engineers as well as other Business Intelligence developers and analysts to design robust, scalable data pipelines and data architectures that power reports, dashboards 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 lifecycle of the analytics product to ensure that technical solutions meet the needs of the business.

The Data Engineer has experience 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 (SQL, 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.

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 2 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 4 years of experience as a Data Engineer, Database Developer, BI Developer, Software Engineer, Programmer, Technical or Systems Analysts, and/or Database Administrator preferred.
• Minimum of 2 years of experience in Information Technology required.
• Minimum of 2 years of experience in a Health Care environment preferred.
• Demonstrated experience in SQL coding, data integration, data modeling, data pipeline and ETL/ELT design and development.
• Data warehouse experience including: end to end data warehousing methodology, relational and dimensional design/modeling, architecture, implementation, security, and support/maintenance.
• Experience with Microsoft SQL Server platforms and Microsoft BI stack (SSIS, SSAS, SSRS, Power BI).
• Ability to perform troubleshooting on SQL Server, Windows Server, IIS, etc.
• Coding proficiency in at least one modern programing language (Python, Scala, Java, Spark, etc.) preferred.
• 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.
• Familiarity with cloud data lake/data warehouse technologies such as Snowflake, Azure Synapse, AWS Redshift, etc. preferred.
• 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 healthcare specific applications and data systems (Electronic Health Record, imaging systems, pharmacy systems, etc.), business systems (ERP, CRM, etc.) and digital platforms preferred.

Licensure, Registration, and/or 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 EOE/AA, Minority/Female/Disability/Veteran employer.