BI / Data Integration Engineer

Translate business requirements into specifications that will be used to implement the required reports and dashboards.• Work with business units to gather requirements, development and delivery of business intelligence & reporting services. • Working with a variety of data formats, primarily - flat files (CSV, XLS), and XML/ SOAP / JSON / JMS. • Creating SQL Queries to extract the requested data from a variety of source databases. • Performance tuning Stored Procedures for maximum efficacy. • Creating a reusable / repeatable process in SQL Server Integration Services (SSIS) • Deploying and executing SSIS Packages • Running SSIS Packages in SQL Server Data Tools (SSDT) to debug and test packages to ensure they are in the correct format requested• Develops and implements business intelligence & analytics to support organizational initiatives.• Design, model, develop & optimize BI solutions to meet data management and data reporting objectives.• Troubleshoot and resolve issues with the processes used and the content produced by the BI platform.• Work with business stakeholders to define and improve standardized and ad-hoc analytics/reporting capabilities.• Work as part of the BI team to maintain and develop all components of the BI platform.• Provide ongoing maintenance support through troubleshooting, report modifications and optimization.• Provide input into the technical architecture and the data warehouse technology stack.• Create functional and technical design documents and maintain documentation for all reports and dashboards created or modified• Creates and maintains positive, cohesive work environment.KNOWLEDGE, SKILLS AND ABILITIES• In-depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework• Excellent verbal and written communication skills.Page 2 of 2• Excellent project management skills including the ability to prepare prioritize and complete work plans.