Job Details
Job Id:
Data Warehouse Engineer
Job Type:
Brentwood TN 
A local client in the Nashville, TN area is seeking a Senior Data Warehouse Engineer for a permanent position.

This individual will serve as a senior member of the Informatics EDW group which builds and supports the Enterprise Data Warehouse to deliver strategic business value to the organization. The Senior Data Warehouse Engineer collaborates with product owners to plan and define requirements, and then works with the implementation team to design, develop, test, and maintain a high-performance data warehouse environment. The Data Warehouse architecture delivers BI capabilities including pre-defined, ad-hoc, dynamic reporting, OLAP analysis, and dashboards as well as data sharing interfaces with other systems.

• Create Oracle PL/SQL packages, complex stored procedures, partitioned tables and ad-hoc queries to support development and business needs
• Assist other database engineers with the day-to-day activities, including database maintenance such as installation, backup, restore and security control
• Collaborate with stakeholders to plan and deploy new database releases
• Analyze query performance and perform query tuning to assist development engineers in designing and optimizing queries
• Troubleshoot production support issues in the application environment
• Work as a part of a development team to implement product enhancements
• Collaborate with BI developers and product managers on delivery of reporting initiatives
• Extract data from disparate sources and transform that into internal formats for loading into the client’s platform.
• Perform technical analysis and requirements definition with the client’s partners on service integrations
• Work as a part of an Agile team to implement product enhancements

Required skills:
• At least 10 years of experience with ETL design & development in data warehouse using traditional SQL databases like Oracle
• At least 5 years of experience in Data Warehouse, data modeling, and various data warehousing techniques like star schema, etc
• At least 5 years of experience with ANSI-SQL and Oracle PL/SQL; must have expertise in SQL
• At least 5 years of demonstrated success in multidisciplinary roles in complex data warehouse, business intelligence or measurement projects
• At least 3 years of demonstrated knowledge of Agile DW/BI best practices
• Critical thinking abilities to take complex, ambiguous, abstract requirements and break them into smaller components, patterns, views and features
• Strong ability to communicate technical and data concepts to non-technical audiences, and business concepts to technical audiences
• Strong analytical, organizational, verbal communication and business writing skills

Preferred skills:
• At least 5 years of experience with database design and architecture for relational/NoSQL databases
• Familiarity with database design and architecture for a data warehouse
• Experience architecting, designing, implementing, managing and supporting OLTP, OLAP or Warehouse Database Management Systems
• Understanding of quality assurance and data quality principals as applied to an ETL architecture

• A Bachelor’s degree in computer science or a related field 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.