Senior Data Modeler

Parexel International; Remote; CAD 80,000 - 100,000; Full time

Job summary

A leading Clinical Research Organization is seeking a Senior Data Modeler to develop logical and physical data models to meet their financial and operational needs. The ideal candidate will have over 5 years of data warehouse experience, with skills in data modeling and problem-solving. The role involves collaborating with business experts and translating needs into effective data solutions. They offer a collaborative work environment and professional development opportunities.

Benefits

Professional advancement opportunities

Work-life balance

Flexible working hours

Qualifications

• 5+ years of experience with data warehouse development.
• At least 1 year creating logical and physical data models.
• Experience modeling financial data and/or clinical data strongly preferred.

Responsibilities

• Document data attributes and requirements with business experts and IT.
• Translate business needs into data models.
• Create logical and physical data models for projects.
• Document mapping definitions, data lineage and ETL requirements.
• Identify opportunities for standardizing data dictionaries and eliminating redundancy.

Skills

Data modeling

Problem-solving

Analytical skills

Communication skills

Education

Bachelor's degree or equivalent experience

Tools

ER/Studio

Oracle

Azure SQL

Azure Synapse

Qlik Compose

Azure Data Factory

DataBricks

PowerBI

PowerApp

Job description

Job Title

Senior Data Modeler

Job Introduction

At Parexel, we are a leading Clinical Research Organization company specializing in delivering life-changing medicines to patients. We are seeking 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.

Who we are looking for

Curious individuals with previous experience working with data to contribute to the overall data models and define principles, designs, and models that drive information sharing across the enterprise. Those possess excellent problem-solving and analytical skills while demonstrating impeccable communication skills.

What you’ll do

• Partner with business subject matter experts and IT groups to document data attributes and requirements.
• Comprehend and translate business needs into data models which support long term solutions.
• Create logical and physical data models to support new and existing projects.
• Document 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.

Additional details:

5+ years of experience with data warehouse development, with at least 1 year creating logical and physical dimensional, relational, and hierarchical data models. Experience modeling financial data and/or clinical data strongly preferred. Bachelors degree or equivalent experience required.

Technology

ER/Studio, Oracle, Azure SQL, Azure Synapse, and Qlik Compose or other Data Warehouse Automation tools, Microsoft Azure PaaS (or similar cloud platforms), IaaS and related data and integration services, Azure Data Factory, DataBricks, PowerBI, and PowerApp.

Why join us

• Opportunity to work on innovative projects at the forefront of the industry.
• Collaborative and inclusive work environment that values your expertise.
• Professional advancement and development opportunities.
• Work life balance and flexible working hours.

About Parexel International

At Parexel we embrace flexibility and understand that in today’s fast-paced world, employees need to balance their careers with their personal lives. Come join us where learning is constant, you’re exposed to a world of experiences and open doors. Each of us, no matter what we do at Parexel, contributes to the development of a therapy that ultimately will benefit a patient. We take our work personally, we do it with empathy, and we're committed to making a difference.

If this job does not sound like the next step in your career, but perhaps you know of someone who would be a perfect fit, send them the link to apply!

#LI-REMOTE