Blog

This is Priyanshu from Shef Solutions. Hope you are doing Well; I have a job position for you.  

Job Title: Data Modeler

Location: NYC, NY (Hybrid)

Contract

Job Description

LinkedIn With Photo

Heavy Financial experience

 Data Modeler with Relational Database and AWS Cloud experience.

 Key Responsibilities:

• Design and develop conceptual, logical, and physical data models for relational databases and cloud data warehouses on AWS.
• Collaborate with business and technical teams to gather data requirements and translate them into effective data models.
• Optimize database structures to ensure performance, scalability, and reliability of data systems.
• Work with AWS services such as Redshift, S3, Glue, and RDS to design and implement cloud-based data solutions.
• Maintain and document data dictionaries, data lineage, and metadata for all data models.
• Ensure data model designs align with data governance, security, and compliance standards.
• Support ETL processes and data pipelines by providing guidance on data structures and relationships.
• Troubleshoot and resolve data model-related issues, ensuring data consistency and integrity.

 Qualifications:

• Bachelor’s degree in Computer Science, Information Systems, or a related field (or equivalent experience). US University required 
• 10+ years of experience in data modeling for relational databases such as SQL Server, Oracle, or PostgreSQL.
• Experience with AWS Cloud services like Redshift, S3, Glue, and RDS.
• Financial experience – heavy
• Strong knowledge of data warehousing concepts, Star/Snowflake schema, and data normalization/denormalization.
• Proficiency in ER modeling tools (e.g., ER/Studio, Erwin, or similar).
• Hands-on experience with ETL processes and data integration.
• Strong SQL skills for querying and analyzing relational databases.
• Familiarity with data governance and security best practices.
• Excellent communication and collaboration skills.

 Preferred Qualifications:

• Experience with NoSQL databases and big data technologies (e.g., DynamoDB, Athena, EMR).
• AWS Certification (e.g., AWS Certified Data Analytics Specialty, AWS Certified Solutions Architect).
• Familiarity with Python or other scripting languages for data processing.
• Experience in metadata management and data cataloging tools like AWS Glue Data Catalog.

Thanks and Regards,

We respect your Online Privacy. This is not an unsolicited mail, If you are not interested in receiving our e-mails then please reply with a “REMOVE” in the subject and mention all the e-mail addresses to be removed with any e-mail addresses, which might be diverting the e-mail to you.