Data Architect - REMOTE

Overview

Remote
Up to $56
Full Time

Skills

Data architecture
SQL server
data architect
data model
modeling
analysis
data warehouse
warehousing
data mart
data set
database design
snowflake
star
schema
SSIS
SQL

Job Details

Company and Role:

Dedicated Tech Services, Inc. (DTS) is an award-winning IT consulting firm based in Columbus, OH. We now have an opening for a Data Architect.

 

Highlights and Benefits:

  • Remote (only work on site in Columbus, OH on the first day of the contract)
  • Potential long-term, multi-year contract!
  • W2 hourly pay rate up to $56/hr. or salaried equivalent
  • Friendly client culture with strong focus on supporting disabled citizens
  • Direct W2 hourly or salaried applicants only (no corp-to-corp subcontractors, third parties, or agencies)
  • Paid time off and holidays for salaried employees
  • 401K, billable bonus, and health, life, vision, dental and short-term disability insurance options for all
  • DTS is a proud Women Business Enterprise (WBE) and Woman Owned Small Business (WOSB)!
  • Check out our benefits and company information at !

 

Job Description:

We are hiring an experienced Data Architect to work for us as our direct, W2 salaried or hourly employee to work for our client in a potential long-term, multi-year contract. You will:

  • Work remote, but work on site in Columbus, OH only on day one of the engagement
  • Architect the analytical data systems including data warehouses, data lakes, and data marts.
  • Define system and application architecture
  • Provide vision, problem anticipation, and problem-solving toe the client.
  • Consult with the client to define needs or issues, conduct research, perform studies and surveys to obtain data, and analyze problems to advise on or recommend solutions.
  • Perform a variety of tasks with minimal direction
  • Determine data structural requirements by analyzing client operations, applications, programming, reporting, analytics and informatics; reviewing objectives with clients; and evaluating systems.
  • Develop reliable and scalable database solutions through designing and implementing proposed system
  • Define database physical structure, functional capabilities, security, back-up, and recovery specifications.
  • Produce data flow diagrams and flowcharts; applying optimum access techniques; coordinating installation actions; and documents actions.
  • Participate in the identification, prioritization, and development of technical initiatives and strategies.
    Work with database analysts to develop methodologies, report views, queries, analytical cubes, and table replications
  • Perform systems analysis on database, and resolves performance, capacity, and replication issues as necessary.
  • Ensure that all data is in the proper format.
  • Develop and maintain database standards and naming conventions.
  • Keep up to date on emerging database architectures, technologies, and methodologies, and attends training classes as necessary.

Required Skills and Experience:

·         8 plus years of database experience

·         4 plus years of database modeling and architecture experience

·         3 years of experience working with MS SQL server

·         4 years of experience designing data models and architecture to support high performance, high availability data analytic

function for relational (structured), unstructured, and spatial data sets.

·         4-year college degree in computer science or related field with advanced study preferred

·         Possess extensive knowledge of one or more database systems

·         Capable of hands-on work in all phases of database design and management

·         Understand and know best practices regarding application of different analytical data solutions such as

data warehouse, data lakes, or data marts from the ground up.

Required

8

Years

 

Those authorized to work in the US are encouraged to apply. We are unable to sponsor at this time.

 

Dedicated Tech Services, Inc. is an Equal Opportunity Employer