Data Modeler

CompuGain • Full-time • Remote (Virginia, United States, US) • 3m ago

Key Job Functions

Confer with application development staff or project management staff regarding project planning, resource allocation, task definitions and schedules for substantial projects involving database(s).

Plan and design database changes necessary for data conversion, tool configuration, data refresh or migration or other initiatives related to large application development project.

Troubleshoot or confer with others troubleshooting errors or production problems involving databases to determine causes and proposed solutions.

Document the application data model in enterprise modeling tools and record use of databases with objectives of data integrity, data security, efficient operation, audit requirements, and the like.

Document the application dataset in accordance with enterprise data governance standards

Communicate to others in development or database administration roles.

Required Knowledge And Skills

Relational and dimensional data modeling skills.

Database design and implementation

Performance tuning techniques

Years of experience: 5min years of experience

Desired Knowledge and skills

Experience using data modeling tools like ER Studio or ERWin

Experience working with the AWS Glue Meta store

Experience with S3 and file storage designs such as Parquet, Avro, CSV, etc.

Experience working with JSON file formats