Description:
will be responsible for designing and implementing data models that ensure data integrity, quality, and accessibility across the organization. This role involves collaborating with business and technical teams to understand data requirements and creating models that support analytics, reporting, and data governance.
Responsibility:
- Designing, implementing, and developing data models (conceptual, logical, and physical) that support business needs and align with data governance standards.
- Collaborate with data architects, engineers, and business analysts to gather and translate business requirements into efficient data structures.
- Ensure data models are optimized for performance, scalability, and maintainability.
- Monitor daily operations and data transfer between source and target.
- Support data and analytics use cases by data extraction, analysis, and data pipelines development.
- Implement data modeling best practices and enforce data quality and consistency standards.
- Conduct training and provide support to promote understanding of data structures and encourage data literacy within the organization.
- Document data models, data flow diagrams, and other metadata to ensure clarity and accessibility.
- Create and maintain a scheduled data transfer Jobs and fix discovered data issues.
- Create and maintain data architectures/models while also keeping it aligned with business requirements.
- Apply skills and techniques to debug the system, data pipelines, understanding what is necessary to scale up, addressing continuous integration, knowledge of data cleaning.
- Work with BI, Data Science, Platform team to resolve issues that arise during the build process.
Skills Required:
- Strong development skills in modern data integrations tool and technologies with excellent debugging and optimization skills.
- Ability to translate design into data processing code.
- Strong understanding of data modeling tools such as ER/Studio, Erwin, or similar software.
- Strong SQL skills and experience with relational databases (e.g., SQL Server, Oracle, PostgreSQL).
- Knowledge of data warehousing concepts and platforms (e.g., Snowflake, Redshift).
- Familiarity with non-relational databases (e.g., MongoDB, Cassandra) is a plus.
- Understanding of ETL processes and data integration techniques.
- Experience in Informatica tools like (IDQ, IMDM, IEDC, ..)
Qualifications Required:
- Bachelor’s computer science, engineering or other related field.
- 10+ years of experience in ETL tools, Data warehousing, Data Modeling, database design and SQL server