Analytics Engineer

SHIFT: Day (United States of America) Seeking Breakthrough Makers Children’s Hospital of Philadelphia (CHOP) offers countless ways to change lives. Our diverse community of more than 20,000 Breakthrough Makers will inspire you to pursue passions, develop expertise, and drive innovation. At CHOP, your experience is valued; your voice is heard; and your contributions make a difference for patients and families. Join us as we build on our promise to advance pediatric care—and your career. CHOP does not discriminate on the basis of race, color, sex, national origin, religion, or any other legally protected categories in any employment, training, or vendor decisions or programs. CHOP recognizes the critical importance of a workforce rich in varied backgrounds and experiences and engages in ongoing efforts to achieve that through equally varied and non-discriminatory means. A Brief Overview The analytics engineer acts as a bridge between a data engineer and a data analyst. This position is primarily responsible for modeling raw data sets into curated, reusable, trusted data sets which power analytics across the enterprise. These data sets will serve as the single source of truth for data and enable self-service analytics. In addition to the development of data models, this role is responsible for maintaining data quality within these data sets via the use of monitoring, testing, and automation. An additional component of the role is to improve the effectiveness of data analysts and data scientists. This maybe via providing technical expertise in query development, extending data models via the addition of new metrics, and/or consulting on software development practices. The Analytics Engineer owns the entire workflow of data associated with their domain; data pipeline development, ELT performance, timely loading of data sets, and maintenance. This role will work within various business units and partner with data analysts and data scientist to obtain a deep understanding of operational data and develop scalable data products which empower data-driven decision making across the enterprise. This department works approximately 80% remotely, 20% on site in our Philadelphia offices on an as-needed basis. What you will do Collaborate with business subject matter experts, data analysts, and data scientists to understand/identify the opportunities to develop well-defined, integrated, re-usable data sets which power analytics. Codify reusable data access patterns to speed up time to insights. Perform Logical and Physical data modeling with an agile mindset. Build automated, scalable, test-driven ELT pipelines. Utilize software development practices such as version control via Git, CI/CD, and release management Build data products using various visualization, BI tools and data science tools. Collaborate with Data Engineers, DevOps engineers and architects on improvement opportunities for DataOps tools and frameworks. Implement data quality frameworks and data quality checks. Help define analytical product roadmap to drive the business goals and superior quality outcomes. Work with Data Scientists, Statisticians and Machine learning engineers to implement/scale advanced algorithms to solve health care, operational and quality challenges. Work independently and effectively manage ones time across multiple priorities and projects. Make recommendations about platform adoption, including technology integrations, application servers, libraries, and frameworks. Participate in a shared production on-call support model. Be a critical part of a scrum team in an agile environment, ensuring the team successfully meets its deliverables each sprint. Education Qualifications Bachelor's Degree - Required Bachelor's Degree Computer Science, Informatics, Information Systems or another quantitative field - Preferred Experience Qualifications At least three (3) years of experience working in Data and analytics landscape - Required At least six (6) years of experience working in Data and analytics landscape - Preferred At least one (1) year of experience working with at least one of the public cloud platforms such AWS/Azure/GCP - Preferred Skills and Abilities Strong SQL, Data Modeling and Data Warehousing fundamentals. Experience with software development practices; version control, code review, CI/CD Experience with data integration tools: DBT, Informatica, MS Integration Services etc. Experience with big data toolset: Hadoop, Spark, Kafka, Hive, sqoop etc. Experience working with Business Intelligence Tools (Business Objects) or Visualization tools such as Qlik, Tableau, PowerBI etc., Experience with stream-processing systems: IBM Streams, Flume, Storm, Spark-Streaming, etc. Good hands-on experience with Linux (RHEL/Debian) operating system Ability to code with other scripting languages such as Python, Bash, groovy etc., Experience consuming and building APIs Experience utilizing Agile methodology for development To carry out its mission, CHOP is committed to supporting the health of our patients, families, workforce, and global community. As a condition of employment, CHOP employees who work in patient care buildings or who have patient facing responsibilities must receive an annual influenza vaccine. Learn more. EEO / VEVRAA Federal Contractor | Tobacco Statement SALARY RANGE: $101,300.00 - $129,100.00 Annually Salary ranges are shown for full-time jobs. If you're working part-time, your pay will be adjusted accordingly. ------------------- At CHOP, we are committed to fair and transparent pay practices. Factors such as skills and experience could result in an offer above the salary range noted in this job posting. Click here for more information regarding CHOP's Compensation and Benefits. Children's Hospital of Philadelphia (CHOP) is the nation's first hospital devoted exclusively to the care of children. Since our start in 1855, CHOP has been the birthplace for countless breakthroughs and dramatic firsts in pediatric medicine. Built on a foundation of delivering safe, high-quality, family-centered care, the Hospital has fostered medical discoveries and innovations that have improved pediatric healthcare and saved countless children’s lives. Today, families facing complex conditions come to CHOP from all over the world, and our compassionate care and innovation has repeatedly earned us a spot on the U.S. News & World Report's Honor Roll of the nation's best children's hospitals.