Job Details
Job Id:
Data Architect
Job Type:
Brentwood TN 
A client in the Nashville, Tennessee area is seeking a Data Architect for a permanent position.

This individual will report to the Director of Data Engineering and will be responsible for data architecture that aids the organization in achieving its strategic business objectives. The Data Architect creates and implements database design that improves data conformation within the Data Warehouse and presents assets to other applications as necessary. This position will assist in coordinating the efforts of other database and application developers within the Data Warehouse team and enterprise in general. Hands on development within the Data Warehouse is also an expectation of the position.

• Capture/analyze business requirements, formulate data warehouse/business intelligence solutions and alternatives to support the clients BI strategy
• Build the long-term strategic roadmap for IT DB systems architecture
• Integrate business and service strategy into enterprise architecture roadmap
• Partner 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; partner with other solution architects to provide a consensus based scalable and adaptable architectural solution
• Develop and maintain policies, standards, and guidelines to ensure that a consistent framework is applied across the company
• Research leading edge capabilities to determine the best solution fit for the overall environment
• Set technology architectural direction, and deliver 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
• Write 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

Required skills:
• 8+ years of demonstrable experience with the Oracle, including SQL, PL/SQL Packages, Stored Procs, Jobs, etc
• 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
• Ability to multi-task and follow through on assignments to completion
• Ability to prioritize work with tight schedules and target dates

A Bachelor's degree is preferred

Other Requirements:
- Criminal background check
- Drug screening

Alltech, Inc. is a leading provider of IT staffing services in Nashville and the surrounding areas. We do contract (Salaried, W-2, 1099 or Corp-to-Corp), contract-to-hire and direct placements within the Information Technology field. Alltech, Inc. offers a full line of company-paid benefits to our salaried and W-2 employees. Our 1099 subcontractors have a full line of benefits available to them through our partnership with Benefit Consultants, Inc.

If you are considering relocation, the Nashville area is nationally respected as a great place to live, work and play. Nashville is proud to be the home of the Tennessee Titans, Nashville Predators and Nashville Sounds. Some of Nashville's living advantages include:

-- low cost of living (including NO state income tax)
-- international airport
-- unique, affordable residential areas
-- abundant parks, waterways and recreational areas
-- lively cultural base
-- diverse economic base
-- seasonal climate

Visa sponsorship is not available for this position.
No third party recruiters/agencies.