Data Integration Engineer II

Department:

Identity & Access Management

-----

Data Management and Database Administration

Position Title:

Data Integration Engineer II

Job Family Group:

Professional Staff

Job Description Summary:

The Data Integration Engineer II is responsible for the analysis, design, configuration, and development of integration solutions for multiple applications. Additional contributions will include legacy data integrations, technical design documentation, and communication of designed solutions to business partners. Collaboration is crucial with all participants inclusive of project managers, developers, business analysts, technical administrators, testers, and program management.

Job Description:

Job Duties

• Gather requirements, analysis, and design on new projects.
• Works on moderately complex to complex projects
• Generally independent, but occasionally directed in aspects of the work.
• Manages assigned projects.
• Propose, conceptualize, design, implement, and orchestrate solutions from end-to-end integration and be responsible for the applicable technical architecture.
• Lead and manage integration flow development, as necessary, for application and data integration.
• Ensure work completion within schedule and design constraints; Conduct analysis, design, and testing; solve moderately complex technical problems; supply alternative methods for achieving goals when necessary.
• Identify and propose efficiency improvements in existing integration processes.
• Collaborate with technical architects & leads, product owners, infrastructure support, and external teams.
• Write the data mapping & transformation, workflow & process flow of an ETL job.  Mainly using tools like T-SQL, SSIS, and PowerShell.
• Add integrations for new users to the Billing Engine from their source data to the Billing Engine Database.
• Aid users and developers with SQL database backend development. 
• Maintain/Add/Improve Billing Engine processes and ETL’s.
• Suggest quality improvements to SQL databases on several servers and instances.
• Produce reports to report analytics on projects using Power BI or other technology.
• Create and maintain documentation, workflows, processes, procedures, and guidelines as related to assigned projects.
• Train other staff, as necessary, working on all phases of the application development lifecycle.
• This job description is not designed to cover or contain a comprehensive listing of activities, duties or responsibilities that are required of the employee for this job. It is only a summary of the typical functions of the job, not an exhaustive list of all possible job responsibilities, tasks, duties, and assignments. Furthermore, job duties, responsibilities and activities may change at any time with or without notice. 

Required Qualifications

Education

• Bachelor's degree. Work experience may be substituted for the required education on a year for year basis.
• Fifteen education hours in computer programming which may be substituted for two years of computer programming work experience. 

Work Experience

• Experience in designing, developing, testing, and deploying data integrations.
• Experience with API and Web Services (REST/SOAP)
• Experience with data design, architecture, and data modeling
• Experience with Power BI or other analytical tools
• Experience with SSIS and SSMS

Preferred Qualifications

Work Experience

• Experience leading, coaching, and mentoring junior members of varying skill levels.
• Experience with project management practices, frameworks, and methodologies (Agile/Scrum)
• Expert knowledge of SSIS and SSMS
• Expert knowledge of analytical tools

Skills

• Communication skills, both written and verbal, along with interpersonal skills with technical and non-technical clients
• Skilled at defining and solving logical problems for moderately technical applications.

Required Documents

• Resume
• Cover Letter

Comprehensive Benefits Package:

Coverage begins on day one for health, dental, and vision insurance and includes health expense accounts with generous employer contributions if the employee participates in a qualifying health plan. Employer-paid life insurance, long-term disability insurance, and various additional voluntary insurance plans are available. Paid time off, including vacation and sick, begins accruing upon hire, plus ten paid holidays. One paid discretionary day is available after six months of employment, and paid time off for bereavement, jury duty, military service, and parental leave is available after 12 months of employment. A retirement program with a generous employer contribution and additional voluntary retirement programs (457 or 403b) are available. https://www.kumc.edu/human-resources/benefits.html

Employee Type:

Regular

Time Type:

Full time

Rate Type:

Salary

Compensation Statement:

The pay range listed for this position is determined by our compensation program using market data and salary benchmarking. A combination of factors is considered in making compensation decisions including, but not limited to, education, experience and training, qualifications relative to the requirements of the position, and funding. At the University of Kansas Medical Center, a reasonable estimate for the starting pay range will be the minimum to midpoint of the posted range, taking into account the combination of factors listed above. 

Pay Range:

$83,000.00 - $131,000.00

Minimum

$83,000.00

Midpoint

$107,000.00

Maximum

$131,000.00