This site uses cookies. To find out more, see our Cookies Policy

Database Cloud Consultant (RT3) (DM1) in Columbus, OH at Fast Switch

Date Posted: 3/10/2019

Job Snapshot

Job Description

Job ID: 50358

Database Cloud Consultant. We have an immediate contract need in Columbus, Ohio for a qualified Database Cloud Consultant who will work with different teams in the organization to map and integrate disparate data from a variety of source systems. The position will support Enterprise Data Analytics Platform development from and to a variety of database systems.

Responsibilities:

  • Facilitate data requirements conversation with business and technical stakeholders resolving conflicts to drive decisions and consensus
  • Create, document, and maintain logical and physical database models that are compliant with enterprise standards
  • Assist in establishing, maintaining, and enforcing data model design principles, techniques, and standards
  • Establish and maintain comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships as well as the definition of business rules governing the integrity, archiving, and audit requirements of the data
  • Analyze existing systems using manual or automated data analysis/profiling to reverse engineer data requirements
  • Determine suitable data modeling approach for each project based on business requirements for data capture and access
  • Ensure the proposed data models follow data architecture guidelines and best practices
  • Assist developers with complex query development and performance optimization
  • Performs additional duties as required

Qualifications:

  • Minimum of 10 years’ experience in data modeling in transactional and operational reporting/analytical (EDW/Data Lake/NoSQL) solutions
  • Data Modeling, Data Warehousing, Dimensional Modeling, Data Modeling for Big Data and Metadata Management
  • Data Lake and Big Data modeling experience
  • Understanding of enterprise and reporting modeling concepts, including dimensional modeling, snowflakes, slowly changing dimensions, schema on read
  • Experience with Cloud based Storage and data warehouses is a must (AWS S3, RedShift, Dynamo DB, Azure DataLake, Azure SQL)
  • Experience with Exasol is preferred but not mandatory

To view all our open positions, please go to: http://www.jobs.net/jobs/fastswitch/en-us/all-jobs/

IND-FS

gdr4900