Hybrid 2 Days Onsite.

Location: Newark, NJ, USA

Your Impact :

1. Requirements Assessment: Collaborating with business stakeholders and data users to comprehend their data needs, operational procedures, and reporting prerequisites. This entails collecting requirements, conducting interviews, and evaluating existing systems.

2. Data Modeling: Crafting logical and physical data models that delineate the structure, connections, and limitations of the organization's data. This encompasses designing entity-relationship diagrams, data flow diagrams, and data dictionaries utilizing recognized modeling techniques.

3. Database Design: Converting the logical data model into a tangible database design optimized for efficiency, scalability, and data integrity. This involves defining table configurations, indexes, and data formats while adhering to database management system (DBMS) constraints.

4. Data Integration: Cooperating with data integration teams to ensure smooth integration of data from diverse sources into the organization's databases. This encompasses mapping data elements and transforming data to align with the data model.

5. Collaboration and Communication: Engaging closely with interdisciplinary teams, including database administrators, developers, and data analysts, to harmonize data model designs with system requisites. Effective communication and collaboration are pivotal to ensuring alignment between data model implementation and business goals.

6. Documentation and Standards: Recording data models, data definitions, and data standards to furnish lucid guidelines for data management. This documentation acts as a resource for developers, data analysts, and other stakeholders.

7. Data Governance: Collaborating with data governance teams to institute and enforce data management policies, standards, and best practices. This encompasses ensuring adherence to data privacy regulations and advocating for data stewardship.

Required Skills:

• Over 7 years of experience in Data Modeling and Database Designing in Relational and Non-Relational Databases, with a minimum of 5 years in the Financial Industries concentrating on Fixed Income Products.

Bachelor's degree in Computer Science, Information Systems, or a related field.

Mastery in SQL, data querying, and techniques for optimizing performance.

Proficiency in employing Data Modeling tools such as Erwin, ER Studio, and DBT.

Extensive experience in constructing Dimensional as well as highly normalized data models for OLTP.

Familiarity with cloud infrastructure technologies like containers, Kubernetes, and serverless computing.

Previous work with Data Governance tools like Collibra and Informatica.

Experience in establishing catalogues, business terms, technical metadata, and data lineage.

Exceptional problem-solving and analytical prowess, with the ability to translate business requirements into technical solutions.

Strong familiarity with data structures, data modeling, data lineage, and data catalogues.

Desired Skills:

Highly desirable experience with Snowflake.

Certifications in cloud platforms or data management (e.g., AWS Certified Solutions Architect, etc.) are highly desirable.