What are the responsibilities and job description for the Sr Technical Lead Erwin Data Modeler - San Antonio, TX ONSITE (5 days onsite working) position at HPTech Inc.?
Job Details
Role: Sr Technical Lead Erwin Data Modeler
Location: San Antonio, TX ONSITE (5 days onsite working)
Duration: 12 Months Contract
Interview Process: 2 Rounds
About Cygnus Professionals, Inc.
Cygnus is a Princeton, NJ-headquartered global Business IT consulting and software Services firm with offices in the USA and Asia. Cygnus offers and enables innovation and helps our clients accelerate time to market & grow their business. Over 15 years, we have taken great pride in continuing our deep relationships with our clients.
For further information about CYGNUS, please visit our website
Mandatory required skills:
DBA/Erwin Data Modeler, Implement 3NF schema design,
Detailed Job Description:
- 6 Years of Work Experience in Data Modeling
- Design and create logical and physical data models: used Erwin to visually represent the entities, attributes, relationships, and constraints within a database system. Both logical models (focusing on business concepts) and physical models (considering the specific database platform) might be required.
- Implement 3NF schema design.
- Analyze existing data models and suggest improvements: evaluate existing data models for accuracy, efficiency, and adherence to data governance standards. suggest improvements to optimize the model's structure and functionality.
- Data Management:
- Develop and maintain data dictionaries: The data modeler will ensure the data dictionary is accurate and up-to-date, reflecting the current state of the data model.
- Develop and maintain data quality rules: defining rules to ensure data accuracy, consistency, and completeness within the database.
- Database Design and Implementation:
- Design and implement database objects: creating tables, views, stored procedures, and triggers within the database management system based on the data model specifications.
- Develop and maintain database standards and procedures: contribute to establishing data management standards and procedures within the organization to ensure consistent data practices.
- Communication and Collaboration:
- Work with business stakeholders to understand data requirements: maintain clear communication with business users to understand their information needs and translate them into the technical data model.
- Collaborate with IT teams to implement the data model: work with database administrators and developers to ensure the model is successfully implemented within the chosen database platform.
Cygnus Belief
We believe in our commitment to diversity & inclusion.
Equal Employment Opportunity StatementCygnus is an Equal Opportunity Employer. We ensure that no one should be discriminated against because of their differences, such as age, disability, ethnicity, gender, gender identity and expression, religion, or sexual orientation.
All our employment decisions are taken without looking into age, race, creed, color, religion, sex, nationality, disability status, sexual orientation, gender identity or expression, genetic information, marital status, citizenship status, or any other aspects of employment protected by federal, state, or local law.Applicants for employment in the US must have work authorization & Cygnus does not offer any sponsorship of a visa for employment authorization in the United States.
