Overview
On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2
Skills
Postgresql
AWS
Lambda
Job Details
Role: Data Modeler
Location: Plano, Texas (Need Only Locals) Day One onsite
Key Responsibilities
Data Migration & ETL
- Perform end-to-end data extraction from Salesforce using APIs or ETL tools.
- Transform, cleanse, and load data into PostgreSQL on AWS.
- Implement ETL workflows ensuring data completeness, accuracy, and quality.
- Develop automation scripts/jobs for recurring data loads and validations.
- Troubleshoot migration issues, validate migrated data, and resolve discrepancies.
Data Modeling
- Design and create logical, conceptual, and physical data models aligned with business needs.
- Create new PostgreSQL tables, schemas, relationships, and constraints.
- Optimize database structures for performance, scalability, and maintainability.
- Document data definitions, metadata, and data flow diagrams.
Database Development (PostgreSQL on AWS)
- Write complex SQL queries, stored procedures, functions, and triggers.
- Optimize SQL queries and database performance.
- Work with AWS services such as RDS, S3, Lambda, Glue, DMS (preferred).
- Ensure best practices for indexing, partitioning, and data governance.
Cross-Functional Collaboration
- Work with Salesforce teams, data engineering teams, and business analysts.
- Understand data requirements and translate them into data models.
Support testing, validation, and deployment in AWS environments
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.