Data Modeler - Architect Job

Experience

12+ Years

Job Description

1. 12+ years of experience in designing data modelling projects
2.. In-depth understanding of Datawarehousing and database concepts
3. Advanced skills in ER design, dimensional design with ErWin/ER-Studio: Develop the conceptual, logical and physical data modelStrong working experience in Snowflake,MS SQL Server,Databricks, Azure Data 4..Factory. Expertise in writing optimised SQLs
5. Good knowledge on entire application lifecycle and DevOps processes is required
6. Experience in Data analysis and mapping, creation and usage of metadata.
7. Creating and modifying database structures and having a strong understanding of both relational and non-relational database systems.
8. Define and apply data modelling and design standards, tools, best practices, and related development for the data projects.
9. Coordinate with project team for data model development. Collaborates with the Business analysts in defect root cause analysis. Works to resolving and Implementing fixes for data / data model related defects.
10. Proven analytical and problem-solving abilities. Communication - Excellent interpersonal and written communication skills

Required Technical Competencies

Solution Design:

• Manages solution design projects, ensures best practices are being followed.
• Able to develops solution designs for complex solutions.

Emerging Technologies:

• Manages emerging technology projects, ensures best practices are being followed.
• Develops and implements emerging technology strategies that support the organization's strategic objectives.

Architecture tools and frameworks:

• Familiarity with industry tools and frameworks and ability to analyse and use them based on customer requirements.
• Work with SMEs to explore new tools and frameworks for implementation.

Architecture Concepts and Principles:

• Provides deep subject matter expertise, advice for the program delivery.
• Contributes to the development of new techniques and plans within area of expertise.
• Establish Architectural principles & patterns.
• Conduct technical & design reviews.
• Use advanced tools to capture and analyse system / technical issues.

Technology/Product Knowledge:

• Implement code or configure/customize products, drive adoption of industry standards and practices, and contribute to development of reusable assets and innovative solutions.
• Work on complex modules independently.
• Analyse various frameworks/tools and present recommendations, contribute to development of training and certification material, and demonstrate thought leadership through whitepapers and webinars.

Application Design:

• Mastery of design principles and performance engineering concepts
• Lead design efforts, creating a design strategy, and establishing design principles and guidelines while maintaining the design standards and best practices.
• Identify and mitigate design risks, proactively anticipate issues, and recommend corrective steps.
• Innovate and bring in new design ideas, improve existing design processes, and tools.

Estimation and Resource Planning:

• Good Understanding of estimation and resource planning techniques, such as the WBS model.
• Identify the resources required to complete a task and use appropriate estimation models for low to medium complexity scenarios.