IS Data Engineer I

Children's Hospital Of Philadelphia Philadelphia , PA 19107

Posted 3 months ago

"

CHOP EMPLOYEE? SEARCH FOR JOBS HERE.

IS Data Engineer I

Philadelphia, PA, US, 19107

Job Type:

LOC_1300_MKT-Wanamaker Building Req ID: 42481

Shift: Days

Employment Status: Regular - Full Time

Job Summary

We are looking for a Data Engineer to join our growing team of analytics experts. The hire will be responsible for expanding and optimizing our data warehouse and building data integrations, developing data best practices and governance, performing clinical and administrative reporting and data visualization, as well as optimizing data flow and collection for cross functional teams.

The ideal candidate has knowledge of and is excited to learn about all aspects of data from multiple complex sources who enjoys optimizing data systems and building them from the ground up. The Data Engineer I will support our developers, database architects, data analysts and data scientists ensuring optimal data delivery architecture is consistent throughout ongoing projects. They will also support non-technical colleagues in the collection and appropriate use of clinical and non-clinical data. They must be self-directed and comfortable supporting the data needs of multiple teams, systems and products. The right candidate will be excited by the prospect of optimizing or even re-designing our company's data architecture to support our next generation of products and data initiatives.

Job Responsibilities

  • Data Modeling evaluate structured and unstructured data, determine the most appropriate schema for new fact tables, data marts, etc.

  • Data Integration incorporate new business and system data into the CHOP Data Warehouse while maintaining enterprise best practices and adhering to data governance standards.

  • ETL apply business rules to our data as we migrate from source to target using Informatica or scripting language. Validate data to ensure quality.

  • Reporting collaborate with colleagues across the enterprise to scope requests. Extract data from various data sources, validate results, create relevant data visualizations, and share with requester. Develop dashboards and automate refreshes as appropriate.

  • Governance / Best Practices adhere and contribute to enterprise data governance standards. Also educates and supports colleagues in best practices to ensure that data is used appropriately.

  • Product Ownership collaborate and act as the voice of the customer to offer concrete feedback and project requests as well as an advocate for analytics from within the business units themselves.

  • Assemble large, complex data sets that meet functional / non-functional business requirements.

  • Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.

  • Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources (including ground, hybrid cloud, and cloud) using SQL and various programming technologies.

  • Develop analytics tools that utilize data resources to provide actionable insights, operational efficiency and other key business performance metrics.

  • Work with stakeholders including the Executive, Clinical, and Analyst teams to assist with data-related technical issues and support their data infrastructure needs.

  • Develop optimized tools for analytics and data scientist team members that assist them in building and optimizing projects into an innovative industry leader.

  • Proficient at integrating predictive and prescriptive models into applications and processes.

  • Build processes supporting data transformation, data structures, metadata, dependency and workload management.

  • Participate in a shared production on-call support model.

  • Be a critical part of an Agile Scrum software development team, ensuring the team successfully meets its deliverables each sprint.

Required Education and Experience

Required Education:

  • Bachelor's Degree in Computer Science, Computer/Software Engineering, Information Technology or related fields.

Required Experience:

  • Minimum of one (1) year of Data Engineering/Business Intelligence/Data Warehousing experience, preferably in a healthcare environment.

  • Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.

  • Experience supporting and working with cross-functional teams in a dynamic environment.

  • Working knowledge of message queuing, stream processing, and highly scalable data stores.

  • Previous experience manipulating, processing and extracting value from large disconnected datasets.

Preferred Education, Experience & Cert/Lic

Preferred Education:

  • Advanced Degree in Computer Science, Informatics, Information Systems or another quantitative field.

Preferred Experience:

  • Minimum of three (3) years of experience in a Data Engineer role

Additional Technical Requirements

  • Strong analytic skills related to working with structured and unstructured datasets.

  • Must possess critical thinking and creative problem solving skills along with the ability to communicate well with stakeholders throughout the organization.

  • Strong communication, project management and organizational skills.

  • Proficient in SQL

  • Exposure to big data tools: Hadoop, Spark, Kafka, BigSQL, Hive, etc.

  • Experience with relational SQL and NoSQL databases, including IBM PDA (Netezza), MS SQL Server and HBase.

  • Exposure to data integration tools: Informatica, MS Integration Services, Sqoop, etc.

  • Exposure to stream-processing systems: IBM Streams, Flume, Storm, Spark-Streaming, etc.

  • Exposure consuming and building APIs

  • Exposure to object-oriented/object function programming languages: Python, Java, C++, Scala, etc.

  • Exposure to statistical data analysis tools: R, SAS, SPSS, etc.

  • Exposure to visual analytics tools: QlikView, Tableau, Power BI etc.

  • Familiarity to Agile methodology for development

  • Familiarity with electronic health record and financial systems. i.e. Epic Systems, Cerner, WorkDay, Infor, Strata etc.

All CHOP employees who work in a patient building or who provide patient care are required to receive an annual influenza vaccine unless they are granted a medical or religious exemption.

Children's Hospital of Philadelphia is committed to providing a safe and healthy environment for its patients, family members, visitors and employees. In an effort to achieve this goal, employment at Children's Hospital of Philadelphia, other than for positions with regularly scheduled hours in New Jersey, is contingent upon an attestation that the job applicant does not use tobacco products or nicotine in any form and a negative nicotine screen (the latter occurs after a job offer).

