A319- BI Developer 64160

• 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 usingc 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/DataMart 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 preferrable.

Skills & Strengths:

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

312 Rosa Parks Ave.,9th Floor Nashville, Tennessee 37243 Data Analysis: Proficient (4-6 Years)Data Modeling: Proficient (4-6 Years)Data Warehousing: Advanced (7-9 Years)Microsoft SQL Server: Advanced (7-9 Years)Transact-SQL: Advanced (7-9 Years)SQL: Advanced (7-9 Years)Microsoft BI (Business Intelligence Development): Advanced (7-9 Years)Teamwork: Advanced (7-9 Years)Visual Studio: Proficient (4-6 Years) Bachelors or Masters in Computer Science, Math, or related science field: Proficient (4-6 Years)