Sr. ETL/Cognos developer to develop and maintain ETL workflow solutions and reporting solutions for a BI reporting project

Our valued public sector client is looking for a Sr. ETL/Cognos developer to develop and maintain ETL workflow solutions and reporting solutions for a BI reporting project.

The department is currently using an Enterprise Data Warehouse that contains Real Property Data.  Using framework manager, the successful candiate will support efforts to populate and determine fields for data marts, develop, execute, assess, modify and document technical solutions requirements to support Analytics Solutions BI projects

Tasks include:

• Design, develop and maintain the various Extract, Transform and Load (ETL) workflow solutions consisting of data conversion process models, ETL specifications and ETL code
• Create and publish ETL documentation, including design, maintenance, production deployment instructions and other related ETL Process documentation
• Define, document and develop unit test cases and participate with User Acceptance Testing
• Elicit requirements using interviews and workshops and demonstrated experience translating requirements into use cases and/or workflows
• Define and build the BI metadata layer based on the business requirements
• Review and analyze ERP data from multiple internal and external sources
• Write SQL scripts to create data extracts
• Develop enterprise-wide data analysis and reporting solutions using IBM Cognos Business Intelligence (BI) Tools Suite
• Develop ETL solutions using SSIS (SQL Servier Integration Services)
• Implement technology best practices, guidelines and repeatable processes
• Provide technical assistance and cross-training to other team members and assisting users with data solutions
• Develop data loading and transformation projects
• Analysis of large data sets and optimize SQL code
• Troubleshoot and resolve production issues under tight deadlines
• Support the system’s operations including monitoring, troubleshooting, logging issues and performing recovery procedure tasks
• Implement technology best practices, guidelines and repeatable processes

Must have:

• Prior experience designing, developing, and maintaining ETL workflow solutions
• Prior experience using IBM Cognos BI tools suite
• Prior experience with SSIS (SQL Server Integration Services)