Data Modeler
Core
Design and maintain data architecture for People analytics and HR insights at a global scale, translating business needs into robust data models.
Role type
Senior Data Modeler
Builds
Data Warehouse/Lake environments and physical data models for People analytics
Domain
Biopharmaceuticals / People Analytics / Data Warehousing
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Data warehouse modeling, SQL, relational and non-relational databases, Kimball and Inmon methodologies, data modeling tools (SQL Database Modeler, IBM InfoSphere, erwin), data cleaning, metadata management, data security implementation
Preferred skills
Informatica IICS, Snowflake, Power BI, mentoring, agile/scrum
Technologies
SQL, Informatica IICS, Snowflake, Power BI, IBM InfoSphere, erwin Data Modeler
Responsibilities
Guide Data Engineers in building data models for Data Warehouse/Lake environments; Organize and optimize data models to improve performance and simplify KPI calculation; Analyze and translate business requirements into scalable data model solutions; Partner with business teams to gather requirements for database design; Collaborate with stakeholders to design database models fit for analysis; Implement data strategies and develop physical data models; Manage and optimize local and metadata models; Define and oversee data cleaning requirements; Assess data security needs and implement solutions; Apply coding best practices for system consistency and audit compliance; Handle historical data requirements with appropriate modeling approaches
Seniority
Senior, hands-on IC