Data Modeler (SCD Dimensional Modeling, Oracle and Data Warehousing)

Software Requirements:

• Proficiency in data modeling tools such as Erwin.
• Strong knowledge of SQL and database design principles.
• Experience with Oracle databases and cloud data platforms.
• Familiarity with data warehouse development and SCD dimensional modeling.
• Understanding of data architecture and metadata management standards.

Overall Responsibilities:

• Design and implement data models for large data warehouses.
• Translate business and technical requirements into conceptual and physical data models.
• Collaborate with business analysts and development teams to create data flows and document data catalogs, mappings, and transformations.
• Standardize data architecture and enforce metadata management practices.
• Engage in code and change management reviews to ensure compliance with data standards.
• Support data migration projects and ensure data integrity across systems.

Technical Skills:

Category-wise:

Data Modeling:

• Proficiency in data modeling tools such as Erwin.
• Experience in designing and implementing SCD dimensional models.

Database and SQL:

• Strong knowledge of SQL and database design principles.
• Hands-on experience with Oracle databases.

Data Warehouse Development:

• Familiarity with data warehouse development processes.
• Experience in data migration projects.

Data Architecture:

• Ability to standardize data architecture and enforce metadata management practices.
• Understanding of cloud data platforms and their integration with existing systems.

Experience:

• Minimum of 5+ years of experience in data modeling and data warehouse development.
• Proven experience in designing and implementing data models for large-scale data warehouses.
• Experience with data migration projects and ensuring data integrity across systems.
• Demonstrated experience in working with business analysts and development teams to translate requirements into data models.

Day-to-Day Activities:

• Design and implement data models based on business and technical requirements.
• Collaborate with business analysts and development teams to create data flows and document data catalogs, mappings, and transformations.
• Standardize data architecture and enforce metadata management practices.
• Engage in code and change management reviews to ensure compliance with data standards.
• Support data migration projects and ensure data integrity across systems.
• Stay updated with emerging technologies and industry trends in data modeling and data management.

Qualifications:

• Bachelor’s degree in Computer Science, Information Technology, or a related field.
• Relevant certifications in data modeling or database management are a plus.

Soft Skills:

• Excellent communication and interpersonal skills.
• Strong presentation skills and the ability to articulate complex data concepts to non-technical stakeholders.
• Strong problem-solving and analytical skills.
• Ability to work effectively in a fast-paced, dynamic environment.
• High attention to detail and a commitment to delivering high-quality work.
• Ability to prioritize tasks and manage time effectively.
• Collaborative and team-oriented mindset.

S​YNECHRON’S DIVERSITY & INCLUSION STATEMENT
 

Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.

All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.

Candidate Application Notice