Job Details
Job Id:
Data Modeler Architect
Job Type:
Contract to Hire
Franklin TN 
A client in the Franklin, Tennessee area is seeking a Data Modeler Architect for a 6-12 month contract-to-hire position. Any individual working this role must work the first month on-site. After that period of time, if they live more than 2-3 hours from the office, they can work a hybrid schedule; 50% on-site and 50% remote. Individuals living closer than that to the office must work full-time on-site.

• Work independently and as a part of a team to deliver data transformation and reporting solutions
• Design and create reports with SSRS utilizing data in the existing data warehouse and other data sources, including any new warehouses
• Model and manage changes in the client’s data warehouse structure, as well as data transformation (ETL with SQL and SSIS) between different data sources
• Facilitate and perform upgrades of the current data warehouse tools and platforms
• Monitor and maintain existing SSIS jobs that transfer data between the client’s web and AS400 platform
• Create, test and deploy new SSIS processes as needed for data transformation
• Informal leadership of other BI team members – assist the Director and Project Managers to ensure roadblocks are identified and overcome

Required skills:
• 7+ years of relevant experience
• Administration, design and usage of at least one structured reporting tool such as Cognos, Business Objects, Micro Strategy, Microsoft PowerBI, etc.
• SSRS, including report bursting with SSRS enterprise edition
• ETL experience with SSIS
• MS SQL experience with complex queries or significant experience in writing complex standard SQL queries on other relational database platforms
• Dimensional data modeling for analytical processing
• Full SDLC methodologies
• Excellent communication skills, both verbal and written
• Strong analytical and problem solving skills

Preferred skills:
• Administration and development experience with Cognos and/or MS SSRS
• Jira and agile development methodologies
• Relational data modeling for transactional processing
• Experience with the Insurance Industry

• An Associate’s degree or Bachelor’s degree is preferred

Other Requirements:
• 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. 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.
Relocation assistance is not available for this position.
No third party recruiters/agencies.