Manager - HR & Corporate Functions Data & Analytics Engineering

Role Summary

The Manager of HR & Corporate Functions Data & Analytics Engineering leads the design, development, and operation of data solutions across Human Resources and Corporate Functions. This role is hands-on and involves managing vendor resources, partnering with Digital Colleagues and stakeholders to create data strategies, architectures, and analytics products that enable ML, BI, and data-driven decision making. The role emphasizes delivering rapid, high-quality data engineering work while embodying Pfizer’s OWNIT! culture and driving business outcomes.

Responsibilities

• Responsible for people data engineering, people data architecture, data modeling, building/enhancing data pipelines, and visualizations to drive digital and business outcomes.
• Maintain and enhance the design of the existing on-premise and cloud-based HR & Corporate Functions Data Lakes, Informatica PowerCenter data flows, Oracle RDBMS programming, Snowflake ELT programming, Unix shell scripts, Business Objects reports, Tableau visualizations, and People Analytics visualizations.
• Solution delivery/project management to oversee a team of vendor developers delivering enhancements within HR, Learning, Legal, Compliance, and Corporate Affairs; ensure adherence to best practices and architectural standards.
• Design automated solutions for building, testing, monitoring, and deploying ETL/ELT solutions.
• Analyze data sources and new systems/tools to enable intuitive data consumption and understanding.
• Coordinate with source systems engineering to analyze data for efficiency, performance, data quality, and consistency.
• Perform root cause analysis and resolve Level 3 production and data issues.
• Create and validate test plans, test scripts, and perform data validation.
• Tune SQL queries, reports, and ETL pipelines.
• Build and maintain data dictionary and process documentation.
• Present solutions to leadership and teams; lead cloud data engineering staff and partner with project managers and analysts to deliver insights.
• Provide hands-on technical and thought leadership; mentor team members to help their careers.
• Apply analytical/problem-solving expertise to large-scale platforms and infrastructure.
• Collaborate with Analytics enablement teams to deploy new analytics capabilities to democratize data across HR & Corporate Functions domains.

Qualifications

• BS/MS in Computer Science, Engineering, Information Systems, or related field.
• Experience in Human Resources with a focus on People Data, People Data Engineering, HR Reporting, and Workforce Analytics.
• Strong experience in traditional and modern data engineering (Informatica PowerCenter/IICS, Snowflake, Oracle RDBMS, Unix shell scripting, Python, etc.).
• 5+ years in data warehousing, data modeling, and data transformation.
• 5+ years as a Data Engineer; 3+ years as a Data Solution Architect.
• Hands-on experience with Generative AI-based data pipeline and analytics solutions; data preparation and ETL using modern tools (AirFlow, Snowflake, etc.).
• Deep understanding of cloud data warehouse solutions (Snowflake, Redshift, Spark) and AWS/GCP stack.
• 5+ years designing complex data models for analytic/ML use cases.
• Experience with cloud platforms (AWS or GCP) and budget management for data engineering projects ($200K‚Äì$1MM annually).

Skills

• SQL, Python, Scala, Java and other data processing languages
• Data modeling, ETL/ELT design, and data architecture
• Cloud data platforms (Snowflake, Redshift, AWS/GCP)
• Data governance, data quality, and data dictionaries
• Project management and vendor leadership
• Communication and collaboration across leadership, architects, and developers

Education

• BS/MS degree in Computer Science, Engineering, Information Systems or related field

Additional Requirements

• Hybrid work location