Senior Data Analyst

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’s Commitment to Diversity, Equity, and InclusionCHOP is committed to building an inclusive culture where employees feel a sense of belonging, connection, and community within their workplace. We are a team dedicated to fostering an environment that allows for all to be their authentic selves. We are focused on attracting, cultivating, and retaining diverse talent who can help us deliver on our mission to be a world leader in the advancement of healthcare for children.We strongly encourage all candidates of diverse backgrounds and lived experiences to apply.A Brief OverviewThe Data & Analytics (DnA) team at Children's Hospital of Philadelphia (CHOP) provides various services including engineering, analytics, applied data science, data literacy, and data trust for the enterprise.The Lead Analytics Engineer will directly manage and lead a small team of analytics engineers who build and support the data analytics platform. The mission of the analytics engineering team is to ingest, manage, and transform the enterprise's data assets into actionable insights which would help to improve various functions of healthcare delivery system. In partnership with an Analytics Engineering Manager, this position will be responsible for leading a team of Data/Analytics Engineers to build and support the data analytics platform. This role will be responsible for contributing to data architecture to help build sustainable data infrastructure (data models/data content) to improve self-service analytics capabilities and data insights. This role will be responsible for establishing standards and best practices for developing and maintaining data models, ELT pipelines and analytics artifacts.The ideal candidate is experienced with building data pipelines in code (primarily SQL) and deploying changes using modern CI / CD processes to ensure optimal delivery of the service to keep high standards of experience for the end users as well as analysts. The right candidate will be a process fanatic and is excited by the prospect of re-designing our company's data architecture to support our next generation of products and data initiatives.This position has on-site expectations of at least once per month in our Philadelphia offices as needed.What you will do• Develop standards for data modelling and review data models and data pipelines built by others• Build usable data infrastructure that is supportable, secure, and of high quality• Thoughtfully apply software engineering best practices to the analytics workflow• Identify and implement automations for manual processes, re-design infrastructure to be more scalable and performant• Make recommendations about new technology adoption, integrations, libraries, and frameworks• Establish best practices for managing infrastructure as code• Direct line management of small team of data and analytics engineers• Mentor high performing team, motivate, and develop staff to maximize their contributions• Responsible for project management, including project estimation, resource allocation, and Participate in RFP / RFIs• Contribute to enterprise data governance standards; educate and support colleagues to ensure that data is used appropriately• Ensure high quality code review for enterprise data products; develop automations to provide guard rails to the data release process• Maintain and support a shared production on-call support model for the team• Act as the voice of the customer to offer concrete feedback, and advocate for analytics within the business itself• Communicate changes and collaborate across the business to manage large changes that have significant business impactEducation Qualifications• Bachelor's Degree Required• Master's Degree Computer Science, Informatics, Information Systems or similar field of study. PreferredExperience Qualifications• At least six (6) years Data Warehousing Platforms/tools (including ETL/ELT solutions)(OR) Database administration Required• At least ten (10) years Data Warehousing Platforms/tools (including ETL/ELT solutions)(OR) Database administration Preferred• At least one (1) year working with at least one of the public cloud platforms such AWS/Azure/GCP. PreferredSkills and Abilities• Proven knowledge of building and maintaining data models.• Experience with BI/Visualization tools• Knowledge of version control systems such as Git.• Experience utilizing Agile methodology• Knowledge of ITIL processes• Strong communication, project management and organizational skills• Basic understanding of Operating systems, networking concepts and application architecture patterns• Ability to code with scripting languages such as Python, Bash, groovy etc.,• Knowledge of big data toolset: Hadoop, Spark, Kafka, Hive, sqoop etc.• Basic knowledge of data integration tools: dbt, Informatica, MS Integration Services etc.• Knowledge of stream-processing systems: AWS Kinesis, Spark-Streaming, etc.• Basic understanding of ways to consume and build APIs• Healthcare domain experience (Preferred proficiency)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 be fully vaccinated against COVID-19 and receive an annual influenza vaccine. Learn more.Employees may request exemptions for valid religious and medical reasons. Start dates may be delayed until candidates are immunized or exemption requests are reviewed.EEO / VEVRAA Federal Contractor | Tobacco Statement