With moderate direction, is responsible for implementing EDI (Electronic Data Interface) inbound and outbound data feeds for clients and third party administrators in accordance with established SLAs (Service Level Agreements). With limited direction, this position works with Oracle packages and procedures, Microsoft SQL Server stored procedures, and data objects to identify and correct data issues and system defects. In addition, this position involves writing SQL queries and scripts to support custom reporting requests, resolves data integrity issues and recommends process automation for large Oracle and Microsoft SQL Server database applications. REPORTING STRUCTURE & WORK SETTING This position typically performs work at a WageWorks site and reports to a Supervisor or Manager of Data Integration Services or another leader with responsibility for data integration. Essential Duties & Primary Accountabilities NOTE: The essential duties and primary accountabilities below are intended to describe the general content of and requirements of this position and are not intended to be an exhaustive statement of duties. Incumbents may perform all or most of the primary accountabilities listed below. Specific tasks, responsibilities or competencies may be documented in the incumbents performance objectives as outlined by the incumbents immediate supervisor or manager. Ability to interact and communicate professionally in an advanced verbal and written form with internal and external clients, vendors and third party administrators. This includes, but is not limited to, creating meeting agendas, hosting/facilitating meetings, managing the flow of information between groups or departments to ensure issues are resolved effectively, collaborating and coordinating with other IT groups and business units to support efforts to maintain data integrity, and educates clients and vendors on issues to facilitate communications. Analyzes, identifies and resolves data conditions and anomalies in an efficient and effective manner by utilizing Microsoft SQL and/or Oracle scripts. Creates detailed mapping plans to implement inbound or outbound participant file feeds (including eligibility, enrollment, and payroll information). This includes collaboration with a third party vendor, developing an implementation plan, testing files (Quality Assurance) and moving to production. Produces written specifications to capture business process requirements for proposed solutions. Marginal Duties & Additional Functions Performs other duties as assigned or apparent. Education ESSENTIAL KNOWLEDGE, SKILLS & ABILITIES Work Experience Or Related Experience Two to three years experience implementing electronic data files or maintaining large amounts of data in a client-facing environment. Basic SQL query formulation experience such as select and update statements while updating parameters based on requirements. Specialized Knowledge, Skills & Abilities Driven for results and displays a sense of urgency. Ability to quickly assess client and systems issues as well as research and investigate technical system transactions. Good organizational skills and the ability to manage competing priorities in a frequently interrupted environment are essential. The ability to work independently, using individual judgement with limited supervision is also required. Advanced problem solving and troubleshooting skills are essential. The ability to identify trends in data or process issues, analyze data and report issues to management is required. A good knowledge of file transfer protocols is essential. Advanced knowledge of SQL language and ability to read and edit existing SQL scripts.
Oracle, Macros, SQL - Structured Query Language, MS Excel, Toad
Apply on company website