Data Modeller with Pharma / Life science Exp is a must
Infodyne Solutions
Dice Job Match Score™
🔢 Crunching numbers...
Job Details
Skills
- Data Modeller
- Pharma
- Life science
- DataModelling
- Conceptual
- Logical
- PhysicalData Modelling.
- RelationalDataModelling
- ER Modelling
- DimensionalDataModelling
- Star
- Snowflake schemas
- Database & SQL
- PostgreSQL
- Oracle
- MySQL
- ETL
- ELT
- AWS
- Azure
- GCP
- Databricks
- Redshift
Summary
Data Modeller with Pharma / Life science Exp is a must
Location: hybrid at SFO, California
Experience level: 10 + years
Duration: 12 months Extension
Rate: $60/Hr
We are looking for an experienced Data Modeller to design, develop, and maintain enterprise data models that support business intelligence, analytics, reporting, and operational applications. The role involves translating business requirements into conceptual, logical, and physical data models while ensuring data quality, consistency, scalability, and governance.
The Data Modeller will work closely with Business Analysts, Data Engineers, Solution Architects, Database Administrators, and business stakeholders to create robust and scalable data architectures.
Key Responsibilities:
Data Modelling
Strong understanding of Conceptual, Logical, and Physical Data Modelling.
Strong knowledge of Relational Data Modelling and ER Modelling.
Experience with Dimensional Data Modelling.
Good understanding of normalization and denormalization techniques.
Experience designing Star and Snowflake schemas.
Understanding of slowly changing dimensions (SCD), fact tables, dimension tables, and surrogate keys.
Database & SQL
Strong SQL skills.
Good knowledge of relational databases such as:
PostgreSQL
Oracle
SQL Server
MySQL
Snowflake
Understanding of database performance, indexing, partitioning, and query optimization.
Knowledge of database constraints and referential integrity.
Data Warehousing & Cloud
Experience with data warehouse and data lake concepts.
Understanding of ETL/ELT processes and data integration.
Experience with one or more cloud data platforms such as:
AWS
Microsoft Azure
Google Cloud Platform
Exposure to platforms such as Snowflake, Databricks, Azure Synapse, BigQuery, or Amazon Redshift is desirable.
Data Modelling Tools
Experience with one or more of the following:
Erwin Data Modeler
ER/Studio
SAP Power Designer
Oracle SQL Developer Data Modeler
Sparx Enterprise Architect
Lucid chart
Microsoft Visio
Education & Experience
Bachelor's or master's degree in computer science, Information Technology, Data Management, or a related field.
5 10 years of experience in data modelling, database design, data warehousing, or related roles.
Experience working on enterprise data platforms and large-scale data projects.
- Dice Id: 91092600
- Position Id: DMT9
- Posted 1 day ago
Company Info
About Infodyne Solutions
InfoDyne has ventured into niche market segments including high competition areas, proving its capability with consistency. To that end, we offer high quality IT services to our clients - a true value for money. Our solution gives us the ability to work with our clients efficiently.
Infodyne Solutions delivers top-level talent with the industry acumen and certifications to produce immediate and measurable results. Our analysts and engineers have deep, real-world experience across disciplines, making them adept at winning trust and fostering a rapport among your internal staff. As a result, our Business Analytics Solutions bridge gaps between IT professionals and business stakeholders.
We help you to identify the most appropriate technologies for your needs. We have extensive hands-on experience with Cognos, Tableau, Spotfire and other Business Analytics tools.
Never miss an opportunity! Create an alert based on the job you applied for.Similar Jobs
It looks like there aren't any Similar Jobs for this job yet.
Search all similar jobs