SQL/ETL Developer I
The Job Network
Menasha, United States of America
1 month ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
English Experience level
IntermediateJob location
Menasha, United States of America
Tech stack
Macintosh Application Environment
Databases
Data Integration
ETL
Relational Databases
Software Debugging
Design of User Interfaces
JSON
Systems Development Life Cycle
Standard Sql
SQL Databases
SQL Server Reporting Services
SQL Server Integration Services
XML
Information Technology
Job description
The ETL Developer I is part of a team dedicated to supporting Network Health's core claims processing system, related data integrations, vendor extracts and reporting. This individual will perform detailed interface design and development, program, analysis, coding, testing, debugging, documentation, implementation of interfaces and reports, development, and maintenance of data feeds for Network Health., * Develop, test, and maintain data interfaces between business data sources in accordance with departmental and professional standards
- Perform analysis, design, coding, and maintenance of data imports and extracts
- Develop, test, and implement data change scripts to support the claims processing system
- Consult with Business Quality Analysts, Developers, Engineers, DBAs, key departmental stakeholders, and leadership on technical solutions and best practices
- Monitor and audit jobs for performance. Recommend changes as appropriate. Advise management on how to improve application environment and system performance
- Maintain effective communication with customers from all departments for system development, implementation and problem resolution
- Develop and maintain reports and data extracts supporting both internal and external customer's needs
- Required to take call to assist in resolution of technical problems. May be required to work later hours when system changes are being implemented or problems arise
- Other duties and responsibilities as assigned
Requirements
- Requires BS in Computer Science, Business, or related technical field or equivalent years of experience may be substituted
- Minimum of 2 years' experience in program interfacing required, preferably in a healthcare or health insurance environment
- Excellent analytical skills
- High degree of experience with relational database design, and SQL
- Knowledge of SSIS, SSRS, XML/JSON, and virtual database architecture
- Collaborate on teams leveraging lean, scrum, or agile type of development methodologies
Benefits & conditions
Hours: 1.0 FTE, 40 hours per week, 8am-5pm Monday through Friday