A319- BI Developer

12-month contract or until the project goes live. Hybrid position with a need to be in office at least once a week. Hiring TN residents only. Government  showing you are a resident of TN

Our direct client has an opening for a BI Developer in Nashville, Tennessee, this contract is 12 months, with the option of extension.

Please send us your rate and resume if you are interested.

• Under the supervision of the strategic data management & solutions team, the developer is responsible for creating a data system project from raw data collection to the report output tables using Microsoft business intelligence solutions.
• This requires creating a 3-layer data process, creating an automated data collection using ETL process, data integration layer into the warehouses and building analytical data cubes.
• The role involves working with the stakeholders to understand the needs, translating them into technical requirements and delivering project outcomes within the timeline.
• Create database and schema objects to build the fiscal system from historical files.
• Automate the raw data collection from FTP client server sources (CSV, Excel etc.file).
• Set up FTP tasks for mail notifications and send mail task packages using SSIS.
• Create and automate ETL process using SSIS to load clean data into the system.
• Develops, configure and deploy SSIS packages. Implement event handlers and error handling notifications.
• Create and connect error reports (BI reporting tools) for the data submitters from the raw data files.
• Write complex queries to build joins and data logic for business definitions using T-SQL scripts.
• Build data relationships and create Dimension and Fact tables to maintain a consistent final output through calculated fields.
• Design/develop/optimize stored procedures for data warehouse tables.
• Perform testing, troubleshooting report issues and optimizing query performance.
• Build OLAP cubes/Data Mart for analytical reporting.

• Bachelor’s degree or equivalent education in computer science, math, or related science field required.
• 5+ years proficiency in SQL Server/T-SQL language required.
• 5+ years proficiency using Microsoft tools (SSIS, SSAS, BI reporting tools) required.
• 4+ years’ experience as an ETL developer.
• 5+ years of experience in business intelligence development area building data warehouses & data marts required.
• Work experience in the Fiscal/Finance industry is preferable.

• Latest versions of Microsoft BI technologies. (SSIS, SSAS, SSRS, Power
  
  BI)
• Data warehousing. (star schema, snowflake schema)
• Dimensional modeling.
• ETL processes.
• Data Analysis & troubleshooting.
• Analytical Thinking.

We are an equal opportunities employer and welcome applications from all qualified candidates.