RevSpring, Inc. is an Equal Opportunity Employer (Minorities/Females/Disabled/Veterans).  To read more about this, view the EEO is the Law poster and this EEO is the Law Poster Supplement

Data Integration Engineer
Job Code:20-351
Location:Ann Arbor, MI
Job Status:Regular Full Time
  

Position Summary:

Supports data warehouse performance by planning and delivering data integration code

 

Job Duties:

  • Enhances data integration team accomplishments and competence by planning delivery of solutions;
  • Studies data sources by interviewing users; defining, analyzing, and validating data objects; identifying the relationship among data objects.
  • Plans data integration process by developing common definitions of sourced data; designing common keys in physical data structures; establishing data integration specifications; examining data applications; examining data models and data warehouse schema; determining best-fit data interchange methods; assessing middleware tools for data integration, transformation, and routing; developing project scope and specifications; identifying factors that negatively impact integration; establishing delivery timetables.
  • Delivers data integration by implementing shared databases; integrating data across environments; developing system modification specifications; mapping data; establishing interfaces; developing and modifying functions, programs, routines, and stored procedures to export, transform, and load data; meeting performance parameters; resolving and escalating integration issues; coordinating actions among users, operations staff, and outside vendors; recommending adjustments as objectives change; documenting operational procedures and data connections.
  • Validates data integration by developing and executing test plans and scenarios including data design, tool design, data extract/transform, networks, and hardware.
  • Maintains data warehouse performance by identifying and resolving data conflicts; upgrading data definitions;
  • Improves data integration by designing and evaluating new data interchange formats; improving physical design; rewriting data policy, standards, and procedures;
  • Maintains team accomplishments by communicating essential information; coordinating actions; obtaining expert input; reviewing open issues and action items; contributing information to team meetings and reports; transferring knowledge of data integration process, techniques, and issues to application and support teams.
  • Updates job knowledge by tracking ETL strategies and technologies; participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
  • Accomplishes organization goals by accepting ownership for accomplishing new and different requests; exploring opportunities to add value to job accomplishments.

Position Responsibilities:

Position Requirements

  • A bachelor’s degree in information systems, computer science, mathematics, engineering or other related field
  • 1 – 3 years’ experience in a data integration/ETL environment using SSIS, T-SQL or other ETL software
  • Strong SQL/T-SQL skills, including the ability to write queries, stored procedures, triggers, functions and etc.
  • Solid understanding of data systems, including data relationships and data modeling with the ability to learn and understand various data environments
  • Excellent analytical and problem solving skills
  • Effective written and oral communications skills in English
  • Ability to work with geographically dispersed teams
  • Sound planning and organizational skills with a strong attention to detail
  • Demonstrated ability to handle multiple concurrent projects and priorities in a fast-paced, evolving environment
  • Work independently and with others; self-directed and results-oriented
  • Excellent interpersonal skills
  • Willingness to learn new technologies to best solve data-related issues
  • MS SQL-Server experience preferred

Preferred Education & Experience:

Desired Knowledge & Skills: