Data Modeler
Responsibilities:
1. Analyze, Design and Implement Data Models:
• Analyze legacy and recent data usage across applications.
• Develop conceptual, logical, and physical data models.
• Implement relational, dimensional databases.
• Create data models optimized across different data domains.
• Optimize models for data query performance using best practices.
2. Collaboration:
Work with business analysts, data architects, data administrators and database/BI developers.
• Translate enterprise requirements into effective data models.
3. Standards and Best Practices:
• Define, review and document data modeling and design standards.
4. Hands-On Expertise: Perform hands-on modeling, design, configuration, development, and performance tuning.
• Work proactively to address project requirements.
Qualifications:
Education: Bachelor’s degree in computer engineering, computer science, information systems, or a related field.
Experience:
• 8+ years in data analytics, data modeling, or data architecture.
• Proficiency in data modeling for transactional, operational reporting, and analytical solutions (EDW, Data Lake).
• Experienced with Dimensional Modeling and Data Warehouse Modeling.
• Experience using data modeling tools (e.g., IDERA Data Architect, Erwin).
• Knowledge of SQL and its use in data access and analysis.
• Experience in remodeling and/or re-platforming of legacy application databases.
• Knowledge of cloud-based databases (e.g., Azure/Fabric).
• Exposure to data architecture implementation on Azure/Fabric preferred.
Skills:
• Excellent communication, problem-solving, organizational, and analytical skills.
• Ability to work independently and collaboratively.
Responsibilities:
1. Analyze, Design and Implement Data Models:
• Analyze legacy and recent data usage across applications.
• Develop conceptual, logical, and physical data models.
• Implement relational, dimensional databases.
• Create data models optimized across different data domains.
• Optimize models for data query performance using best practices.
2. Collaboration:
Work with business analysts, data architects, data administrators and database/BI developers.
• Translate enterprise requirements into effective data models.
3. Standards and Best Practices:
• Define, review and document data modeling and design standards.
4. Hands-On Expertise: Perform hands-on modeling, design, configuration, development, and performance tuning.
• Work proactively to address project requirements.
Qualifications:
Education: Bachelor’s degree in computer engineering, computer science, information systems, or a related field.
Experience:
• 8+ years in data analytics, data modeling, or data architecture.
• Proficiency in data modeling for transactional, operational reporting, and analytical solutions (EDW, Data Lake).
• Experienced with Dimensional Modeling and Data Warehouse Modeling.
• Experience using data modeling tools (e.g., IDERA Data Architect, Erwin).
• Knowledge of SQL and its use in data access and analysis.
• Experience in remodeling and/or re-platforming of legacy application databases.
• Knowledge of cloud-based databases (e.g., Azure/Fabric).
• Exposure to data architecture implementation on Azure/Fabric preferred.
Skills:
• Excellent communication, problem-solving, organizational, and analytical skills.
• Ability to work independently and collaboratively.
Department: Preferred Vendors
This is a contract position