Data Engineer, Senior

Location: Rosedale Office Building Department: IS Epic Shift: First Shift (United States of America) Standard Weekly Hours: 40 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. 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. 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 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. Promise, a strong word with deep meaning that everyone understands—especially kids. This is the foundation of our organization and what drives us to blaze new trails in medical care, research, advanced technology, as well as programs and initiatives that benefit children who may not otherwise have access to quality health care. Every day our employees come to work with the intention of keeping our Promise. It's the guiding principle that helps our patients and their families get better and stay healthy. As a member of our Cook Children's team, you can be an important part of making that happen.