Are you looking for a stimulating and dynamic job Would you like to be part of a team that believes in your potential and part of a great company that will help you advance in your career This is the job for you! We are currently looking for an IT Architect (Data Modeling) for one of our clients.
What is in it for you:
Hourly salary of $80 to $93 based on experience.
6month contract.
Fulltime position: 37.50 hours per week.
Weekday schedule from 9 am to 5 pm
Hybrid work: 3 office days 2 days remote
Opportunity to work in a dynamic and professional environment.
Join a passionate and inclusive team of professionals.
Responsibilities:
Understand and translate business needs into data models supporting longterm solutions.
Closely interact with business partners stakeholders functional experts business analysts contractors and developers to understand the system requirements and architect and design the data model and database schema based on the requirements.
Work with the Application Development team to implement data strategies build data flows and develop conceptual data models.
Create logical and physical data models using standard methodologies to ensure high data quality and reduced redundancy.
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 standard methodologies for standard naming conventions and coding practices to ensure consistency of data models.
Communicate effectively with no ambiguity during project execution on data model
Understand and articulate interdependencies constraints of the data model to Data Engineers project teams and business teams
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.
Understanding and experience in OLAP reporting and analytics principles.
Own the data definitions for all data tables and maintain data lineage
Validate business data objects for accuracy and completeness.
Analyze datarelated system integration challenges and propose appropriate solutions.
Develop data models according to company standards.
Guide System Analysts Engineers Programmers and others on project limitations and capabilities performance requirements and interfaces.
What you will need to succeed:
Bachelor s degree in computer science information systems or related.
Solid experience with business intelligence and data warehousing development technologies RDBMS Hadoop and Analytics Environments.
Minimum 5 to 8 years of experience in IT with a minimum of 4 years in Data Model design.
Expertise with Big data technologies and Hortonworks/Cloudera HADOOP platform as well as BI and data warehousing development technologies.
Strong Data Analysis skills
Strong Data Modeling skills
Experience with Azure Solutions
Expertise with Power Designer/Erwin Data Modeling tool
Familiarity with Capital Markets data
Able to communicate clearly both verbally and in written form
Good work ethic results oriented and accuracy / attention to detail are critical