Data Engineer, Senior

Location:

Medical Office Building-Fort Worth (750 8th Ave)

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.

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