Senior Data Modeler

Parexel is looking for a Senior Data modeler to define and develop logical and physical data models that satisfy Parexel's financial and operational reporting, analytic and integration needs. The Principal data modeler will own the overall data models and define principles, designs, and models that drive information sharing across the enterprise.

Key Accountabilities:

• Working with business subject matter experts and IT groups to document data attributes and requirements.

• Understanding and translating business needs into data models which support long term solutions.

• Creating logical and physical data models to support new and existing projects.

• Documenting logical and physical mapping definitions, data lineage and ETL requirements.

• Identify opportunities for standardizing data dictionaries, integration and archiving, and elimination of unnecessary redundancy.

• Help define robust design methodology, development process methodology and best practices.

• Utilize understanding of industry information management trends to innovate and provide new project/product ideas within the investment lifecycle

• Working with the development team to create conceptual data models and data flows.

• Developing best practices for data coding to ensure consistency within the system.

• Reviewing modifications of existing systems for cross-compatibility.

• Implementing data strategies and developing physical data models.

• Updating and optimizing local and metadata models.

• Evaluating implemented data systems for variances, discrepancies, and efficiency.

• Troubleshooting and optimizing data systems.QualificationsRequired:

• A minimum of 5 years experience with data warehouse development, with at least 3 years experience creating logical and physical dimensional, relational and hierarchical data models.

• Experience modeling financial data.

• Experience modeling clinical data.

• Experience using ER/Studio, Oracle, Azure SQL, Azure Synapse, and Qlik Compose or other Data Warehouse Automation tools.

Desired:

• Knowledge of Microsoft Azure PaaS, IaaS and related data and integration services

• Experience using Azure Data Factory, Informatica PowerCenter, Qlik CDC

• Experience designing and implementing information models in a clinical research organization (CRO) or related industry.

• Knowledge of clinical industry data standards such as CDISC ODM, SDTM, ADaM and BRIDG