Data Analyst / Engineer Saama
Bridgewater, NJ

Job Description

Position Summary

Responsible for the overall management of Medical Affairs Integrated Platform (Pathfinder) systems' datamart on Synapse big data platform. The datamart currently consists of about ten different Medical Affairs functional systems/data sources. This resource will maintain and update the data models as needed for robust analytics using Tableau to derive key customer insights. This resource will champion the usage of data in business, and communicate the benefits and return on investment for application and product owners. Understand the data landscape, business needs, and propose/implement innovative solutions. Supports data provisioning and advanced analytics to address clinical or business questions.

The ideal candidate will be a seasoned analyst with multiple years of experience leading and managing large-scale data analysis projects. The candidate should have demonstrated the ability to actively listen, integrate input from diverse sources and successfully translate medical or business questions into data and analytics requirements, and deliver suitable solutions.

Core Responsibilities:

1. Works across global MA teams to gather analytics related business needs/requirements and to apply this

information to define the scope and strategic objectives for developing, updating and/or maintaining datamart on

Synapse big data platform.

2. Partners with MA business units to ensure requirements are met for reporting and analytics, including development

and maintenance of reports/dashboards that assist in identifying signals and trends in Medical Affairs data to

promote informed decision making.

3. Work with stakeholders to understand and document data assets, data flows, and reporting/analytical needs.

4. Identify areas where data can be used to improve business activities by defining business users' requirements for

additional data, metrics, reports, and KPIs.

5. Understand data flows, data collection process, and data repositories. Create and maintain data maps and systems

interrelationship diagrams for data domains and systems.

6. Work closely with the data engineers to create optimal physical data models of datasets.

7. Create and maintain metadata and data quality measures and monitoring.

8. Map and blend multiple datasets together into a coherent domain model that represents the business.

9. Define and govern data modeling and design standards, tools, best practices, and related development methodologies

for the organization.

10. Set or follow standards for document naming, security, and lifecycle & retention architecture.

11. Make recommendations for standardization and proper data usage of domain models.

12. Assess training needs, creates training material, and delivers technical training on reports/dashboards developed for

global MA teams. Partners with the business to deliver coordinated process and technical training.

13. Serves as a Subject Matter Expert (SME) within Medical Affairs for existing systems datamart and potential new

additions to the data lake/datamart on Synapse big data platform.

Skills/Knowledge Required:

1. Must be a team player and be willing to work in an environment where individual initiative and accountability to

the team are required

2. Strong analytical, problem-solving skills with highly customer-oriented application support required

3. Agile business intelligence and modern data modeling approach

4. Expertise in data modeling principles/methods including conceptual, logical & physical Data Models

5. Ability to clearly communicate complex technical ideas, regardless of the technical capacity of the audience

6. Strong interpersonal skills and ability to work as part of a team

7. Knowledge of the mathematical foundations is a plus. For example, statistical inference and forecasting such as time series analysis, multivariate analysis, cluster analysis, and optimization

8. Ability to quickly learn and adapt modeling methods from case studies or other proven approaches

9. Ability to explore datasets using visualization and querying tools (e.g. SQL)

10. Ability to utilize Business Intelligence tools (e.g. Tableau, Excel, etc…) to represent insights

11. Experience working with dimensionally modeled data

12. Experience with Big Data technology stack (e.g. Hadoop) on cloud environments (e.g. AWS)

13. Strong written and verbal communication skills and works well across teams

14. Familiar with IT processes for system implementation and maintenance

15. Practical knowledge of data governance, quality and stewardship processes