This is a W2 position open for USC candidates.
Direct Client
Banking
New York, NY
Data Modeler -
Hybrid: Tue/Weds
Contract through 12/31
WHILE APPLYING STATE THE YEARS OF EXPERIENCE 1-7
Top must-have hard skills:
1. very strong data modelling
2. ER Studio tool
3. architecture
4. cloud DB
5. Aws postgres
6. data bricks
7. Sql scripts
Top 5 soft skills:
great communicator
work with different teams and understand the data models built
Additional Notes:
-Knowledge of DBMS - specifically Oracle
-Strong communication to speak with multiple stakeholders without issue
-Key aspects of the role: data lake house, work with payments teams, etc. structure data
-Day-to-day Expectations: work within workstreams, naming standards outside of data dictionary
-Interview Plan/Process: panel and possibly 2nd
o Establish enterprise standards
o Design data models using data modeling tools to support business processes
o Manage the enterprise data model repository
o Provide data model documentation and artifacts generated from data – ERD, data dictionary, data definitions, etc.
o Compliant with Bank’s data modeling standards
o Apply industry standards and best practices where applicable
o Perform end-to-end data management from data analysis, conceptual/logical/physical modeling to database deployment
o Create structures that implement and enforce unified set of models
o Prepare presentations for business users and management
o Support enterprise data catalog setup and enrichment
Quals--
o 8+ years of hands-on data modeling experience with ER Studio.
o 8+ years of hands-on strong Data modeling (Conceptual, Logical, Physical, 3nF, Dimensional) at both enterprise and data product level.
o 8+ years of experience in establishing enterprise data standards.
o 8+ years of experience in designing enterprise data model framework.
o Work with business architects, Solution architects, and data stewards to capture business requirements in a Conceptual and Logical Data Model.
o General working knowledge of traditional DBMS platforms like Oracle and Cloud DBMS like Aurora, Dynamo DB, Redshift and Databricks.
o Analyze and translate business requirements into conceptual and fully detailed logical data models.
o Create logical data models based on existing applications and databases.
o Contribute to ongoing updates to data modeling standards and guidelines.
o Strong verbal, presentation, and written communication skills
o Evaluate physical data models to ensure they align with the corresponding logical data models.
o Understanding of principles and standard methodologies around Data Architecture.
o Ability to write SQL to query data (ideally ANSI SQL).
o Experience with data integration architecture, strategy, and processes
o Working experience in collaboration with product stakeholders and development/test/infrastructure support teams
o Strong verbal, presentation, and written communication skills
o Strong initiative, ability to self-manage, and work well in a team environment