Data Integration Engineer in McMinnville, Oregon - #67764 | VanderHouwen

Description

Job Id: 67764

Data Integration Engineer
This position is responsible for the analysis, design, documentation, development, unit testing, and support of data integration and database objects development for software applications on both on-premise and cloud infrastructures utilized by staff and strategic partners. The Data Integration Engineer works closely with the Sr Director of Information Systems (IS), the IS team, leadership team, colleagues, and strategic partners to understand business and operational requirements and implement data integration solutions, processes, and procedures  to meet those needs.

This is a remote position.

Essential Duties
Provides support and guidance regarding data integration and SQL best practices.
Operates in tandem with internal resources to define and implement development standards.
Authors and reviews system designs, provides implementation plans, and implements data integration solutions.
Develops strong business relationships and cross-functional partnerships with colleagues and technology partners to analyze business and operational needs.
Develops and implements IS solutions aimed at meeting current needs while positioning for future strategic direction.
Leads implementation of data integration efforts from inception to completion.

Job Duties
Collaborates with stakeholders and IS team members to achieve business objectives.
Works closely with other data engineers to integrate databases with applications as needed.
Designs, develops, and implements database processes and solutions for managing and integrating data between operational systems, data repositories, and analytical reporting applications. This includes but is not limited to ETL, stored procedures, views, and functions.
Recommends and provides guidance regarding data integration, database development, SQL best practices, and development standards as needed.     
Creates and proposes technical design documentation including current and future functionality, database objects, specifications, and flows/diagrams detailing proposed database and/or data integration implementations.
Translates stakeholder requirements into common language that can be easily digested and understood by non-technical business users.
Provides support in investigating and troubleshooting production issues.
Participates in the establishment of IS development standards and processes.
Works continually to improve performance and reliability of source code and automated scripts using industry standard methodologies.
Evaluates, tests, and recommends new opportunities for enhancing software, hardware, and IS processes.
Ensures smooth delivery and operation of organizational information systems, 3rd party software applications, and IS support systems by monitoring, measuring, and, when necessary, improving systems’ performance.
Coordinates and, as necessary, completes IS activities to ensure the availability of data, network services, and software systems to maximize uptime. 
Uses task management tools and methodologies to ensure smooth implementation of IS processes.
Improves training and operational procedures related to organizational IS infrastructure and business systems to increase productivity and streamline processes.
Engages strategic partners and contracted providers in Health Information Technology (HIT) initiatives as required. 
Represents company within pertinent external committees and workgroups.
Compiles and distributes reports of interest to leadership team, including status reports on IS initiatives.

Essential Department & Organizational Functions
Participates in the preparation and submission of regulatory and contract required deliverables.
Works closely with other departments, including Health Plan Operations and Quality Assurance and Compliance, to assist with audits, including the External Quality Review (EQR), as needed.
Proposes and implements process improvements.
Meets deadlines for completion of workload.
Maintains agreed upon work schedule.
Demonstrates cooperation and teamwork.
Provides cross-training on specific job responsibilities.
Meets identified business goals that contribute to departmental goals.
Maintains punctual, regular, and predictable attendance.
Works collaboratively in a team environment with a spirit of cooperation.
Respectfully takes direction from supervisor.
Other duties as assigned. 

Knowledge, Skills, & Abilities
Takes on new opportunities and challenges with a sense of urgency, high energy, and enthusiasm.
Effectively builds formal and informal relationship networks inside and outside of company.
Establishes partnerships and works collaboratively with others to satisfy needs and meet shared objectives.
Strong task management skills with ability to direct assignments from inception to completion.
Effective listener and excels in written and verbal communications, with ability to translate complex ideas into simple language for non-technicians.
Holds self and others accountable to meet commitments.
Gains the confidence and earns the trust of others through honesty, integrity, and authenticity.
Knowledge, Skills, & Abilities continued ~
Operates effectively, even when things are not certain, or the way forward is not clear.
Maneuvers comfortably through complex policy, process, and people-related organizational dynamics.
Plans, organizes, and prioritizes work to meet commitments aligned with organizational strategies, goals, and objectives.
Sharp problem-solving, analytical and innovation skills.
Ability to quickly become up-to-date and knowledgeable in new subject matters.
Respectful of all colleagues and individuals with whom communication and collaboration transpires.
Acknowledges personal strengths and weaknesses, owns mistakes, pauses to learn lessons, and carries lessons forward to improve future outcomes.
Understands business, team, assignments, and individual goals, initiates and maintains focus on matters of priority.
Excellent organizational skills and ability to manage multiple tasks and timelines simultaneously, as well as to perform work with attention to detail.
Ability to work independently when needed, use sound judgment, anticipate next steps, and is proactive.
Ability to work in an environment with diverse individuals and groups.

Qualifications Required
Bachelor’s degree in Information Technology, Programming, Management Information Systems, Computer Science, Business Administration, or related field,
Minimum of five (5) years of experience in software engineering, data integration technologies and principles,
Minimum of five (5) years applicable experience, preferably within a health plan setting,
Advanced knowledge of SQL, including complex SQL queries and best practices, SQL performance tuning techniques,
Strong technical credentials, including hands-on cloud solution experience,
Established skill designing and developing solutions to complex problems in a distributed systems environment,
Experience with X12 data mapping and conversions, RESTf API’s including FHIR.
OR: Any combination of education and experience that would qualify candidate for the position.

Preferred
Demonstrated experience leading information systems improvement projects.
Experience in establishing and fostering interpersonal relationships, written and verbal communication, teamwork, and conflict resolution.
Demonstrated ability to organize, prioritize, plan, and follow through on multiple complex assignments and projects.
Experience working within a government-sponsored health plan, preferably a managed care plan, or thorough familiarity with health plan operations.
Knowledgeable of HIT enabling health plan operations such as Enrollment and Eligibility systems, Claims Processing systems, Utilization / Disease / Care Management systems, Community Information Exchange, Electronic Health Records, Health Information Exchanges, Provider Portals, Member Portals, and Digital Health Solutions.
Experience with Tableau and cloud-based infrastructure environments.
Established experience with modern development tools such as .NET, Python, Java, distributed systems development, REST web services, GIT, GITHub, and relational databases.
Experience integrating data from structured and unstructured formats: flat files, XML, EDI, JSON, EXCEL.

Salary: $90,600 – $115,700 (DOE)

Meet VanderHouwen
What kind of recruiter do you see yourself working with? One who prioritizes your best interest, no matter what? VanderHouwen does, and we're in it for the long game! Our recruiters focus on YOU, building meaningful, long-term relationships while developing a deep understanding of companies' staffing needs and workplace cultures. This approach helps us find an ideal job match that aligns with your unique career aspirations and goals.

VanderHouwen is an award-winning, Women & Diversity-Owned, WBENC certified professional staffing firm. Founded in 1987, VanderHouwen places experienced professionals across the nation! Our recruitment teams specialize in either Technology and IT, Engineering, Human Resources, or Accounting and Finance career markets. Partner with us to land your next exciting career!

VanderHouwen is an Equal Opportunity Employer and participates in E-Verify. VanderHouwen does not discriminate based on race, color, religion, sex, national origin, age, disability, or any other characteristic protected by applicable local, state, or federal civil rights laws.

#LI-Remote