Sr. Data Modeler/Sr Data Engineer - 100% Remote

Overview

Remote
Depends on Experience
Contract - W2
Contract - 6 Month(s)

Skills

Data Modeler
Data Engineer
SQL
Snowflake
Cosmos DB
Erwin
ER/Studio.
Banking
Financial

Job Details

Title: Sr. Data Modeler/Sr Data Engineer

Team: Architecture and Enablement Team

Location: Remote

Contract Term 6 Months

Job Description:

The Sr Data Modeler is pivotal in ensuring the consistency, accuracy, and reliability of data systems. This role is responsible for designing, implementing, and managing data models for the organization. The Sr Data Modeler will partner with business analysts, engineers, architects, and data governance to ensure our data models meet the needs of our business and align with governance requirements.

Skill Matrix:

Skills

No. of Years of Experience

Detailed Write Up

Total No. of years of experience

No. of years of Experience as a Senior Data Modeler/Sr. Data Engineer

Must have SQL

Must have Snowflake

Must have Cosmos DB

Must be an Expert in data modelling and metadata management tools such as Erwin or ER/Studio.

Prefer Candidates with Banking/Financial/Lending Experience.

Minimum of 5 years of experience with physical/logical data modelling and database design for both relational and non-relational databases required.

Experience modelling for transaction processing and analytics preferred.

Experience with cloud data platforms such as Azure, AWS, or Google Cloud Platform preferred

Experience with Agile or other project management methodologies preferred.

Strong analytical and problem-solving skills with the ability to analyze complex business requirements and translate them into effective data models required.

Excellent organizational skills with the ability to document and present data models effectively required.

Knowledge of the Banking Industry Architecture Network (BIAN) information architecture preferred.

Responsibilities:

  • Develop, maintain, and optimize conceptual, logical, and physical data models in support of initiatives and new data offerings.
  • Create and document logical and physical data models including data dictionaries, metadata, and entity-relationship diagrams. Modeling scope includes OLTP and OLAP
  • Drive internal customer needs into meaningful effective data models in collaboration with Data Architects, Developers, and Analysts.
  • Enforce data modeling standards, guidelines, and best practices. Partner with Data Governance when new standards and guidelines are to be developed.
  • Ensure data security and compliance with relevant regulations and standards.
  • Prepare documentation for data models and definitions.
  • Communicate complex data and data modeling concepts to non-technical stakeholders effectively.
  • Support the design and implementation of database schemas/structures, and database performance tuning/optimization.
  • Perform additional duties as assigned.

Additional Notes:

  • Who will the resource interact with, what business groups, or departments? Data and Analytics department.
  • What is the most important quality you are looking for in a candidate? Expertise in Relational, Dimensional, and Document Data Modeling
  • Are there any specific experiences or projects that would be particularly valuable? Lending/Financial
  • What level of support will they have? How independent will they need to be? They will be working with other Data Modelers and Data Architects but, we expect them to take ownership of the assigned task.
  • Any specific technology/software expertise: SQL, Snowflake, Cosmos DB, and ERWIN

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.

About American IT Systems