Pitney Bowes Senior Database Analyst in Shelton, Connecticut
Senior Database Analyst
PB Professional Services Inc. has an opening for a Senior Database Analyst in Shelton, CT.
Work within analytical team delivering enterprise-class software. Evaluate, analyze, design and implement complex ETL (SSIS) solutions based on technical requirements for Microsoft SQL Server, SAP, MySQL and Vertica databases. Understand source and target data structures, ETL processes and products to develop Data Integrations. Implement best-in-class governance solutions to provide for system-development-life-cycle (SDLC) controls and a controlled in-flight change management process. Manage requirements gathering, analysis, development of test scenarios, test cases, test Scripts by using Requirement Traceability Matrix. Conduct functional, System Integration, Regression testing and participate in defect review meetings creating defect tickets in Jira tool. Work with internal Application Development Teams to support design and deploy changes to production. Work with Finance/ Accounting team to design and code revenue recognition for different business models. Translate billing and contracts into data base design and architecture for automated calculation for finance and billing. Work with multiple vendors inside and outside to receive data for online –web based transactions which help analyze business and finance team. Solve unique and complex problems to assist critical business partners with financial analysis, including implementing data visualization solutions. Drive automation of Account Reconciliations and financial processes for Business transactions. Assist with month-end Accounting Close for the Commerce Services business, and with automation of Month-end Reporting Tableau.
Must possess at least a master’s degree or its equivalent in Business, MIS, Operations Research or related field and at least 3 years of prior work experience as an ETL / Data Analyst / QA Analyst. In the alternative, at least a bachelor’s degree or its equivalent in Business, MIS, Operations Research or related field and at least 5 years of prior progressive work experience as an ETL / Data Analyst / QA Analyst would be acceptable. Must also possess at least 3 years of data mining experience; at least 2 years of experience with Tableau or PowerBI; at least 2 year of experience with SSIS or ETL technologies; at least 2 years of experience in developing stored procedures, views, functions, triggers and advanced logical methods; at least 2 years of experience using statistical methods to analyze data and generate useful business reports; and at least 2 years of experience using MS Office and focusing on advanced Excel skills(Look-up function, VBA, macros, Complex Logical Statements).
Apply online at https://careers.pitneybowes.com/
Job: Information Technology
Title: Senior Database Analyst
Requisition ID: 181565