What are the responsibilities and job description for the Cloud Data Modeler position at Career Soft Solutions Inc?
Must Have Skills:
⦁ Data modelling and cloud working experience
Nice to Have Skills:
⦁ SQL
Detailed Job Description:
We are seeking an experienced Senior Data Modeler (8 years) with strong expertise in enterprise data warehousing and cloud-based data platforms. The role involves designing and implementing scalable, high-performance data models to support analytics, reporting, and cloud modernization initiatives.
Key Responsibilities
⦁ Design and develop conceptual, logical, and physical data models for enterprise data warehouse and analytics platforms
⦁ Implement dimensional models (Star, Snowflake) and Data Vault models
⦁ Lead data modeling initiatives on cloud platforms (AWS, Azure, Google Cloud Platform)
⦁ Define source-to-target mappings and collaborate with ETL/ELT teams
⦁ Ensure data governance, lineage, and metadata standards
⦁ Optimize models for performance, scalability, and cost efficiency
⦁ Collaborate with business analysts, data engineers, DBAs, and governance teams
⦁ Support cloud migration and modernization programs
⦁ Drive data quality, validation, and governance frameworks
Required Skills & Experience
⦁ 8 years in data modeling, data warehousing, and analytics
⦁ Strong expertise in:
1. Dimensional modeling (Star & Snowflake)
2. Data Vault modeling
⦁ Experience with cloud platforms:
1. Snowflake (preferred)
2. AWS / Azure data services
⦁ Strong understanding of:
1. ETL/ELT processes
2. Data pipelines and transformations
⦁ Expertise in:
1. Advanced SQL
2. Database design & performance tuning
⦁ Experience with data governance, lineage, and metadata tools
⦁ Strong analytical and problem-solving skills
Preferred Skills
⦁ Experience with:
1. Cloud-native tools (AWS Glue, Azure Data Factory, Snowpipe)
2. Data cataloging / lineage tools
⦁ Understanding of modern architectures (Lakehouse, Data Mesh)
⦁ Exposure to Agile / Scrum
⦁ Domain experience: Retail, Healthcare, Banking
Soft Skills
⦁ Strong stakeholder management and communication
⦁ Ability to work in cross-functional and distributed teams
⦁ Experience in Agile environments
Minimum Years of Experience:
⦁ 8 years