Children's Hospital of Philadelphia is an equal opportunity employer. We do not discriminate on the basis of race, color, gender, gender identity, sexual orientation, age, religion, national or ethnic origin, disability or protected veteran status.

VEVRAA Federal Contractor/Seeking priority referrals for protected veterans. Please contact our hiring official with any referrals or questions.

CHOP Careers Contact

Talent Acquisition
2716 South Street, 6th Floor

Philadelphia, PA 19146

Phone: 866-820-9288

Email:TalentAcquisition@email.chop.edu

CHOP EMPLOYEE? SEARCH FOR JOBS HERE.

Nearest Major Market: Philadelphia

Job Segment: Database, Medical, Information Systems, Developer, EMR, Technology, Healthcare


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Manager Big Data Software Engineer

Kpmg

Posted Yesterday

VIEW JOBS 2/20/2020 12:00:00 AM 2020-05-20T00:00 Innovate. Collaborate. Shine. Digital Lighthouse houses KPMG's specialized capabilities across the digital landscape: applied data science, AI, data engineering and insights, software engineering, automation, and big data. Here, you'll work with a sophisticated team of professionals to explore solutions for clients in a multiplatform environment. This means your ability to find answers is limited only by your creativity in leveraging a vast array of techniques and tools. Be a part of a high-energy, unique, fast-paced, and innovative culture that delivers with the agility of a tech startup and the backing of a leading global consulting firm. In this particular role, you'll work specifically in the AI Analytics & Engineering Community within the Digital Lighthouse, on a wide range of projects. From applied AI to optimization to big data platform engineering, your analytical and technical skills will drive real impact in the business world. So, bring your ingenuity and pioneering spirit to KPMG Digital Lighthouse. KPMG is currently seeking a Manager to join our KPMG Lighthouse - Center of Excellence for Advanced Analytics. Responsibilities: * Rapidly architect, design, prototype, implement and optimize architectures to tackle the Big Data and Data Science needs for a variety of Fortune 1000 corporations and other major organizations; Guide an engineer team to develop modular code base to solve real world problems; Lead regular peer code reviews to ensure code quality and compliance following best practices in the industry * Work in cross-disciplinary teams with KPMG industry professionals to understand client needs and ingest rich data sources (social media, news, internal/external documents, emails, financial data, and operational data) * Research, experiment, and utilize leading Big Data methodologies (Hadoop, Spark, Kafka, Netezza, SAP HANA, and AWS) with cloud/on premise/hybrid hosting solutions; Architect, implement, and test data processing pipelines, and data mining/data science algorithms on a variety of hosted settings (AWS, Azure, client technology stacks, and KPMG's own clusters); Provide proficient documentation and operating guidance for users of all levels * Translate advanced business analytics problems into technical approaches that yield actionable recommendations across multiple and diverse domains; Communicate results and educate others through design and build of insightful visualizations, reports and presentations * Develop skills in capturing business requirement and translation, hypothesis-driven consulting, work stream and project management and client relationship development * Help drive the process for pursuing innovations, target solutions, and extendable platforms for Lighthouse, KPMG, and client; Participate in developing and presenting thought leadership, and assist in ensuring that the Lighthouse technology stack incorporates and is optimized for using specific technologies; Help promote the KPMG brand in the broader data analytics community Qualifications: * Minimum of seven years of big data experience with multiple programming languages and technologies with a minimum of five years of relevant business experience; Ability to manage less complex engagements and should have demonstrated risk management & project management skills * Bachelor's degree or Master's degree from an accredited college/university in Computer Science, Computer Engineering, or related field; PhD with minimum three years of big data experience * Demonstrated ability to communicate complex technical concepts succinctly to non-technical colleagues, understand & manage interdependencies between all facets of a project; Ability to lead client presentations; familiarity with the end-to-end sales process; Demonstrated ability to manage the team to drive engagements to successful closure and also the ability to mentor others * Strong ability to rapidly ingest, transform, engineer, and visualize data for both ad-hoc and product-level (e.g., automated) data & analytics solutions; Market-leading fluency in several programming languages such as Python, Scala, or Java, with the ability to pick up new languages and technologies quickly; Understanding of cloud and distributed systems principles, including load balancing, networks, scaling, in-memory vs. disk; Experience with large-scale big data methods such as MapReduce, Hadoop, Spark, Hive, Impala, or Storm; Full-stack development capability is preferred * Proficiency with programming methodologies such as version control, testing, QA, and development methodologies such as Waterfall and Agile; Ability to work efficiently under Unix/Linux environment or .NET, with experience with source code management systems like GIT and SVN * Experience with object-oriented design, coding and testing patterns as well as experience in engineering (commercial or open source) software platforms and large-scale data infrastructures; Familiarity with different architecture patterns of development such as Event Driven, SOA, micro services, functional programming, Lambda; Capability to architect highly scalable distributed systems, using different open source tools * Ability to travel up to eighty percent of the time; Applicants must be currently authorized to work in the United States without the need for visa sponsorship now or in the future KPMG LLP (the U.S. member firm of KPMG International) offers a comprehensive compensation and benefits package. KPMG is an affirmative action-equal opportunity employer. KPMG complies with all applicable federal, state and local laws regarding recruitment and hiring. All qualified applicants are considered for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other category protected by applicable federal, state or local laws. The attached link contains further information regarding the firm's compliance with federal, state and local recruitment and hiring laws. No phone calls or agencies please. Kpmg Philadelphia PA

IS Data Engineer I

Children's Hospital Of Philadelphia