38 Techno Wise Jobs
Data Modeler - Erwin/SQL Server (8-10 yrs)
Techno Wise
posted 12hr ago
Key skills for the job
Key Responsibilities :
Data Modeling & Design :
- Design and develop conceptual, logical, and physical data models in line with the company's data strategy and business objectives.
- Collaborate with business stakeholders and IT teams to gather requirements and ensure models meet business needs.
- Create and maintain metadata and data dictionaries to ensure consistency across various data sets.
- Review and optimize data models to improve system performance, scalability, and quality.
Data Integration & Management :
- Assist in integrating and transforming data from multiple sources into usable formats.
- Work on data governance and standardization initiatives to ensure data consistency, integrity, and security.
- Collaborate with ETL developers to ensure proper data flow and transformation within the models.
Collaboration & Support :
- Work with other teams (e.g., data engineers, data analysts) to ensure alignment and proper implementation of data models across the organization.
- Provide guidance and support for data migration, quality assurance, and reporting efforts.
- Act as a liaison between business users and technical teams, translating business requirements into data specifications.
Performance Monitoring & Reporting :
- Monitor data model performance and proactively suggest optimizations to improve efficiency.
- Assist in the creation of dashboards and reports for business users by providing insights into data structures and relationships.
Skills & Qualifications :
Education :
- Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field.
- Master's degree preferred.
Experience :
- 5 years of experience in data modeling, database design, or a related role in an IT company.
- Hands-on experience with data modeling tools (e.g., Erwin, IBM Infosphere Data Architect, Microsoft SQL Server Management Studio, or similar tools).
- Extensive experience in Snowflake
- Strong experience with database management systems such as SQL Server, Oracle, MySQL, or PostgreSQL.
Technical Skills :
- Expertise in designing relational, dimensional, and NoSQL data models.
- Proficiency in SQL and understanding of database query optimization techniques.
- Familiarity with ETL processes and data warehousing concepts.
- Experience with data governance practices and tools.
Soft Skills :
- Strong analytical and problem-solving skills.
- Good communication and collaboration skills to work with technical and non-technical teams.
- Ability to work in a fast-paced environment, prioritize tasks, and manage multiple projects simultaneously.
- Detail-oriented with a focus on data quality and consistency.
Must Skills :
- Experience of cloud-based data platforms such as AWS, Google Cloud, or Azure. (Must)
Functional Areas: Other
Read full job description