Data Modeler

ALLTECH CONSULTING SVC INC; Jersey City (NJ); On-site; USD 100,000 - 140,000; Full time

Job summary

A leading consulting firm is seeking a Data Modeler with architectural responsibilities to design and implement database blueprints. The ideal candidate will have extensive experience in data management, SQL proficiency, and a strong understanding of data warehousing concepts. This role involves collaborating with various stakeholders and ensuring data quality and integrity.

Qualifications

• 7-15 years of experience in information technology and enterprise data management.
• 5-10 years of data architecture experience.
• Thorough knowledge of data warehousing concepts.

Responsibilities

• Review Business Requirements Documents and translate them into data models.
• Profile data in source systems using SQL.
• Develop mapping documents demonstrating data lineage.

Skills

Data Analysis

SQL

Data Profiling

Communication

Customer Relationship Management

Education

Bachelor’s degree in Computer Science or Information Systems

Data management and data architecture related certifications (i.e. TOGAF)

Tools

Erwin Data Modeler

Snowflake

Microsoft Office

Job description

Job Description:

Position Summary:
The Data Modeler with Architectural responsibilities will consult with information technology, data analytics, business/ product creation and development staff to design and implement the blueprint of a database to store information for a specific system that will support the work of the enterprise. The DA will develop a detailed knowledge of the underlying data as well as business events within the enterprise and become the subject matter expert (SME) on content, current and potential future uses of data, and the quality and interrelationship between core elements of the data repository and data products.
The DA should be able to understand how the information will be captured, retained and exploited.

Responsibilities Include:
• Reviewing Business Requirements Documents (BRDs) and/or User Stories (Agile methodology), translating them into viable logical and physical dimensional models in Snowflake
• Profiling the data in the source system(s) by writing SQL statements
• Adopting and conforming to established data modeling guidelines, standards and conventions
• Developing mapping documents that demonstrate data lineage
• Conducting walkthroughs of the data models with different stakeholders

Required Skills:
• 7-15 years of experience with information technology programs and services, with demonstrated expertise in enterprise data management and related technologies
• 5-10 years of data architecture experience
• Thorough knowledge of Erwin Data Modeler
• Thorough knowledge of data warehousing concepts and the ability to create a dimensional design
• Knowledge of Agile development methodology and concepts
• Experience working as a member of a distributed data architecture team
• Hands-on SQL experience
• Good understanding of the cloud technology and some of the tools used in that space
• Prior Experience with Snowflake

• Effective communication and customer relationship management skills

• Effective data analysis and profiling skills
• Thorough knowledge of Microsoft Office suite of products

• Prior experience in the financial services industry

Desired Skills:

• Good understanding of the concepts in the financial industry, especially clearing and settlement
• Experience with any data profiling/data discovery/data quality tool

Education/Certification:
• Bachelor’s degree in an appropriate area of specialization (Computer Science or Information Systems)
• Data management and data architecture related certifications (i.e. TOGAF) is a plus