Apply for job
View Job
We are the 1st Hub for Developers! Our motto is “From Developers to Developers”! Our vision is to provide real career opportunities for candidates that want to take the next step in their career. Code.Career is the first process that you will speak with developers (only!) and tech (freak) experts!
Our client is a leading research-based biopharmaceutical company. They apply science and their global resources to deliver innovative therapies that extend and significantly improve lives. Every day, colleagues work across developed and emerging markets to advance wellness, prevention, treatments and cures that challenge the most feared diseases of our time.
Role Summary:
All over the world, Pfizer colleagues are working together to positively impact health for everyone, everywhere. Each position at Pfizer touches and contributes to the success of our business and our world. That’s why, as one of the global leaders in the biopharmaceutical industry, Pfizer is committed to seeking out inspired new talent who share our core values and mission of making the world a healthier place.
The Enterprise Data Solutions and Engineering (EDSE), a Pfizer Digital organization, is responsible for the development and management of all data and analytics tools and platforms across the enterprise – from global research and development, to manufacturing, to commercial, to patient care across over 100+ countries. One of the team’s top priorities is the advancement of AI/ML enabled analytics and the creation of data solutions that can be leveraged across the enterprise.
As a member of EDSE’s Global Business Services & Enabling Functions Data Solutions & Engineering team, you will help to realize Pfizer Digital strategy on the cloud by designing and deploying analytic solutions, lead high performing teams, and building lasting relationships with our business colleagues. This digital program will produce the data foundation that drives business insights through data science and enterprise BI reporting solutions. This role requires you to provide solution development and operations support for our HR & Corporate Functions Domains (Human Resources, Learning & Development, Legal, Corporate Affairs, and Compliance etc.). It will require you to build, enhance and maintain ETL, data pipelines, and business intelligence solutions and provide operations support for our HR data and analytics solutions while leveraging our Data Hub, Snowflake, Data Visualization products such as Tableau, and boutique SaaS based People Analytics solutions such as Visier. You will utilize your data analytics and domain experience in the Human Resources field to create innovative data and analytics products that will help our Human Resources and business teams achieve their mission – Unleash the power of our people.
The Manager – HR & Corporate Functions Data & Analytics Engineering will be responsible for all aspects of the data and analytic platforms supporting the People data and HR Analytics. You will help in the pursuit of the Pfizer Digital strategy on the cloud by designing and developing data products. These products are the data foundation that enables business insights through data science and enterprise solutions. You will be very well versed in many toolsets such as People Analytics solutions such as Visier and OneModel, SnowFlake, IICS, Informatica Power Center, Business Objects, Unix, Python, Oracle RDBMS, Angular, Agile Methodology, Dataiku, Tableau. You will also assist in the enrichment of several existing data pipelines that are built upon the current on-premise HR data hub, upcoming cloud-based People Experience, and Corporate Functions Data Lake, to develop value-added data products that span various People Experience (HR) and Corporate Functions business units.
As the Manager – HR & Corporate Functions Data & Analytics Engineering, you will be hands on and have abilities to lead a group of vendors resources, partner with Digital Colleagues, Enterprise Architecture, and Business Unit stakeholders to develop and sustain the HR & Corporate Functions data strategy and target data architecture. Data engineers also partner with solution development teams to ensure use case delivery goals are met while developing and adhering to data architecture principles, guidelines, and standards.
Generally, the colleague will also have the responsibility to assist in the architect, design and build data models, pipelines and products across various domains to power ML ops platforms, data driven applications and software and enable business intelligence solutions. This role will work with the business unit and digital leadership to understand the growing business needs and strategies where the application of AI and ML can yield new products and services and enhance existing processes.
You will also embody Pfizer’s OWNIT! Culture values. We seize opportunities to think differently, to take risks and be accountable, and to try something new. This means Pfizer values change-oriented behavior, exemplified through an entrepreneurial, confident, and proactive attitude. Pfizer also values tolerance for taking thoughtful risks to achieve greater success. We advocate and drive long-term, aligned strategies that advance our mission and shape our industry. We confront corrosive, self-serving, and mean-spirited behaviors; it’s everyone’s responsibility. We deliver on commitments with speed, decisiveness, and integrity. We invest in candid and constructive debate to ensure each other’s success using straight talk.
Role Responsibility:
Reporting to the Director of HR Solution Engineering, and as the HR & Corporate Functions Data & Analytics Engineer you will be responsible for data modeling, building/enhancing data interfaces, and engineering visualizations with the advanced data platforms team to drive digital outcomes.
1. Maintain and enhance the design of the existing on-premise and cloud-based HR & Corporate Functions Data Lakes, Informatica power center data flows, Oracle RDBMS programming, SnowFlake ELT programming, Unix shell scripts, Business Objects reports, Tableau Visualizations, and People Analytics visualizations
2. Manage a team of vendor developers that will deliver technical enhancements within the HR & Corporate Functions Domains (HR, Learning, Legal, Compliance, and Corporate Affairs).
3. Design automated solutions for building, testing, monitoring, and deploying ETL and ELT solutions.
4. Analyze existing and new data sources and new systems and tools to enable the teams to consume and understand data more intuitively
5. Coordinate with source systems engineering teams to analyze data to improve efficiency, performance as well maintain elevated levels of data quality and data consistency.
6. Perform root cause analysis and resolve Level 3 production and data issues
7. Create and validate test plans, test scripts and perform data validation
8. Tune SQL queries, reports and ETL pipelines
9. Build and maintain data dictionary and process documentation
10. Present solutions to leadership, management, architects, and developers.
11. Lead cloud data engineering staff, and partner with project managers, and analysts to deliver insights to the business
12. Provide hands-on technical and thought leadership across development, product management, operations, and engineering management through effective communication. Actively develop mentoring relationships within or across teams to help others further their careers
13. Applies analytical and problem-solving experience with large-scale platforms, infrastructure, and organizations.
14. Work with Analytics enablement teams to enhance and deploy new analytics capabilities in support of the broader mission to democratize data and analytics assets within the HR & Corporate Functions domains
Basic Qualifications:
- BS/MS degree in Computer Science, Engineering, Information Systems or related field
- Experience in the Human Resources field with a specific focus on People Data & People Data Engineering, Human Resources Reporting, and Workforce Analytics is required.
- Strong Experience in traditional and modern data engineering such as Informatica Power Center, IICS, SnowFlake, Oracle RDBMS programming, Unix shell scripting, Python, etc is required
- 5+ years of experience in Data warehousing, data modeling, and data transformation is required.
- 5+ years of experience as a Data Engineer / 3+ years of experience as a Data Architect is required.
- Experienced with data preparation and ETL: Informatica, Talend, Alteryx, Dataiku etc is required.
- Deep understanding of Cloud data warehouse solutions (Snowflake, Redshift, Spark, etc) is required.
- 5+ years of experience designing complex, integrated and interdependent data models for analytic, Machine learning use cases.
- Deep understanding and experience of AWS Cloud stack and (EC2, S3, Glue, Data Pipeline, Redshift) or Google Cloud Platform is required.
- Demonstrated project management experience in owning and managing a significant organizational or data engineering and analytics project budget focusing on data engineering ($200K to $1MM annually)
