| Local Only USC/GC Hybrid Role : Data Modeler with Relational Database and AWS Cloud experience. at Remote, Remote, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=2218247&uid= Role: Data Modeler with Relational Database and AWS Cloud experience. Location: 3-4 days on site - NYC (Local Candidates only) Duration: Long Term Visa: GC or USC only Strong Investment Banking experience is a MUST Job Summary: We are seeking an experienced Data Modeler with expertise in relational databases and AWS Cloud technologies to join our data management team. The ideal candidate will be responsible for designing and maintaining scalable data models to support business intelligence, data integration, and cloud-based data warehousing solutions. This role will involve collaboration with data architects, engineers, and business stakeholders to ensure data structures meet business and technical requirements. 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: Bachelors degree in computer science, Information Systems, or a related field (or equivalent experience) from a US University required 5+ 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. 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. Regards, Alok Singh | 1Point System LLC Technical Recruiter Email: [email protected] Fax: 803-832-7973 www.1pointsys.com 115 Stone Village Drive Suite C Fort Mill, SC 29708 LinkedIn : linkedin.com/in/alok-singh-8900bb210 An E-Verified company | An Equal Opportunity Employer -- Keywords: cprogramm sthree information technology green card South Carolina Local Only USC/GC Hybrid Role : Data Modeler with Relational Database and AWS Cloud experience. [email protected] http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=2218247&uid= |
| [email protected] View All |
| 01:17 AM 01-Mar-25 |