Data Modeler - New York, United States - Siri InfoSolutions Inc

Description

Job Description

Data Modeler

100% Remote

6+ months

The Data Modeler is primarily responsible for the design, implementation, and maintenance of data models to support the needs of data warehouses and data marts. The position is responsible for recommending and adopting best practices to ensure high data quality standards, repeatability and scalability of data models are designed, and maintained and data redundancy is reduced.

General tasks and responsibilities will include:

• Understand and translate business needs into data models to satisfy enterprise analytics & reporting needs
• Work with the EIM team to design and implement data models, build data flows and develop conceptual, logical and physical data models.
• Development of the conceptual, logical, and physical data models, the implementation of RDBMS, operational data store (ODS), data marts, and data lake. Optimize and update logical and physical data models to support new and existing projects.
• Maintain conceptual, logical and physical data models along with corresponding metadata.
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models.
• Recommend opportunities for reuse of data models in new environments.
• Perform reverse engineering of physical data models from databases and SQL scripts.
• Evaluate data models and physical databases for variances and discrepancies.
• Validate business data objects for accuracy and completeness.
• Analyze data-related system integration challenges and propose appropriate solutions.
• Define and govern data modeling and design standards, tools, best practices, and related development for enterprise data models.

Education Level

• A Baccalaureate Degree from an accredited college or university with a major in Computer Science, Systems Engineering, applied Mathematics, Business Administration, Economics/Statistics, Telecommunications, Data Communications, or a related field of study
• Five (5) years of progressive, responsible experience in the field of data processing, computer systems and applications.