The Data Engineering team within the AI, Data, and Analytics (AIDA) organization is the backbone of our data-driven sales and marketing operations. We provide the essential foundation for transformative insights and data innovation. By focusing on integration, curation, quality, and data expertise across diverse sources, we power world-class solutions that advance Pfizer's mission. Join us in shaping a data-driven organization that makes a meaningful global impact.
We are looking for an experienced Data Warehouse Developer for our International Commercial Cloud Data Marketplace data engineering team. As a data warehouse developer, you will play a crucial role in leveraging data, including build data pipelines, curating data, modeling data for analytics, and providing subject matter expertise to the broader Pfizer community. You will be responsible for developing, and maintaining robust analytics solutions that provide actionable insights to various stakeholders in the commercial organization, contributing directly to Pfizer's global mission of improving Patient lives.
The ideal candidate is a passionate and results-oriented developer with a proven track record of building data pipelines for the pharmaceutical industry.
Role Responsibilities
- Implement end to end data warehouse/data lake solutions to support commercial business objectives, including data profiling, data curation, data modeling and deployment.
- As part of a team, implement strategic data-centric projects sourcing and integrating data from internal and external sources.
- Build intuitive and insightful data products that support business intelligence use cases including reporting, dashboards, analytics, and downstream consumers of commercial data.
- Dive deep to investigate and remediate data quality issues.
- Collaborate with our Data science, performance insights and brand facing analytics teams.
- Actively contribute to project documentation and playbook, including but not limited to physical models, conceptual models, data dictionaries and data cataloging.
Qualifications
- Bachelor's degree in a technical area such as computer science, engineering, IT, or related Health Sciences field.
- 2+ years of combined data warehouse/data lake data development including building data pipelines and data modeling.
- Recent Healthcare Life Sciences (pharma preferred) and/or commercial/marketing data experience is highly preferred.
- Domain knowledge in the pharmaceutical industry preferred.
- Good knowledge of data quality, governance, and data cataloging best practices.
Technical Skillset
- Solid experience in SQL, data curation, ETL tooling and pipeline development.
- 2+ years of hands-on experience with RDBMS/DWs and writing ETL pipelines. Experience with Snowflake is desirable but not necessary.
- Experience with big data engineering.
- Programming ability in Python, Java or other object-oriented programming languages preferred.
- Solid understanding of Agile and CI/CD, is preferred.
- Experience in building data visualization tools and requirements.
- Familiarity with data privacy standards, pharma industry practices/GDPR compliance is preferred.
- Prioritizes excellence in Analytics development by following F.A.I.R. principles and adhering to engineering and documentation standards set for by the organization.
Pfizer is an equal opportunity employer and complies with all applicable equal employment opportunity legislation in each jurisdiction in which it operates.
Information & Business Tech
#LI-PFE
