Need: Data Architect/Data Modeler @ Chicago, IL
VeeraRaju M
Hope you are doing great
Please send resumes to : veera@ai9solutions.com
Title: Data Architect/Data Modeler
Location: Chicago, Downtown
Duration: 1+yr
Rate: DOE
JD:
The Data Modeler will be part of a team of data modeler/architects supporting the data and analytics platform. The team is responsible for all logical and physical dimensional modeling using Erwin as well as modeling and support for the NoSQL databases. They will interact directly with product owners, business analysts, developers and DBA team. This person should possess excellent oral and written communication skills with the ability to quickly learn about multiple business subject areas.
Responsibilities:
• Translates and transforms business requirements into data models (Conceptual, Logical and Physical)
• Analyze source system data and profile data as needed.
• Design dimensional and NoSQL data models for the analytics platform.
• Maintain relational data model repository in Erwin as well as NoSQL data models.
• Design dimensional and relational data models using Erwin
• Provide insight, best practices and standards for NoSQL data modeling as well as assist in data modeling tool selection.
• Drive conversations with development and DBA teams to optimize the schema structure and ingestion processes influencing the write and read performance.
• Provide assistance to project teams on data modeling policies, procedure, processes and standards.
• Provide recommendations to enhance current DA standards as necessary or develop standards for new technology implementations.
• Assist with capturing and documenting system flow and other pertinent technical information about data database design and/or systems
• Enforce and follow established data governance and consistency in the data model and standardization of business definitions
• Knowledge of DBMS platforms (e.g. Redshift, SQL Server, NoSql, Cassandra) with experience in generating DDL as needed
Required Skills
• Extensive experience with CA Erwin and Model Manager
• Strong knowledge of principles, techniques, and best practices of enterprise data modeling and dimensional data modeling and big data modeling related to Data Warehousing and Business Intelligence
• Experience or knowledge of NoSQL Data Modeling
• Proficient with creating SQL to investigate data anomalies, patterns and profiling
• Experience with an Agile Tool, specifically JIRA and Confluence is a plus
• Knowledge of Agile terminology and practices such as User Stories, Backlog, Scrum, and Acceptance Criteria.
• Knowledge and experience in CRM best practices a plus
• Cloud AWS experience preferred.
Qualifications:
• 5+ years of experience with the CA Erwin Data Modeler
• 3+ years of experience in Relational and Dimensional data design and modeling in a large multi-platform data environment
• Advanced SQL coding skills preferred
• Experience with Redshift, NoSQL, Cassandra, and SQL Server is preferred
• Must have excellent written and verbal communication skills
• BS in Computer Science or related fiel
Thanks & Regards
VeeraRaju
ai9 Solutions LLC.,
Phone – 732-639-5080
Email Id: veera@ai9solutions.com
Note: Please ignore this email if you are not the right person