Data Architect Nashville 130K in Nashville at Vaco

Date Posted: 7/1/2019

Job Snapshot

Job Description

We are looking for a Data Architect- This is a full time Perm role No Sponsorship opportunities or 3rd parties please.
  • Capture/analyze business requirements, formulate data warehouse/business intelligence solutions and alternatives to support the BI strategy
  • Builds the long-term strategic roadmap for IT DB systems architecture
  • Seamlessly integrates business and service strategy into enterprise architecture roadmap
  • Partners with business and technology subject-matter experts to elicit and translate business requirements into technological solutions
  • Lead architecture and engineer teams in delivery, development, and support of projects. Partners with other solution architects to provide a consensus based scalable and adaptable architectural solution
  • Develop and maintains policies, standards, and guidelines to ensure that a consistent framework is applied across the company
  • Researches leading edge capabilities to determine the best solution fit for the overall environment
  • Sets technology architectural direction, and delivers technology architectural assessments recommending (replace, retire, maintain) strategies
  • Design and develop Data Warehouse Dimensional, Tabular, and Relational Models, and multidimensional OLAP cubes
  • Review and provide architectural guidance for all analytics solutions
  • Perform extensive design, development, testing, and performance tuning of ETL processes within SSIS to support the collection of data from disparate systems for the purpose of storing in a Data Warehouse
  • Writes stored procedures and SQL code to implement pre-defined business rules and metrics along with ensuring data quality in Data Warehouse processes
  • Troubleshoot and correct issues with existing BI solutions.

  • 8+ years minimum of demonstrable experience with the Oracle, including SQL, PL/SQL Packages, Stored Procs, Jobs, etc
  • Bachelor's degree in Computer Science, Management Information Systems or related field or equivalent
  • 4+ years' experience in an architect role architecting, designing, implementing, managing and supporting OLTP, OLAP or Warehouse Database Management Systems
  • Experience as a business leader and managing teams to business deliverables
  • Proven ability to work effectively in a fast-paced environment as part of a high-performing team
  • Strong analytical, problem-solving, time management and organizational skills
  • Able to multi-task and follow through on assignments to completion
  • Ability to prioritize work with tight schedules and target dates