Manager, Reporting Engineering

ROLE SUMMARY

The AI, Data, and Analytics (AIDA) organization team, a Pfizer Digital organization, is responsible for the development and management of all data and analytics tools and platforms across the enterprise – from global product development, to manufacturing, to commercial, to point of patient care across over 100+ countries.   One of the team’s top priorities is the development of Business Intelligence (BI), Reporting, and Visualization products which will serve as an enabler for the company’s digital transformation to bring innovative therapeutics to patients. 

We are looking for a technically skilled and experienced Reporting Engineering Manager who is passionate about developing BI and data visualization products for our Customer Facing and Sales Enablement Colleagues, totaling over 20,000 individuals. This role involves working across multiple business segments globally to deliver top-tier BI Reporting and Visualization capabilities that enable impactful business decisions and high engagement user experiences.

This role will work across multiple business segments globally to deliver best in class BI Reporting and Visualization capabilities that enable impactful business decisions and cohesive high engagement user experiences.  In this position, you will be accountable to have a thorough understanding of data, business, and analytic requirements to deliver high-impact, relevant interactive data visualizations products that drive company performance through continuously monitoring, measuring, identifying root cause, and proactively identifying patterns and triggers across the company to optimize performance.  This role will also drive best practices and standards for BI & Visualization.

This role will work closely with stakeholders to understand their needs and ensure that reporting assets are created with a focus on Customer Experience. This role requires working with complex and advanced data environments, employing the right architecture to build scalable semantic layers and contemporary reporting visualizations.

The Reporting Manager will ensure data quality and integrity by validating the accuracy of KPIs and insights, resolving anomalies, implementing data quality checks, and conducting system integration testing (SIT) and user acceptance testing (UAT).

The ideal candidate is a passionate and results-oriented product lead with a proven track record of delivering data and analytics driven solutions for the pharmaceutical industry.  

ROLE RESPONSIBILITIES

• Engineering expert in business intelligence and data visualization products in service of field force and HQ enabling functions.

• Act as a Technical BI & Visualization developer on projects and collaborate with global team members (e.g. other engineers, regional delivery and activation teams, vendors) to architect, design and create BI & Visualization products at scale.

• Thorough understanding of data, business, and analytic requirements (incl. BI Product Blueprints such as SMART) to deliver high-impact, relevant data visualizations products while respecting project or program budgets and timelines.

• Deliver quality Functional Requirements and Solution Design, adhering to established standards and best practices.

• Follow Pfizer Process in Portfolio Management, Project Management, Product Management Playbook following Agile, Hybrid or Enterprise Solution Life Cycle.

• Extensive technical and implementation knowledge of multitude of BI and Visualization platforms not limiting to Tableau, MicroStrategy, Business Objects, MS-SSRS, and etc.

• Experience of cloud-based architectures, cloud analytics products / solutions, and data products / solutions (eg: AWS Redshift, MS SQL, Snowflake, Oracle, Teradata).

Qualifications

• Bachelor’s degree in a technical area such as computer science, engineering, or management information science.

• 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 governance and data cataloging best practices.

• Relevant experience or knowledge in areas such as database management, data quality, master data management, metadata management, performance tuning, collaboration, and business process management.

• Strong Business Analysis acumen to meet or exceed business requirements following User Center Design (UCD).

• Strong Experience with testing of BI and Analytics applications – Unit Testing (e.g. Phased or Agile Sprints or MVP), System Integration Testing (SIT) and User Integration Testing (UAT).

• Experience with technical solution management tools such as JIRA or Github.

• Stay abreast of customer, industry, and technology trends with enterprise Business Intelligence (BI) and visualization tools.

Technical Skillset

• 4+ years of hands-on experience in developing BI capabilities using  Microstrategy

• Proficiency in common BI tools, such as Tableau, PowerBI, etc.. is a plus.

• Common Data Model (Logical & Physical), Conceptual Data Model validation to create Consumption Layer for Reporting (Dimensional Model, Semantic Layer, Direct Database Aggregates or OLAP Cubes)

• Develop using Design System for Reporting as well as Adhoc Analytics Template

• BI Product Scalability, Performance-tuning

• Platform Admin and Security, BI Platform tenant (licensing, capacity, vendor access, vulnerability testing)

• Experience in working with cloud native SQL and NoSQL database platforms. Snowflake experience is desirable.

• Experience in AWS services EC2, EMR, RDS, Spark is preferred.

• Solid understanding of Scrum/Agile is preferred and working knowledge of CI/CD, GitHub MLflow.

• Familiarity with data privacy standards, governance principles, data protection, pharma industry practices/GDPR compliance is preferred.

• Great communication skills.

• Great business influencing and stakeholder management skills.

Pfizer is an equal opportunity employer and complies with all applicable equal employment opportunity legislation in each jurisdiction in which it operates.