Principal Data Engineer

design, articulate, and deliver complex, large-scale data solutions that are scalable, robust, secure, and resilient. Collaborate with Data Management team in implementing and managing data strategies that optimizes metadata, lineage, and quality standards in building FAIR data products. Support development and availability of information assets in the form of data services and products for internal and external consumption to ensure consistency and strategic alignment of all BI and analytics needs. Ability to understand and develop ELT processes with our set of tools, Python, and SQL queries to create aggregates/cubes/marts for data solutions, based on end user requirements. Assess new data sources to better understand availability and quality of data. Create, design, and maintain reusable datasets for AI projects. Provide governance and best practices of data structures, data integrity, and querying. Manage and continuously improve support processes and deliverables related to information delivery - working in partnership with the Managed Services team. Responsible for identifying, capturing, and managing system defects and root cause assessments. Mentor and train personnel within and outside of the information delivery group for data requests. Essential Skills/Experience A Bachelor's Degree or Master's degree in Computer Science, Information Systems, Engineering, Business, or related field. 5 years or more of experience in data engineering, business analysis and data management. Experience designing and developing methods to consolidate and analyze structured and unstructured data. Proficiency in Python and technologies such as dbt, Fivetran, Glue, S3, GitHub (CI/CD), Apache Airflow (MWAA), Snowflake. Solid understanding of analytic data architecture and data modelling concepts. Previous experience working with upstream source systems like Veeva CRM, Salesforce, Google Analytics, SAP. Expertise in designing solutions for handling large files with various structures. Familiarity with data governance, data quality, testing tools like Collibra, Soda, Experian. Project management skills and effective communication with both technical and non-technical stakeholders. Team leadership skills like providing constructive feedbacks and fostering a collaborative team environment. Desirable Skills/Experience Pharmaceutical or Life Sciences industry experience AWS Architecture Framework knowledge and certification SnowPro Core certification