- Company Name
- Ascendion
- Job Title
- Data Modeler
- Job Description
-
Job Description:
Candidates need to have Power Designer/Erwin experience
Key Responsibilities:
Data Modeling: Design and implement enterprise-level data models, ensuring adherence to best practices in data modeling methodologies, including 3NF, dimensional modeling, and data vault techniques.
Data Architecture: Collaborate with data architects, business analysts, and developers to define and design data architecture solutions, including data warehouses, data marts, and operational data stores (ODS).
Database Design: Create and maintain relational and NoSQL database designs for a variety of platforms, such as SQL Server, Oracle, Netezza, Teradata, DB2, MongoDB, and Elasticsearch.
Tool Expertise: Utilize advanced data modeling tools like Power Designer and Erwin to develop, analyze, and optimize data models.
Collaboration: Work closely with business stakeholders to gather requirements and translate them into scalable data models that meet analytical and operational needs.
ETL Integration: Support ETL processes by ensuring data models align with extraction, transformation, and load (ETL) requirements.
Data Analysis: Conduct in-depth data analysis to ensure the accuracy, consistency, and integrity of data within the models.
Documentation: Maintain comprehensive documentation of data models, database designs, and data architecture processes.
Optimization: Continuously assess and improve data models to enhance performance, scalability, and maintainability.
Qualifications:
Experience:
hands-on experience in data modeling and database design.
Expertise in data modeling methodologies such as 3NF, dimensional, and data vault modeling.
Strong understanding of data architecture concepts, including data warehousing, data marts, ODS, ETL processes, and analytics/reporting.
Proven experience with relational databases (SQL Server, Oracle, Teradata, etc.) and NoSQL databases (MongoDB, Elasticsearch, etc.).
Technical Skills:
Proficiency in data modeling tools such as Power Designer, Erwin, or equivalent.
Strong SQL skills for data analysis and validation.
Familiarity with modern data platforms and cloud environments (AWS, Azure, or GCP) is a plus.
Soft Skills:
Excellent communication and presentation skills, with the ability to explain technical concepts to non-technical audiences.
Strong problem-solving skills and attention to detail.
Ability to work both independently and collaboratively in a fast-paced environment.
